Glenn101 Posted January 31, 2010 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
satish Posted January 31, 2010 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.
Glenn101 Posted January 31, 2010 Author 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.