PhotoPost Community - View Single Post

bucks · March 24th, 2009, 10:31 PM

Just installed a copy of classifieds 3.1 and the following message appears on my site;

"We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: index

Query: SELECT p.id,p.cat,p.title,p.enddate,p.price,c.symbol,c.type FROM cp_products p LEFT JOIN cp_currency c ON (p.currency = c.code) WHERE enddate > AND isauction=1 ORDER BY enddate LIMIT 10

Result: 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 isauction=1 ORDER BY enddate LIMIT 10' at line 3

Database handle: Resource id #5"

Any ideas what the cause may be and how to fix ?

Cheers.

March 24th, 2009, 10:31 PM	#1 (permalink)
bucks Junior Member Verified Customer Join Date: Mar 2009 Posts: 15	New Install Error Msg Just installed a copy of classifieds 3.1 and the following message appears on my site; "We're sorry, but the system experienced an unrecoverable error. Please try again later. Script: index Query: SELECT p.id,p.cat,p.title,p.enddate,p.price,c.symbol,c.type FROM cp_products p LEFT JOIN cp_currency c ON (p.currency = c.code) WHERE enddate > AND isauction=1 ORDER BY enddate LIMIT 10 Result: 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 isauction=1 ORDER BY enddate LIMIT 10' at line 3 Database handle: Resource id #5" Any ideas what the cause may be and how to fix ? Cheers.