Repairing table /tmp/#sql_40e_0...126 : Incorrect key file for table '/tmp/#sql_40e_0.MYI'; try to repair it
INVALID SQL: 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 '/tmp/#sql_40e_0 EXTENDED' at line 1
SQL QUERY FAILURE:SELECT xcart_manufacturers.*, IFNULL(xcart_manufacturers_lng.manufacturer, xcart_manufacturers.manufacturer) as manufacturer, IFNULL(xcart_manufacturers_lng.descr, xcart_manufacturers.descr) as descr FROM xcart_manufacturers USE INDEX (avail) LEFT JOIN xcart_manufacturers_lng ON xcart_manufacturers.manufacturerid = xcart_manufacturers_lng.manufacturerid AND xcart_manufacturers_lng.code = 'en' WHERE avail = 'Y' ORDER BY orderby, manufacturer LIMIT 10
Repairing table /tmp/#sql_40e_0...126 : Incorrect key file for table '/tmp/#sql_40e_0.MYI'; try to repair it
INVALID SQL: 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 '/tmp/#sql_40e_0 EXTENDED' at line 1
SQL QUERY FAILURE:SELECT xcart_products.*, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_pricing.price, xcart_product_features.fclassid, IF(xcart_product_features.fclassid IS NULL || xcart_product_features.productid IN ('0'),'','Y') as is_clist, IF(xcart_products_lng.productid != '', xcart_products_lng.product, xcart_products.product) as product, IF(xcart_products_lng.productid != '', xcart_products_lng.descr, xcart_products.descr) as descr, IF(xcart_products_lng.productid != '', xcart_products_lng.fulldescr, xcart_products.fulldescr) as fulldescr FROM xcart_pricing, xcart_products LEFT JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid LEFT JOIN xcart_product_features ON xcart_product_features.productid = xcart_products.productid LEFT JOIN xcart_feature_classes ON xcart_feature_classes.fclassid = xcart_product_features.fclassid AND xcart_feature_classes.avail = 'Y' LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'en' LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_products_categories.categoryid = xcart_categories.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid WHERE xcart_quick_prices.priceid = xcart_pricing.priceid AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_products.manufacturerid IN ('45') AND xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND xcart_categories.avail = 'Y' AND (xcart_products.forsale = 'Y' OR xcart_products.forsale = '') AND (xcart_products.avail > 0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid ORDER BY xcart_products.productcode DESC, xcart_products.product ASC, xcart_products.productcode ASC, xcart_products.productid ASC LIMIT 660, 15
Notting Hill Cabinet and Furniture Hardware knobs and pulls at USKnobs
USKnobs :: Browse by Manufacturer :: Notting Hill

Notting Hill

Products

There are no available products under this manufacturer.

Do you like our store?
If so, please let others know.

 
Follow USKnobs on Pinterest
 
Follow USKnobs on Twitter
 
 


 
SSL Certificate