Notice: file_put_contents(): Write of 942 bytes failed with errno=28 No space left on device in /home/jcnxat/public_html/system/library/log.php on line 36Warning: file_put_contents(): Only 1429 of 2371 bytes written, possibly out of free disk space in /home/jcnxat/public_html/system/library/log.php on line 36Error: Can't create/write to file '/var/eachtmp/#sql-temptable-18404b-24a7c1-69109.MAI' (Errcode: 28 "No space left on device")
Error No: 1
SELECT DISTINCT *, pd.`name`, `pe`.`product_type`,`pe`.`price_prp`, `pe`.`is_promo`, `pe`.`is_preorder`,`pe`.`preorder_date`,`pe`.`delivery_time_days`,`pe`.`youtube_video`, pa.`text` AS metascore, m.`name` AS manufacturer, cp.`category_id` as level_2_category_id, `p`.`image`, (SELECT `pd2`.`price` FROM `oc_product_discount` `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '3'AND `pd2`.`quantity` = '1' 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 `ps`.`price` FROM `oc_product_special` `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '3' 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 `oc_product_reward` `pr` WHERE `pr`.`product_id` = `p`.`product_id` AND `pr`.`customer_group_id` = '3') AS `reward`, (SELECT COUNT(*) FROM `oc_review` `r` WHERE `r`.`product_id` = `p`.`product_id` AND `r`.`status` = '1' GROUP BY `r`.`product_id`) AS `reviews` FROM `oc_product_to_store` `p2s` LEFT JOIN `oc_product` `p` ON (`p`.`product_id` = `p2s`.`product_id` AND `p`.`status` = '1' AND `p`.`date_available` <= NOW()) LEFT JOIN `oc_product_to_category` `p2c` ON (`p`.`product_id` = `p2c`.`product_id`) LEFT JOIN `oc_category_path` `cp` ON (`p2c`.`category_id` = `cp`.`category_id` AND LEVEL = 2) LEFT JOIN `oc_product_extra` `pe` ON (`p`.`sku` = `pe`.`nexus`) LEFT JOIN `oc_product_attribute` `pa` ON (`p`.`product_id` = `pa`.`product_id` and pa.attribute_id = 7) LEFT JOIN `oc_product_description` `pd` ON (`p`.`product_id` = `pd`.`product_id`) LEFT JOIN `oc_manufacturer` `m` ON `p`.`manufacturer_id` = `m`.`manufacturer_id` WHERE `p2s`.`store_id` = '0' AND `p2s`.`product_id` = '53155' AND `pd`.`language_id` = '3': in /home/jcnxat/public_html/system/library/db/mysqli.php on line 76