hi i need your help
my board version is now phpbb3.0.2 and i have installed all of SEo mods except seo monitor now i want to upgarde it.

i thouthg this way is good so plz tell me is it wright or not?
i want to get the phpbb3.0.2 to 3.0.4 db update and run it,then get the phpbb3.0.4 core from phpbb.com and do the mods change on it and replace my new forum folder with old one.(with all needed persmisson and..)

but because i have so many mods installed for template ( i use sub2) i want to get the phpbb3.0.2 to phpbb3.0.4 code changes packages and do it manually.but i dont know is this package on phpbb.com?

and another question my seo mods are:
adv_phpbb3_mod_rewriteV0-4-4
phpBB3_no_dupeV0-4-2
phpbb3_seo_dynamic_meta_tagsV0-2-4
phpBB3-SEO_Optimal_titlesV1-0-2
phpBB3-SEO-Zero-dupe_V0.4.4

which of them shoud i use new version for 3.0.4 ?

best regards

I answered you there :
http://www.phpbb-seo.com/boards/gym-sit ... html#23846
But I assumed you where using the premod, maybe it could be time to go for it now since it would not be more work for you (you're already using all our mods here).
For extra theme, the easiest is still to compare your them with an up to date version and merge it, but you have code change file for themes only on phpBB.com which can help you out too.

thank u so much i'll answer my question on that topic

hi another question:
my seo mods version are:

Code: Select all

and another question my seo mods are:
adv_phpbb3_mod_rewriteV0-4-4
phpBB3_no_dupeV0-4-2
phpbb3_seo_dynamic_meta_tagsV0-2-4
phpBB3-SEO_Optimal_titlesV1-0-2
phpBB3-SEO-Zero-dupe_V0.4.4

wil them work on phpbb3.0.4?

Well, they should for most, but due to some change in the way groups are dealt with, mod rewrite won't for groups and most likely error will show up with the new 3.0.4 code.

So, you'd better update all of them in a row, it's not that hard, even easier if you went for the premod

thank u.i'll test it

hi again.
for updating all seo modules we don't need data base change is it right>?
at local first i updated my data base from 3.0.2 to 3.0.3
then i upgarded db from 3.0.3 to 3.0.4.

and then i put my forum folder (with all my change mods).but i got this error when i go to forum index :

Code: Select all

SQL ERROR [ mysql4 ]

Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'find_in_set' [1267]

SQL

SELECT code, ID, position FROM phpbb_ad WHERE (max_views >= views OR max_views = '0') AND (FIND_IN_SET(0, show_forums) > 0 OR show_all_forums = '1') AND FIND_IN_SET(5, groups) ORDER BY rand()

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()

FILE: includes/functions.php
LINE: 3754
CALL: dbal_mysql->sql_query()

FILE: index.php
LINE: 185
CALL: page_header()

and here is the files that says are wrong:
http://professional.parsaspace.com/mistakes.zip
what is the problem?

any idea? the SQL code are:

Code: Select all

CREATE TABLE `phpbb_ad` (
  `ID` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `code` text NOT NULL,
  `show_forums` varchar(255) NOT NULL default '0',
  `show_all_forums` int(11) NOT NULL default '0',
  `views` int(11) NOT NULL default '0',
  `position` tinyint(1) NOT NULL default '0',
  `max_views` int(11) NOT NULL default '0',
  `groups` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ID`),
  KEY `groups` (`groups`(1),`show_forums`(1))
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Make sure you run the latest install/database_update.php, it's not a problem to run it more than once, and it's directly updating the db to the latest version whatever the version your started with (phpbb3).

Then, about the add mod code, it looks like a db structure issue, did you change dbms (from mysql 4 to 5 for example) ?

What add mod are you using ?

Hello I'm new to you and love is all useful topics that learning from them