Error 1064 (in catalog)

[stephanon]

Hi, My shops works well (search-function, etc..)

 

But I get an error when selecting a category : (I want to see all the products from one category)

 

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 ') as final_price from products_description pd, products p left j

 

select p.products_image, m.manufacturers_name, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, p.products_price) as final_price 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.products_id 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 = '23' order by pd.products_name limit 20, 20

 

I searched this forum, but most of people get this error only in the admin.

Is there something wrong in my configure.php ?

[Kiwiody]

Hi Stephanon

I've got the SAME problem...

 

I have had some problems installing an add-on so I could use the 'call for price' piece. I have products I can't list prices for (I know... I've read all the comments about that issue - anyway) after that add-on crashed me incredibly I restored with my backup and now...

 

1064 is my friend...

 

It's odd tho - I have traced the problem to something from the index.php page. If I choose a category that has subcategories - I get the sub list just fine. And if I have a "added this month" box on the page - I can choose product from there fine (it calls the product_info.php page) but if I try to choose something that doesn't have a subcatgory - shabang!!

 

any help here would be FANTASTIC!

 

cheers

Melody