Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-8241c4-1a9b0.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 (1231448,1618567,1230916,1231233,1231450,1231254,1799453,1231238,1732185,1731099,1231759,1786686,1824649,1231146,1230860,1230920,1341130,1618588,1877850,1379072,1618552,1694617,1732179,1780194,1230861,1230917,1230923,1231607,1231763,1379061,1404010,1619570,1694613,1824661,1231267,1619577,1786687,1526500,1582089,1549626,1618823,1618799,1747748,1231143,1231251,1231266,1619608,1668270,1694616,1619596,1688124,1692800,1619568,1770232,1231253,1549629,1231613,1549630,1415988,1415993,1618524,1618811,1618834,1692802,1619590,1231264,1848202,1668250,1230859,1476931,1415989,1688125,1619812,1618555,1549620,1780197,1780199,1780204,1878919,1786684,1878916,1618751,1618536,1869207,1732187,1878915,1231154,1231281,1231431,1231685,1231782,1379065,1476942,1688117,1231277,1618793,1810744,1688123,1231249,1694614,1877854,1476953,1619580,1786688,1877853,1877855,1231097,1231270,1231274,1231779,1379055,1379057,1379074,1379075,1476920,1476921,1476950,1549631,1571054,1618752,1692801,1693380,1784686,1784689,1786689,1869194,1878913) ORDER BY FIELD(p.product_id, 1231448,1618567,1230916,1231233,1231450,1231254,1799453,1231238,1732185,1731099,1231759,1786686,1824649,1231146,1230860,1230920,1341130,1618588,1877850,1379072,1618552,1694617,1732179,1780194,1230861,1230917,1230923,1231607,1231763,1379061,1404010,1619570,1694613,1824661,1231267,1619577,1786687,1526500,1582089,1549626,1618823,1618799,1747748,1231143,1231251,1231266,1619608,1668270,1694616,1619596,1688124,1692800,1619568,1770232,1231253,1549629,1231613,1549630,1415988,1415993,1618524,1618811,1618834,1692802,1619590,1231264,1848202,1668250,1230859,1476931,1415989,1688125,1619812,1618555,1549620,1780197,1780199,1780204,1878919,1786684,1878916,1618751,1618536,1869207,1732187,1878915,1231154,1231281,1231431,1231685,1231782,1379065,1476942,1688117,1231277,1618793,1810744,1688123,1231249,1694614,1877854,1476953,1619580,1786688,1877853,1877855,1231097,1231270,1231274,1231779,1379055,1379057,1379074,1379075,1476920,1476921,1476950,1549631,1571054,1618752,1692801,1693380,1784686,1784689,1786689,1869194,1878913) 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