Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-7c1b07-bce4.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 (1940769,1942558,1942507,1942553,1940756,1948822,1948823,1942713,1948821,1940770,1940768,1942725,1942761,1539706,1940758,1940759,1942743,1940757,1940771,1435295,1392712,1942555,1940745,1940038,1940489,1942520,1940747,1948825,1910382,1910384,1910390,1910392,1910396,1940416,1940422,1939936,1942554,1942724,1942762,1940764,1940761,1324589,1939932,1940751,1942737,1446432,1940763,1910351,1939928,1940501,1940505,1940509,1940513,1940517,1940521,1940525,1940529,1940533,1940557,1940569,1858604,1940753,1446426,1942272,1942730,1942739,1394216,1940083,1941464,1940755,1865000,1910512,1940767,1910457,1910462,1940017,1940021,1940029,1940081,1941465,1941466,1941476,1864989,1886822,1940766,1941478,1941438,1941472,1939922,1940039,1940041,1939962,1941467,1941474,1864964,1886817,1940762,1940046,1404284,1830958,1858627,1941471,1939972,1939973,1940023,1941410,1899302,1833959,1404282,1404290,1404292,1404294,1941434,1830954,1942745,1864990,1258481,1676004,1864883,1939968,1940750,1324592,1324568,1942249,1942274,1942296,1942330,1942333,1942338,1864973,1833840,1833853,1941435,1941468,1886826,1335789,1886896,1899306,1910460,1940749,1833831,1830971,1939994,1940055,1940072,1910463,1538579,1833843,1833981,1864882,1910464,1917696,1917704,1927073,1927132,1939908,1939984,1940030,1940059,1940060,1940069,1940071,1940073,1940077,1940080,1940754,1941406,1404299) ORDER BY FIELD(p.product_id, 1940769,1942558,1942507,1942553,1940756,1948822,1948823,1942713,1948821,1940770,1940768,1942725,1942761,1539706,1940758,1940759,1942743,1940757,1940771,1435295,1392712,1942555,1940745,1940038,1940489,1942520,1940747,1948825,1910382,1910384,1910390,1910392,1910396,1940416,1940422,1939936,1942554,1942724,1942762,1940764,1940761,1324589,1939932,1940751,1942737,1446432,1940763,1910351,1939928,1940501,1940505,1940509,1940513,1940517,1940521,1940525,1940529,1940533,1940557,1940569,1858604,1940753,1446426,1942272,1942730,1942739,1394216,1940083,1941464,1940755,1865000,1910512,1940767,1910457,1910462,1940017,1940021,1940029,1940081,1941465,1941466,1941476,1864989,1886822,1940766,1941478,1941438,1941472,1939922,1940039,1940041,1939962,1941467,1941474,1864964,1886817,1940762,1940046,1404284,1830958,1858627,1941471,1939972,1939973,1940023,1941410,1899302,1833959,1404282,1404290,1404292,1404294,1941434,1830954,1942745,1864990,1258481,1676004,1864883,1939968,1940750,1324592,1324568,1942249,1942274,1942296,1942330,1942333,1942338,1864973,1833840,1833853,1941435,1941468,1886826,1335789,1886896,1899306,1910460,1940749,1833831,1830971,1939994,1940055,1940072,1910463,1538579,1833843,1833981,1864882,1910464,1917696,1917704,1927073,1927132,1939908,1939984,1940030,1940059,1940060,1940069,1940071,1940073,1940077,1940080,1940754,1941406,1404299) 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