Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Urgent - My Account page has syntax error


Glenn101

Recommended Posts

Posted

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

Posted

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.

Posted

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

Archived

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

×
×
  • Create New...