upgrade/install error

[k23m]

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
Database: d60241050

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
Database: d60241050

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
Database: d60241050

Step 3: MySQL error reported: [INSERT INTO pp_settings VALUES (3,'Your Website URL (include http://)','domain','','http://www.domain.com',3,1)]
Result: Duplicate entry '3' for key 1
Database: d60241050
...theres more like this....

Thanks in advance for your help.

[Chuck S]

I would not worry about duplicate entries that just means your photopost already exists

about your groups table error that tells me you are not entering the correct table prefix where asked on step 4

Usually its phpbb_

[k23m]

Originally Posted by Chuck S

about your groups table error that tells me you are not entering the correct table prefix where asked on step 4

Usually its phpbb_

Yes it is, and thats what I have entered...but it doesnt like it!

[Chuck S]

well then I would suggest you double check your information as it is not correct then.

Maybe its phpbb3_

You can check your phpbb3 config file and check.

[k23m]

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!

[k23m]

why is the error saying phpbb2? Is it still stuck with bb2 for some reason because I am installing over top of the old version, even though I have told it 3 now?

[Chuck S]

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.

Thats pretty specific whatever you putting in there it cant find the phpbb groups table. You sure your forum database is correct on the config portion also?

[k23m]

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.

[Chuck S]

glad your all sorted enjoy your weekend.