I get this when selecting a filter for Price or Manf, etc. I only have 7 items and using all default installed features/templates. I see the problem is somehow there are two AND AND in the query near the end.
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://MYWEBSITEHERE.com/products.php?filter=%26fd2%3D3
Referrer URL:
Database error: Invalid SQL: SELECT COUNT(DISTINCT ic.category_id, i.item_id) FROM ((( va_items i LEFT JOIN va_items_user_types AS ut ON ut.item_id=i.item_id) 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.access_level&2 OR (ut.access_level&2 AND ut.user_type_id=1) ) AND ic.category_id = 0 AND AND (i.price>=51 and i.price<=100)
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.price>=51 and i.price<=100)' at line 1
