pp 5.1 sql error (not a bug)

[filipv]

I keep gettting these errors in my email, what is going on with them ?

An error was encountered during execution of the query:

SELECT id,catname,thumbs,cattype,parent,password,theme,ratingtype FROM pp_categories WHERE id=

The query returned with an errorcode of:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

[Fenriz]

I'm also keep geting these errors and receive about 50 emails every day:

----------------------
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.

[Fenriz]

Thank you, I've run the upgrade.php for 5.0 and ignored the duplicate errors

[Fenriz]

My error disappeared, but appeared the error like Filipv described in the first message:

-----------------
An error was encountered during execution of the query:

SELECT id,catname,thumbs,cattype,parent,password,theme,ratingtype FROM pp_categories WHERE id=

The query returned with an errorcode of:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server
version for the right syntax to use near '' at line 1
---------------

Please, help to correct it.

[filipv]

I still have the same errors now an then

[Chuck S]

You mean your still missing the album field?

[filipv]

I mean I still get those emails

An error was encountered during execution of the query:

SELECT id,catname,thumbs,cattype,parent,password,theme,ratingtype FROM pp_categories WHERE id=

The query returned with an errorcode of:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

[Fenriz]

omegatron, the problem with missing the album field has been fixed, but now we have next mysql error:

--------------
An error was encountered during execution of the query:

SELECT id,catname,thumbs,cattype,parent,password,theme,ratingtype FROM pp_categories WHERE id=

The query returned with an errorcode of:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server
version for the right syntax to use near '' at line 1
--------------

[filipv]

Anyone yet, the error still occurs sometimes when a user places a comment, the comment doe snot show on the recent comments section also

[Fenriz]

I've discovered that the final version of the 5.1 has been renewed and now we have 5/31/05 8:48 AM Build (before it was 5/25/05). It seems in this build problem has been fixed. I don't receive errors anymore.

[Michael P]

The error is probably the result of a spider calling a script with a blanbk variable and not indictive of an actual bug, just the lack of a parameter being passed. For example, calling showgallery.php with no cat variable. We can add more checks in to pop up an error message (not that it would matter to a spider) until then you can just ignore the message.