I just upgraded my pp to 6.2, and now I am re-running the install.php in order to integrate with an upgraded phpbb3 (from phpbb2).
I am on one of the last steps, and its giving me this error:
Error: Are you certain that your database prefix is set properly?
I cannot see your phpBB2 "groups" table.
The prefix setting adds characters to the front of phpBB2 table names - please doublecheck this.
I have checked the prefix -its set correctly (its default). But why is it telling my phpBB2 in this error? I have selected phpBB3 as the forum integration...
I was following instructions in another upgrade post which said
3. delete any usergroups entries under your usergroups table in photopost database
so I have done that in the pp db...is this what caused the error? It feels related...maybe?
Also, in the previous step I had some db errors...this could also be the problem I guess!
Step 3: MySQL error reported: [INSERT INTO pp_categories (id,catname,description,catorder,thumbs,parent,children) VALUES (500,'Member Galleries','Individual user galleries - any photo category',1,'yes',0,'')]
Result: Duplicate entry '500' for key 1
Step 3: MySQL error reported: [INSERT INTO pp_settings VALUES (1,'Title for your PhotoPost Application','galleryname','','My Photo Gallery',1,1)]
Result: Duplicate entry '1' for key 1
Step 3: MySQL error reported: [INSERT INTO pp_settings VALUES (2,'Web site name','webname','','My Website',2,1)]
Result: Duplicate entry '2' for key 1
I have checked the actual database, and checked the config file...it says
$table_prefix = 'phpbb_';
I know...it would seem it is wrong, since thats exactly what the error says...but since I upgraded from phpbb2 to bb3, and used the same databse, I dont think my prefix is phpbb3_ ...
Could I have done something wrong in a previous step?
You dont think its because I deleted the entries in the pp usergroups table? If it was, I am not sure how to get it back...unless I go back to the original db backup I made before the upgrade...and start over..which I would love to avoid!
ok...I guess it was my dumb mistake ... (you probably already thought that!) I was using the old forum db info. For some reason I thought they were the same (old and new forum db's) - I forgot I created a new one and imported the old data.
Thanks...problem solved! Thanks for your speedy help.