Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-7e94f2-a83e.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 (1442009,1460313,1460390,1460375,1907546,1907543,1460376,1460455,1460443,1460330,1442028,1442018,1460316,1424769,1666808,1460435,1460306,1460336,1460487,1460333,1460301,1933995,1460396,1907554,1460467,1887932,1907559,1460322,1460320,1666814,1907628,1907629,1907574,1907577,1907580,1934001,1460511,1798269,1460311,1492564,1723395,1907588,1907627,1424754,1732499,1907630,1492570,1558348,1732451,1810928,1907599,1907625,1907626,1869553,1887892,1558357,1460310,1442026,1460314,1688424,1831937,1887931,1907604,1907624,1887933,1695255,1798259,1907623,1666789,1907617,1796254,1460451,1732497,1810958,1887928,1666777,1907611,1907614,1907622,1558355,1732492,1810943,1907497,1666783,1732444,1732494,1751426,1907476,1907483,1907492,1907583,1424770,1907664,1907671,1907672,1460407,1460305,1732460,1460317,1460323,1808759,1933999,1934004,1907637,1907638,1934002,1460319,1558360,1424771,1460415,1460427,1460321,1933994,1558354,1796251,1808752,1869565,1873972,1880543,1907639,1933993,1933996,1933997,1933998,1934000,1934003) ORDER BY FIELD(p.product_id, 1442009,1460313,1460390,1460375,1907546,1907543,1460376,1460455,1460443,1460330,1442028,1442018,1460316,1424769,1666808,1460435,1460306,1460336,1460487,1460333,1460301,1933995,1460396,1907554,1460467,1887932,1907559,1460322,1460320,1666814,1907628,1907629,1907574,1907577,1907580,1934001,1460511,1798269,1460311,1492564,1723395,1907588,1907627,1424754,1732499,1907630,1492570,1558348,1732451,1810928,1907599,1907625,1907626,1869553,1887892,1558357,1460310,1442026,1460314,1688424,1831937,1887931,1907604,1907624,1887933,1695255,1798259,1907623,1666789,1907617,1796254,1460451,1732497,1810958,1887928,1666777,1907611,1907614,1907622,1558355,1732492,1810943,1907497,1666783,1732444,1732494,1751426,1907476,1907483,1907492,1907583,1424770,1907664,1907671,1907672,1460407,1460305,1732460,1460317,1460323,1808759,1933999,1934004,1907637,1907638,1934002,1460319,1558360,1424771,1460415,1460427,1460321,1933994,1558354,1796251,1808752,1869565,1873972,1880543,1907639,1933993,1933996,1933997,1933998,1934000,1934003) 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