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.canyongold.com/large_sextants_8-10in?filter=%26fd2%3D5
Referrer URL:
Database error: Invalid SQL: SELECT COUNT(DISTINCT i.item_id) AS total 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 = 64 AND AND (i.price>=201 and i.price<=300) AND (i.price<10)
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>=201 and i.price<=300) AND (i.price<10)' at line 1
|