i have one site neokas.com
when click the fliter in product page. http://www.neokas.com/products.php
click, price, type,Rating i will meet the erro
DB ERROR 1064
We are very sorry, but an error has occurred while processing your request. Please try the operation again by either pressing the Refresh button on your browser, or by going back one page using the Back button. If the error persists, please contact our web development team.
The details of the error are shown below. Please quote this in any correspondance regarding this problem.
Page URL: http://www.neokas.com/products.php?filter=%26fl3%3D1
Referrer URL: http://www.neokas.com/products.php
Database error: Invalid SQL: SELECT COUNT(DISTINCT i.item_id) AS total , i.manufacturer_id FROM ((va_items i INNER JOIN va_items_categories ic ON i.item_id=ic.item_id) ) WHERE i.is_showing=1 AND i.is_approved=1 AND ((i.hide_out_of_stock=1 AND i.stock_level > 0) OR i.hide_out_of_stock=0 OR i.hide_out_of_stock IS NULL) AND (i.language_code IS NULL OR i.language_code=” OR i.language_code=’en’) AND i.sites_all=1 AND i.guest_access_level&2 AND ic.category_id = 0 AND AND ( i.item_type_id=1 ) GROUP BY i.manufacturer_id
MySQL Error: 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 ‘AND ( i.item_type_id=1 ) GROUP BY i.manufacturer_id’ at line 1
Please help to fix this.
thanks
