Urgent - My Account page has syntax error

[Glenn101]

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]

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

[Glenn101]

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