New Install Error Msg

[bucks]

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.

[Chuck S]

thats not a core file thats a custom box

try this

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

[bucks]

That sorted it, thanks Chuck !

[Chuck S]

Have a good evening.