Glenn101 Posted January 31, 2010 Share Posted January 31, 2010 Hi, I can create an account but when i go back into "My Account" page on the site , it has this syntax error: 1064 - 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 ''1' at line 1 select count(*) as total from orders o, orders_status s where o.customers_id = '16' and o.orders_status = s.orders_status_id and s.language_id = '1 [TEP STOP] Can anyone please help - VERY urgent - Thankyou Link to comment Share on other sites More sharing options...
satish Posted January 31, 2010 Share Posted January 31, 2010 select count(*) as total from orders o, orders_status s where o.customers_id = '16' and o.orders_status = s.orders_status_id and s.language_id = '1 to select count(*) from orders o, orders_status s where o.customers_id = '16' and o.orders_status = s.orders_status_id and s.language_id = '1 Satish Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
Glenn101 Posted January 31, 2010 Author Share Posted January 31, 2010 select count(*) as total from orders o, orders_status s where o.customers_id = '16' and o.orders_status = s.orders_status_id and s.language_id = '1 to select count(*) from orders o, orders_status s where o.customers_id = '16' and o.orders_status = s.orders_status_id and s.language_id = '1 Satish Thanks, not sure what that code is, but i reloaded the database from scratch, and seems to be working now, copying tables from a back database worked, editing the database itself in php my admin seems to be faster Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.