Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Urgent - My Account page has syntax error


Glenn101

Recommended Posts

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

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...