mySQL errors

[robinsf]

While uploading photos or moving photos from one album to another, I get this error:


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/scrapoft/public_html/photopost/pp-inc.php on line 1857

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/scrapoft/public_html/photopost/pp-inc.php on line 1857

This is a fresh install of PhotoPost 5.1 (i.e. NOT an upgrade -- new DB, fresh install).

Running on Unix, shared server

vB 3.0.7

vBulletin and Photopost are in two seperate mySQL databases.

[robinsf]

MySQL error report email says this:

An error was encountered during execution of the query:

SELECT id,catname,description,catorder,parent,thumbs,children,cattype,albums FROM pp_categories WHERE id IN (500) ORDER BY id DESC

The query returned with an errorcode of:

Unknown column 'albums' in 'field list'

[Michael P]

albums was a field missing in the early install.php script; you can either run the upgrade.php for 5.0 and ignore the duplicate errors or you can add it manually:

ALTER TABLE categories ADD albums TEXT AFTER children;

Be sure to add any table prefix onto categories if you have them.

[robinsf]

That seemed to kill the errors -- thanks!

Can you guys fix the install files to include that table insertion? I dl'd Photopost right from the Members section yesterday.

Also, do I need to install the inc_photopost.php for full VB3 integration? In prior versions, in a member's posts next to PM, Online Status, etc. a link was automatically generated to that member's Photopost gallery. Is that still possible?

[Michael P]

We already updated the build with the missing field.

If I understand what you want (a link by a members name to their gallery), thats a vBulletin modification. I've seen them on photopostdev.com, so you might try looking there.