hi getting this error message how to rectify?

[gregk]

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

[Chuck S]

http://www.photopost.com/forum/1244170-post11.html

try this

[gregk]

thanks....seems to have solved the problem

[Chuck S]

Have a good day let us know if there is anything else we can assist with