Error:
The mysql database returned an error while processing your request.
The SQL statement was: SELECT product.product_id, sistersites.site, sistersites.sitecode, product.product_id, product.picture1, product.brand, product.model, product.modelnumber, product.brand, product.model, product.modelnumber, product.cat0, product.price, product.picture1 FROM product LEFT OUTER JOIN sistersites ON product.mainsite = sistersites.site WHERE product.mainsite = ' AND ((product.cat1=' ')) AND ((product.product_id IS NULL OR product.product_id="") OR ((UPPER(product.product_id) LIKE UPPER('%!%')))) ORDER BY product.ranking DESC;
The database returned this: 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 ((product.product_id IS NULL OR product.product_id="")
Other info:
$user_data{_cgifunction}=search
$user_data{product.cat1}=
$user_data{perpage}=5
$user_data{nbsp}= or
$user_data{product.mainsite}='
$user_data{product.product_id}=!
$user_data{'}=
$user_data{_layout}=ZZ-TOPTEN
|
|
|
|
In an effort to better serve you, we are always adding new products to our website. If the product you are currently looking at has not been updated with a picture or description, please give us a call or use the live help link above so we can tell you about this product. Picture and description will be updated soon.
|
|
OTHER PRODUCTS YOU MAY BE INTERESTED IN:
|
|
Error:
The mysql database returned an error while processing your request.
The SQL statement was: SELECT count(product.product_id) FROM product LEFT OUTER JOIN sistersites ON product.mainsite = sistersites.site WHERE ((product.cat1=' ')) AND (LENGTH(product.picture1)>0) AND ((product.dontdisplay IS NULL OR product.dontdisplay="") OR ((UPPER(product.dontdisplay) LIKE UPPER('%!%')))) AND product.mainsite = ' ORDER BY RAND(3474);
The database returned this: 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 '' ORDER BY RAND(3474)' at line 1
Other info:
$user_data{product.dontdisplay}=!
$user_data{nbsp}=
$user_data{product.mainsite}='
$user_data{_cgifunction}=search
$user_data{product.cat1}=
$user_data{faketable.cat0}=
$user_data{'}=
$user_data{product.picture1}=!!
$user_data{_layout}=ZZ-FIVEPROMOSRANDOM
|