Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error 1064 on MySQL in catalog


Guest

Recommended Posts

Hi there,

 

I got this error in the products page, when i try to enter the details section. The error appeared from nowhere, from one day to another without me entering to change something in the site. Please help me .. i don't understand mysql and people who i've talked about said they don't know anything about it. Please help!

 

The error is:

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 'p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id =' at line 1

 

select count(p.products_id) as total from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '132'

 

and it's located here: http://www.buyiq.com/index.php?cPath=128_132

 

 

Thank you!

Link to comment
Share on other sites

Has you server just been upgraded to use mysql5?

 

If so the patches required can be found below in the link to the solution to loads of problems below.

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...