Error: Error: Error writing file '/tmp/MYfd=1731' (OS errno 28 - No space left on device)
Error No: 3
SELECT DISTINCT *, `pd`.`name`, `p`.`image`, `ss`.`name` as stock_status, (SELECT (CASE WHEN `pd2`.`type` = 'P' THEN (`p`.`price` - (`p`.`price` * (`pd2`.`price` / 100))) WHEN `pd2`.`type` = 'S' THEN (`p`.`price` - `pd2`.`price`) ELSE `pd2`.`price` END) FROM `ign_product_discount` `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '1' AND `pd2`.`quantity` = '1' AND `pd2`.`special` = '0' AND ((`pd2`.`date_start` = '0000-00-00' OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` = '0000-00-00' OR `pd2`.`date_end` > NOW())) ORDER BY `pd2`.`priority` ASC, `pd2`.`price` ASC LIMIT 1) AS `discount`, (SELECT (CASE WHEN `ps`.`type` = 'P' THEN (`p`.`price` - (`p`.`price` * (`ps`.`price` / 100))) WHEN `ps`.`type` = 'S' THEN (`p`.`price` - `ps`.`price`) ELSE `ps`.`price` END) FROM `ign_product_discount` `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND `ps`.`quantity` = '1' AND `ps`.`special` = '1' AND ((`ps`.`date_start` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW())) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1) AS `special`, (SELECT `pr`.`points` FROM `ign_product_reward` `pr` WHERE `pr`.`product_id` = `p`.`product_id` AND `pr`.`customer_group_id` = '1') AS `reward`, (SELECT COUNT(*) FROM `ign_review` `r` WHERE `r`.`product_id` = `p`.`product_id` AND `r`.`status` = '1' GROUP BY `r`.`product_id`) AS `reviews` FROM `ign_product_to_store` `p2s` LEFT JOIN `ign_product` `p` ON (`p`.`product_id` = `p2s`.`product_id` AND `p`.`status` = '1' AND `p2s`.`store_id` = '0' AND `p`.`date_available` <= NOW()) LEFT JOIN `ign_stock_status` `ss` ON (`ss`.`stock_status_id` = `p`.`stock_status_id` and `ss`.`language_id` = '1') LEFT JOIN `ign_product_description` `pd` ON (`p`.`product_id` = `pd`.`product_id`) WHERE `pd`.`language_id` = '1' AND ( (`pd`.`tag` LIKE '%Kingston%' OR `pd`.`tag` LIKE '%SDG3/64GB%' OR `pd`.`tag` LIKE '%in%' OR `pd`.`tag` LIKE '%Abu-Dhabi%')) GROUP BY `p`.`product_id` ORDER BY p.sort_order ASC, LCASE(`pd`.`name`) ASC LIMIT 0,60 File: /home/kabir4bv/public_html/uat.terrabyt.com/system/library/db/mysqli.php Line: 122 Backtrace: 0 File: /home/kabir4bv/public_html/uat.terrabyt.com/system/library/db.php Line: 54 Class: Opencart\System\Library\DB\MySQLi Function: query Backtrace: 1 File: /home/kabir4bv/public_html/uat.terrabyt.com/catalog/model/catalog/product.php Line: 256 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /home/kabir4bv/public_html/uat.terrabyt.com/vqmod/vqcache/vq2-system_engine_loader.php Line: 343 Class: Opencart\Catalog\Model\Catalog\Product Function: getProducts Backtrace: 3 File: /home/kabir4bv/public_html/uat.terrabyt.com/system/engine/proxy.php Line: 87 Class: Opencart\System\Engine\Loader Function: Opencart\System\Engine\{closure} Backtrace: 4 File: /home/kabir4bv/public_html/uat.terrabyt.com/vqmod/vqcache/vq2-catalog_controller_product_search.php Line: 185 Class: Opencart\System\Engine\Proxy Function: __call Backtrace: 5 File: /home/kabir4bv/public_html/uat.terrabyt.com/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Product\Search Function: index Backtrace: 6 File: /home/kabir4bv/public_html/uat.terrabyt.com/system/framework.php Line: 259 Class: Opencart\System\Engine\Action Function: execute Backtrace: 7 File: /home/kabir4bv/public_html/uat.terrabyt.com/index.php Line: 24 Function: require_once