PhotoPost Community - View Single Post - hi getting this error message how to rectify?

gregk · March 31st, 2009, 10:00 AM

hi i'm getting this error message on the index page, any way to fix this ...thanks

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

March 31st, 2009, 10:00 AM	#1 (permalink)
gregk Junior Member Verified Customer Join Date: Feb 2009 Posts: 16	hi getting this error message how to rectify? hi i'm getting this error message on the index page, any way to fix this ...thanks 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