Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-7f4704-8965.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 (1629775,1629718,1629722,1743843,1629716,1629717,1629752,1629727,1767006,1743841,1526941,1743837,1825204,1629721,1629719,1629774,1629725,1629735,1629744,1629773,1629797,1629714,1694710,1485041,1485084,1629742,1629737,1884697,1629770,1743845,1416139,1915296,1416134,1629739,1743955,1825169,1747875,1743866,1416124,1630954,1416173,1629732,1631034,1743940,1825188,1630965,1825167,1825175,1743834,1825190,1629724,1629747,1629740,1743898,1416138,1825189,1819330,1743849,1629805,1743917,1743872,1629799,1630037,1743936,1851436,1915270,1629720,1629865,1629755,1743850,1743880,1851457,1915294,1685406,1825177,1913714,1629767,1731325,1743906,1743952,1630051,1825176,1825184,1825202,1822587,1743920,1743925,1629729,1915292,1582280,1743904,1631106,1630036,1743875,1629901,1825187,1629726,1526940,1549822,1549823,1549826,1549836,1629738,1629750,1629763,1629788,1630023,1694719,1732272,1732273,1747876,1747878,1747879,1747881,1747882,1747883,1747885,1747890,1819407,1819410,1825193,1825199,1913711,1913712,1913713,1668445,1688267,1825183,1743914,1825155,1825178,1629891,1582266,1629801,1743927,1747887,1565640,1668446,1825181,1629715,1694721,1485014,1747874,1758938,1743950,1822590,1485082,1485083,1822588,1485066,1485068,1485080,1485081,1526923,1526924,1549825,1582257,1582258,1582259,1582260,1582268,1582269,1582270,1582271,1582272,1582273,1582274,1582275,1582277,1582278,1582279,1629745,1630696,1631062,1668443,1685399,1694712,1694720,1743842,1743876,1743890,1743939,1743941,1747877,1747880,1747884,1747886,1747888,1747889,1758939,1819385,1822584,1822586,1822589,1822591,1822592,1825196,1825201) ORDER BY FIELD(p.product_id, 1629775,1629718,1629722,1743843,1629716,1629717,1629752,1629727,1767006,1743841,1526941,1743837,1825204,1629721,1629719,1629774,1629725,1629735,1629744,1629773,1629797,1629714,1694710,1485041,1485084,1629742,1629737,1884697,1629770,1743845,1416139,1915296,1416134,1629739,1743955,1825169,1747875,1743866,1416124,1630954,1416173,1629732,1631034,1743940,1825188,1630965,1825167,1825175,1743834,1825190,1629724,1629747,1629740,1743898,1416138,1825189,1819330,1743849,1629805,1743917,1743872,1629799,1630037,1743936,1851436,1915270,1629720,1629865,1629755,1743850,1743880,1851457,1915294,1685406,1825177,1913714,1629767,1731325,1743906,1743952,1630051,1825176,1825184,1825202,1822587,1743920,1743925,1629729,1915292,1582280,1743904,1631106,1630036,1743875,1629901,1825187,1629726,1526940,1549822,1549823,1549826,1549836,1629738,1629750,1629763,1629788,1630023,1694719,1732272,1732273,1747876,1747878,1747879,1747881,1747882,1747883,1747885,1747890,1819407,1819410,1825193,1825199,1913711,1913712,1913713,1668445,1688267,1825183,1743914,1825155,1825178,1629891,1582266,1629801,1743927,1747887,1565640,1668446,1825181,1629715,1694721,1485014,1747874,1758938,1743950,1822590,1485082,1485083,1822588,1485066,1485068,1485080,1485081,1526923,1526924,1549825,1582257,1582258,1582259,1582260,1582268,1582269,1582270,1582271,1582272,1582273,1582274,1582275,1582277,1582278,1582279,1629745,1630696,1631062,1668443,1685399,1694712,1694720,1743842,1743876,1743890,1743939,1743941,1747877,1747880,1747884,1747886,1747888,1747889,1758939,1819385,1822584,1822586,1822589,1822591,1822592,1825196,1825201) 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