Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-82570f-1aae8.MAD' (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 (1124495,1124526,1429472,1947518,1429458,1947517,1135944,1260946,1260944,1170423,1170421,1124512,1260954,1065720,1429466,1679080,1135943,1480961,1124511,1784566,1260953,1679078,1124493,1880365,1124490,1577605,1124508,1260974,1784565,1880367,1880362,1429455,1577625,1124516,1260945,1260948,1260969,1880366,1065813,1429467,1429480,1784546,1135945,1880364,1124523,1688952,1065799,1124436,1124487,1860560,1880363,1157455,1124491,1124509,1260964,1429454,1124435,1065718,1260942,1429469,1577602,1880337,1880359,1065816,1429456,1124419,1124507,1124498,1170416,1429479,1880361,1260940,1429468,1170422,1065766,1480966,1124482,1577646,1429459,1124521,1157468,1554015,1124420,1679076,1320140,1124525,1065805,1260971,1065770,1320130,1170417,1260976,1124438,1429471,1124513,1065829,1577600,1260982,1065765,1170418,1124528,1157463,1880360,1429470,1480963,1480965,1124517,1170419,1065774,1065802,1065814,1124422,1124483,1157433,1065728,1065729,1065730,1065731,1065732,1065733,1065734,1065735,1065767,1065768,1065771,1065772,1065775,1065776,1065778,1065779,1065780,1065781,1065782,1065783,1065784,1065792,1065793,1065794,1065825,1065826,1124418,1124424,1124425,1124431,1124437,1124461,1124462,1124463,1124464,1124465,1124466,1124467,1124468,1124469,1124470,1124471,1124473,1124474,1124475,1124476,1124477,1124478,1124480,1124485,1124488,1124489,1124527,1157442,1157445,1170425,1260950,1260963,1260979,1260980,1260984,1260986,1260987,1260988,1260989,1260992,1260994,1260995,1320137,1429457,1429475,1429476,1429477,1429478,1480964,1554000,1577603,1577604,1679081,1679083,1688951,1880346,1880350,1065817,1124430,1320136) ORDER BY FIELD(p.product_id, 1124495,1124526,1429472,1947518,1429458,1947517,1135944,1260946,1260944,1170423,1170421,1124512,1260954,1065720,1429466,1679080,1135943,1480961,1124511,1784566,1260953,1679078,1124493,1880365,1124490,1577605,1124508,1260974,1784565,1880367,1880362,1429455,1577625,1124516,1260945,1260948,1260969,1880366,1065813,1429467,1429480,1784546,1135945,1880364,1124523,1688952,1065799,1124436,1124487,1860560,1880363,1157455,1124491,1124509,1260964,1429454,1124435,1065718,1260942,1429469,1577602,1880337,1880359,1065816,1429456,1124419,1124507,1124498,1170416,1429479,1880361,1260940,1429468,1170422,1065766,1480966,1124482,1577646,1429459,1124521,1157468,1554015,1124420,1679076,1320140,1124525,1065805,1260971,1065770,1320130,1170417,1260976,1124438,1429471,1124513,1065829,1577600,1260982,1065765,1170418,1124528,1157463,1880360,1429470,1480963,1480965,1124517,1170419,1065774,1065802,1065814,1124422,1124483,1157433,1065728,1065729,1065730,1065731,1065732,1065733,1065734,1065735,1065767,1065768,1065771,1065772,1065775,1065776,1065778,1065779,1065780,1065781,1065782,1065783,1065784,1065792,1065793,1065794,1065825,1065826,1124418,1124424,1124425,1124431,1124437,1124461,1124462,1124463,1124464,1124465,1124466,1124467,1124468,1124469,1124470,1124471,1124473,1124474,1124475,1124476,1124477,1124478,1124480,1124485,1124488,1124489,1124527,1157442,1157445,1170425,1260950,1260963,1260979,1260980,1260984,1260986,1260987,1260988,1260989,1260992,1260994,1260995,1320137,1429457,1429475,1429476,1429477,1429478,1480964,1554000,1577603,1577604,1679081,1679083,1688951,1880346,1880350,1065817,1124430,1320136) 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