SQL errors

[rogerl]

We're running Photopost 5.14 with Vbulletin 4.5 RC2, not fully integrated, but using the VB logon and styles.

2 SQL errors are being reported on a fairly frequent basis :

An error was encountered during execution of the query:

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

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 'all' at line 1

and

An error was encountered during execution of the query:

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

The query returned with an errorcode of:

Unknown column 'recent' in 'where clause'

The implementation may be a little unusual in that we only have the members galleries and no additional categories.

I've not managed to reproduce any errors myself, so not sure what is causing them.

Site is at http://www.readytogo.net/userphotos/

PHP Version 4.3.11
SQL 4.0.25

[Chuck S]

Yeah dont know how I would it could get that error since cat is typecast as an INTEGER in uploadphoto. If it is not an integer it should be empty which means this query does not run

if ( isset($cat) && !empty($cat) ) {
$query = "SELECT id,catname,thumbs,cattype,parent,password,theme FROM {$Globals['pp_db_prefix']}categories WHERE id=$cat";
$ctitleq = ppmysql_query($query, $link);

I take it these are email errors?

[rogerl]

Originally Posted by omegatron

I take it these are email errors?

Yes, both errors reported via email on a regular basis

[Chuck S]

Well it is interesting indeed. Yes I can not reproduct either and the upload file is the only file that exact query is in. It is surrounded by the if statement meaning to only run it if the cat variable is not empty so I can't see how this is happening.