INVALID SQL: 1021 : Disk full (/var/tmp/#sql_2b21_2); waiting for someone to free some space... SQL QUERY FAILURE:
SELECT
xcart_newsletter.*
FROM
xcart_newslists, xcart_newsletter
WHERE
xcart_newslists.avail='Y' AND
xcart_newslists.show_as_news='Y' AND
xcart_newslists.lngcode='US' AND
xcart_newslists.listid=xcart_newsletter.listid AND
xcart_newsletter.show_as_news='Y'
ORDER BY xcart_newsletter.send_date DESC LIMIT 1 INVALID SQL: 1021 : Disk full (/var/tmp/#sql_2b21_4); waiting for someone to free some space... 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 = 'US' WHERE avail = 'Y' ORDER BY orderby, manufacturer LIMIT 10 INVALID SQL: 1021 : Disk full (/var/tmp/#sql_2b21_2); waiting for someone to free some space... SQL QUERY FAILURE:SELECT xcart_products.*, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_pricing.price, 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, IFNULL(xcart_variants.avail, xcart_products.avail) as avail, IFNULL(xcart_variants.weight, xcart_products.weight) as weight, IFNULL(xcart_variants.productcode, xcart_products.productcode) as productcode FROM xcart_pricing, xcart_products LEFT JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' 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 LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid 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_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND xcart_categories.avail = 'Y' AND xcart_products_categories.categoryid='664' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale = 'Y' GROUP BY xcart_products.productid ORDER BY price ASC, xcart_products.product ASC LIMIT 0, 10 INVALID SQL: 1021 : Disk full (/var/tmp/#sql_2b21_6); waiting for someone to free some space... 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 = 'US' WHERE avail = 'Y' ORDER BY orderby, manufacturer INVALID SQL: 1021 : Disk full (/var/tmp/#sql_2b21_6); waiting for someone to free some space... 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 = 'US' WHERE avail = 'Y' ORDER BY orderby, manufacturer Rust Kill Barbeque Black Spray Enamel|Majic Paints|Shop by Brand|Paint Store