SQL Error: Error writing file '/tmp/MYTVCEoD' (Errcode: 28 - No space left on device)
Called From: products->set_category_structure() in [edit/modules/products/products.class.php:5234]
SQL: ( SELECT `RECORDID`, `TITLE`, `REFTITLE`, COALESCE( NULLIF(`TABLE_PRODUCT_CATEGORIES`.`IMAGE`, ''), NULLIF(`TABLE_PRODUCTS`.`IMAGE`, '') ) AS `IMAGE`, `PARENTID`, `SORTNUM`, '' AS `GROUPSQL`, `TABLE_PRODUCTS`.`HITCOUNT` AS `HITCOUNT`, `TABLE_PRODUCTS`.`SORT` AS `SORT`, 'category' AS `TYPE` FROM `TABLE_PRODUCT_CATEGORIES` LEFT JOIN ( SELECT `IMAGES` AS `IMAGE`, `CATEGORIES`, `HITCOUNT`, CONCAT(IF(`SORTNUM` <> '',LPAD(`SORTNUM`, 6, '0'),999999),'_',`TITLE`) AS `SORT` FROM `TABLE_PRODUCTS` WHERE `IMAGES` <> '' ) AS `TABLE_PRODUCTS` ON `TABLE_PRODUCTS`.`CATEGORIES` LIKE CONCAT('%',`TABLE_PRODUCT_CATEGORIES`.`RECORDID`,'%') WHERE `SECTION` = 'edit64a3800caf85c' AND `ALLYEAR` <> 0 ) UNION ALL ( SELECT `RECORDID`, `TITLE`, `REFTITLE`, `IMAGE`, `PARENTID`, `SORTNUM`, `GROUPSQL`, 0 AS `HITCOUNT`, 0 AS `SORT`, 'group' AS `TYPE` FROM `TABLE_PRODUCT_GROUPS` WHERE `SECTION` = 'edit64a3800caf85c' AND `ALLYEAR` <> 0 ) ORDER BY IF(`SORTNUM` <> '',`SORTNUM`,99999) ASC, `TITLE` ASC, `HITCOUNT` ASC, `SORT` DESC