PhotoPost Community - View Single Post

ozidoggy · June 1st, 2009, 06:22 AM

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

June 1st, 2009, 06:22 AM	#1 (permalink)
ozidoggy Member Verified Customer Join Date: Mar 2008 Location: Australia Posts: 75	Database error 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