PhotoPost Community - View Single Post - 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'

November 7th, 2007, 12:02 PM	#1 (permalink)
criscokid Senior Member Verified Customer Join Date: Jun 2003 Location: London, UK Posts: 562	Error near: 'AND n.product=c.id AND n.type=1) WHERE c.id=1' 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'