PP 6.1 upgrade query errors

[ncangler]

I've gotten a half dozen errors like the one below since upgrading to Photopost 6.1. Any suggestions on how to resolve?

An error was encountered during execution of the query:

SELECT id,bigimage,cat,userid,approved FROM class_products WHERE cat= AND approved=1 ORDER BY disporder,date DESC

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 'AND approved=1 ORDER BY disporder,date DESC' at line 1

[Chuck S]

You sure we are talking Photopost 6.1 here as that looks like Classifieds not Photopost Pro.

Do you have classifieds?

Line 173 of showframe.php

Content visible to verified customers only.

Replace $cat with $dbcat

[ncangler]

My fault Chuck. yes I upgraded Classifieds in addition to Photopost. Thanks for the code fix.

[Chuck S]

glad to assist have a good night