View Single Post
Old October 23rd, 2009, 05:11 PM   #1 (permalink)
k23m
Junior Member
Verified Customer
 
Join Date: Dec 2006
Posts: 9
upgrade/install error

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:
Quote:
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
Quote:
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!
Quote:
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.
k23m is offline   Reply With Quote