Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-805ac9-1e6fa.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 (1818797,1231294,1731099,1618948,1231238,1799452,1618844,1818815,1231448,1732185,1799453,1618835,1618879,1619187,1731093,1809072,1618567,1618552,1231091,1495467,1618821,1618833,1619577,1618810,1231254,1549626,1526487,1732180,1618823,1731100,1818792,1732179,1877850,1231200,1619600,1619608,1618588,1668269,1694616,1694617,1619576,1731114,1618532,1618524,1618834,1732186,1582089,1620094,1619609,1731106,1900514,1668250,1618820,1618538,1618529,1618544,1231266,1620099,1618525,1618549,1618825,1618555,1231251,1618572,1731103,1618553,1692800,1618536,1618566,1618514,1619745,1231253,1688117,1618586,1618625,1618513,1619564,1619557,1732188,1571052,1549620,1732187,1731112,1231154,1231228,1231281,1618563,1379075,1476920,1571054,1618840,1618853,1618862,1619565,1694614,1731111,1732189,1810744,1810752,1818808,1818812,1900512) ORDER BY FIELD(p.product_id, 1818797,1231294,1731099,1618948,1231238,1799452,1618844,1818815,1231448,1732185,1799453,1618835,1618879,1619187,1731093,1809072,1618567,1618552,1231091,1495467,1618821,1618833,1619577,1618810,1231254,1549626,1526487,1732180,1618823,1731100,1818792,1732179,1877850,1231200,1619600,1619608,1618588,1668269,1694616,1694617,1619576,1731114,1618532,1618524,1618834,1732186,1582089,1620094,1619609,1731106,1900514,1668250,1618820,1618538,1618529,1618544,1231266,1620099,1618525,1618549,1618825,1618555,1231251,1618572,1731103,1618553,1692800,1618536,1618566,1618514,1619745,1231253,1688117,1618586,1618625,1618513,1619564,1619557,1732188,1571052,1549620,1732187,1731112,1231154,1231228,1231281,1618563,1379075,1476920,1571054,1618840,1618853,1618862,1619565,1694614,1731111,1732189,1810744,1810752,1818808,1818812,1900512) 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