database query error in 6.1

[ncangler]

I have upgraded Photopost, Classifieds and Reviewpost so I'm not sure which one is causing this error, but any help is most appreciated.

An error was encountered during execution of the query:

SELECT catname,extra1,extra2,extra3,extra4,extra5,extra6,numextra 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: Photopost Pro Bug Reports - PhotoPost Community

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

[Chuck S]

I suggest you look at which product has a prefix of pp_

I would think Photopost your bulkupload.php file and my main question would be why is your defcat variable empty as that should never happen but you can encapsulate the variable in that query to stop that error

Content visible to verified customers only.

[ncangler]

The "pp_" prefix would be a giveaway wouldn't it. Looks like the ' before $ was missing for some reason. id='$defcat'",

Thanks Chuck!

[Chuck S]

No it was not missing the single quotes around that variable is something I added just for you. Really what I was saying outloud here is I would have no idea why your defcat variable would be empty since thats passed on the natural progression from the upload script.

[aberg]

Originally Posted by ncangler

The "pp_" prefix would be a giveaway wouldn't it. Looks like the ' before $ was missing for some reason. id='$defcat'",

Thanks Chuck!

Again thanks Chuck!
Same error here and same solution don't know why I also missing the ' before and after $defcat