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 ('4') 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 ASC, xcart_products.product ASC, xcart_products.productcode ASC, xcart_products.productid ASC LIMIT 240, 15
Berenson cabinet hardware knobs and pulls available on USKnobs.com
USKnobs :: Browse by Manufacturer :: Berenson Corporation

Berenson Corporation

Berenson Corporation

Products

Sort by: Item# Product Price Default
There are no available products under this manufacturer.

Your Cart

Cart is empty

Your Account

Forgot password?

News

02-13-2015
We've just expanded the Made In The USA section of the website with more US manufacturers and more products. Check it out!

All news   

Do you like our store?
If so, please let others know.
 
Follow USKnobs on Pinterest
 
Follow USKnobs on Twitter
 
 


 
SSL Certificate