Error near: 'AND n.product=c.id AND n.type=1) WHERE c.id=1'

criscokid · November 7th, 2007, 12:02 PM

I'm not sure what page / actions is generating this error message... I've received three of them today:

An error was encountered during execution of the query:

SELECT c.id,c.catname,c.template,n.userid
FROM view_categories c
LEFT JOIN view_notify n ON (n.userid= AND n.product=c.id AND n.type=1)
WHERE c.id=1

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 n.product=c.id AND n.type=1)
WHERE c.id=1'

Chuck S · November 7th, 2007, 01:15 PM

What integration is this? Your userid is null which is weird it should always be 0 for a guest.

Line 263 of showcat.php you can encapsulte the userid variable like so to not get an error.

Code:

Content visible to verified customers only.