Database error

[ozidoggy]

Hi Chuck

I migrated my site to a new server, and after restoring the backup to the new sever I get this error message.. Any idea what is causing it?

Thanks

Mark


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

Script:

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 #53

[ozidoggy]

OK did an upgrade of classifieds..that fixed the problem. But for some reason as admin I have no icons/buttons to edit, delete, etc, any ads

[Chuck S]

I would need more information here to respond. Upgrading alone is not going to reset some groups permissions.