Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-827616-e8bb.MAI' (Errcode: 28 "No space left on device")<br />Error No: 1<br />SELECT p.product_id, p.price, p.tax_class_id, p.image, p.minimum, p.bestseller, p.sales, p.view_ratio, p.generated_rating, p.status, p.date_available, p.date_added, p.date_modified, p.viewed, p.sort_order, p.quantity, p.model, p.sku, pd.name, pd.description, pd.meta_title, pd.meta_description, pd.meta_keyword, pd.tag, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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 price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '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 FROM oc_product p JOIN oc_product_description pd ON (p.product_id = pd.product_id AND pd.language_id = '1') WHERE p.product_id in (1658425,1476277,1208923,1476284,1430082,1658441,1255202,1190241,1437654,1209002,1208897,1658220,1190300,1696179,1208922,1501471,1658238,1658426,1476282,1809241,1476280,1209037,1209036,1658443,1208961,1190296,1658442,1657821,1546494,1506965,1437653,1658448,1658406,1694030,1658444,1658424,1657836,1658447,1658428,1658439,1680040,1658147,1658451,1190289,1658437,1658435,1658438,1657734,1657758,1208851,1437672,1657705,1657907,1208936,1658429,1208850,1208865,1208977,1658214,1657785,1657898,1476283,1190248,1657919,1658450,1693990,1658449,1208836,1657654,1657770,1658244,1190277,1657693,1658433,1658446,1190266,1501482,1501480,1657660,1657725,1208834,1208890,1208892,1208909,1208913,1657752,1546497,1190309,1658322,1658430,1190290,1209005,1208838,1208879,1680042,1657827,1680046,1774031,1430068,1209053,1658453,1472566,1208839,1658431,1658434,1657910,1208870,1569246,1657657,1657722,1657737,1657913,1190258,1657708,1658223,1546504,1190310,1453780,1453784,1453797,1453798,1453804,1453806,1255214,1208944,1658241,1694279,1190288,1498071,1255287,1208849,1774023,1774024,1735174,1546495,1572904,1190218,1898225,1255268,1255209,1657773,1658440,1546509,1208918,1437675,1694145,1190276,1658445,1658454,1255275,1546513,1572906,1694349,1658452,1546480,1658427,1255302,1255249,1190204,1430088,1430091,1546488,1546489,1546506,1546511,1572891,1658432,1693943,1694027,1735195,1735196,1774022,1871652,1871920) ORDER BY FIELD(p.product_id, 1658425,1476277,1208923,1476284,1430082,1658441,1255202,1190241,1437654,1209002,1208897,1658220,1190300,1696179,1208922,1501471,1658238,1658426,1476282,1809241,1476280,1209037,1209036,1658443,1208961,1190296,1658442,1657821,1546494,1506965,1437653,1658448,1658406,1694030,1658444,1658424,1657836,1658447,1658428,1658439,1680040,1658147,1658451,1190289,1658437,1658435,1658438,1657734,1657758,1208851,1437672,1657705,1657907,1208936,1658429,1208850,1208865,1208977,1658214,1657785,1657898,1476283,1190248,1657919,1658450,1693990,1658449,1208836,1657654,1657770,1658244,1190277,1657693,1658433,1658446,1190266,1501482,1501480,1657660,1657725,1208834,1208890,1208892,1208909,1208913,1657752,1546497,1190309,1658322,1658430,1190290,1209005,1208838,1208879,1680042,1657827,1680046,1774031,1430068,1209053,1658453,1472566,1208839,1658431,1658434,1657910,1208870,1569246,1657657,1657722,1657737,1657913,1190258,1657708,1658223,1546504,1190310,1453780,1453784,1453797,1453798,1453804,1453806,1255214,1208944,1658241,1694279,1190288,1498071,1255287,1208849,1774023,1774024,1735174,1546495,1572904,1190218,1898225,1255268,1255209,1657773,1658440,1546509,1208918,1437675,1694145,1190276,1658445,1658454,1255275,1546513,1572906,1694349,1658452,1546480,1658427,1255302,1255249,1190204,1430088,1430091,1546488,1546489,1546506,1546511,1572891,1658432,1693943,1694027,1735195,1735196,1774022,1871652,1871920) ASC, LCASE(pd.name) ASC, p.product_id ASC LIMIT 0,20 in /home/sendflowersandmore.com/public_html/system/library/db/mysqli.php:67
Stack trace:
#0 /home/sendflowersandmore.com/public_html/system/library/db.php(45): DB\MySQLi->query()
#1 /home/sendflowersandmore.com/public_html/catalog/model/dyncategory/supportingFunctions.php(1712): DB->query()
#2 /home/sendflowersandmore.com/public_html/system/engine/loader.php(258): ModelDynCategorySupportingFunctions->getDyncategoryProducts()
#3 /home/sendflowersandmore.com/public_html/system/engine/proxy.php(41): Loader->{closure}()
#4 /home/sendflowersandmore.com/public_html/catalog/controller/dyncategory/dyncategory_index_inc.php(794): Proxy->__call()
#5 /home/sendflowersandmore.com/public_html/catalog/controller/dyncategory/dyncategory_v4_index_inc.php(30): include('...')
#6 /home/sendflowersandmore.com/public_html/catalog/controller/dyncategory/dyncategory_v4.php(4): include('...')
#7 /home/sendflowersandmore.com/public_html/system/engine/action.php(79): ControllerDyncategoryDyncategoryV4->index()
#8 /home/sendflowersandmore.com/public_html/catalog/controller/startup/router.php(27): Action->execute()
#9 /home/sendflowersandmore.com/public_html/system/engine/action.php(79): ControllerStartupRouter->index()
#10 /home/sendflowersandmore.com/public_html/system/engine/router.php(67): Action->execute()
#11 /home/sendflowersandmore.com/public_html/system/engine/router.php(56): Router->execute()
#12 /home/sendflowersandmore.com/public_html/system/framework.php(203): Router->dispatch()
#13 /home/sendflowersandmore.com/public_html/system/startup.php(106): require_once('...')
#14 /home/sendflowersandmore.com/public_html/index.php(64): start()
#15 {main}
thrown in /home/sendflowersandmore.com/public_html/system/library/db/mysqli.php on line 67