Request for help please ... Photopost 5.3

[WayneH]

OK, I spoke a bit too soon ... when I ran the install.php I got lots and lots of errors ...

Here are the first few!

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 'PRIMARY'
Database: resourcesdb

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 'PRIMARY'
Database: resourcesdb

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 'PRIMARY'
Database: resourcesdb

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 'PRIMARY'
Database: resourcesdb

Step 3: MySQL error reported: [INSERT INTO pp_settings VALUES (4,'Administrator Email Address','adminemail','','admin@domain.com',4,1)]
Result: Duplicate entry '4' for key 'PRIMARY'
Database: resourcesdb

Step 3: MySQL error reported: [INSERT INTO pp_settings VALUES (5,'URL to PhotoPost data directory','datadir','This is the web / virtual path to the data directory.','http://www.domain.com/photopost/data',5,1)]
Result: Duplicate entry '5' for key 'PRIMARY'
Database: resourcesdb

Step 3: MySQL error reported: [INSERT INTO pp_settings VALUES (6,'Full SERVER PATH to PhotoPost data directory','datafull','Full path to the image files directory.','/path/to/your/photopost/data',6,1)]
Result: Duplicate entry '6' for key 'PRIMARY'
Database: resourcesdb

Step 3: MySQL error reported: [INSERT INTO pp_settings VALUES (7,'URL to your forums main directory','vbulletin','This is the URL path to your forum installation.','http://www.domain.com/forum',1,13)]
Result: Duplicate entry '7' for key 'PRIMARY'
Database: resourcesdb

Step 3: MySQL error reported: [INSERT INTO pp_settings VALUES (8,'Full path to Header Include file','header','To include an HTML file as the header, enter the full path.','/path/to/php/header.htm',8,1)]
Result: Duplicate entry '8' for key 'PRIMARY'
Database: resourcesdb

Step 3: MySQL error reported: [INSERT INTO pp_settings VALUES (9,'Full path to the Footer include file','footer','To include an HTML file as the footer, enter the full path.','/path/to/php/footer.htm',9,1)]
Result: Duplicate entry '9' for key 'PRIMARY'
Database: resourcesdb

[Chuck S]

Those errors are fine you will see those it means your not overwriting certain things because quite simply they exist already.

[WayneH]

Cool.

OK, one more thing to fix (and hopefully that will be it). I can select the existing galleries OK, but whenever I click on a thumbnail to see the enlarged image I am getting this warning:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /Gallery/forums/vb3.php on line 175

Sometimes once, sometimes three times, depending on the photos I have looked at so far.

Any ideas how to fix this?

[Chuck S]

MYSQL Prob...?

Yes that should help you

[WayneH]

Thanks Chuck. As we are still running vBulletin v3.5.3, I had to run the mySQL ALTER TABLE query and use your modified profiledata function in the vb3.php file. Now that I have done those two things, the warning messages have gone away.

Thanks for your help.

[Chuck S]

Your last issue has nothing to do with any version of vbulletin. The issue is you got rid of a profile field in vbulletin thats the one that holds user location and by default we query that one.