Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-8284cc-1293f.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 (1340792,1549018,1182239,1930774,1340789,1220256,1217161,1320280,1608928,1416465,1320298,1416453,1830854,1354605,1449790,1217458,1323995,1878578,1182454,1213546,1217160,1608918,1608927,1436859,1912091,1540273,1702194,1732507,1840529,1840531,1217163,1182418,1217438,1320278,1385556,1730272,1182260,1513084,1218236,1908187,1548956,1354637,1845506,1452372,1340801,1930783,1483746,1250088,1354623,1250017,1218227,1407045,1661639,1452362,1930692,1608917,1387614,1452356,1483769,1548933,1250063,1886271,1249998,1930265,1217443,1220258,1354057,1217155,1250000,1320279,1452360,1503278,1884603,1452369,1863823,1762789,1250013,1912095,1449823,1845336,1250107,1452347,1548950,1931418,1564266,1416424,1914553,1609020,1609847,1873801,1690855,1392908,1873810,1908218,1513404,1826264,1908209,1818286,1452370,1897402,1931417,1263779,1320303,1250015,1878573,1812844,1812858,1452349,1863894,1320299,1220262,1416449,1609151,1452375,1354064,1449800,1930282,1930253,1220249,1930756,1250012,1250056,1762808,1930753,1609071,1249992,1608930,1609024,1845537,1845528,1845116,1845372,1340794,1250035,1930283,1512980,1513143,1513513,1513797,1249989,1878577,1666082,1914525,1914527,1609363,1845487,1250040,1416432,1912092,1687989,1908110,1513386,1387581,1320282,1845549,1608967,1930284,1452350,1250060,1930785,1854556,1609963,1884565,1742295,1878559,1321737,1249983,1513679,1513670,1884534,1887797,1845357,1250039,1354074,1526139,1822425,1513579,1321734,1610212,1886418,1930306,1513759,1914551,1712746,1513011,1712588,1664315,1609491,1321736,1513188,1900004,1548903,1802250,1930689,1908116,1320287,1213721,1908231,1320304,1416433,1416469) ORDER BY FIELD(p.product_id, 1340792,1549018,1182239,1930774,1340789,1220256,1217161,1320280,1608928,1416465,1320298,1416453,1830854,1354605,1449790,1217458,1323995,1878578,1182454,1213546,1217160,1608918,1608927,1436859,1912091,1540273,1702194,1732507,1840529,1840531,1217163,1182418,1217438,1320278,1385556,1730272,1182260,1513084,1218236,1908187,1548956,1354637,1845506,1452372,1340801,1930783,1483746,1250088,1354623,1250017,1218227,1407045,1661639,1452362,1930692,1608917,1387614,1452356,1483769,1548933,1250063,1886271,1249998,1930265,1217443,1220258,1354057,1217155,1250000,1320279,1452360,1503278,1884603,1452369,1863823,1762789,1250013,1912095,1449823,1845336,1250107,1452347,1548950,1931418,1564266,1416424,1914553,1609020,1609847,1873801,1690855,1392908,1873810,1908218,1513404,1826264,1908209,1818286,1452370,1897402,1931417,1263779,1320303,1250015,1878573,1812844,1812858,1452349,1863894,1320299,1220262,1416449,1609151,1452375,1354064,1449800,1930282,1930253,1220249,1930756,1250012,1250056,1762808,1930753,1609071,1249992,1608930,1609024,1845537,1845528,1845116,1845372,1340794,1250035,1930283,1512980,1513143,1513513,1513797,1249989,1878577,1666082,1914525,1914527,1609363,1845487,1250040,1416432,1912092,1687989,1908110,1513386,1387581,1320282,1845549,1608967,1930284,1452350,1250060,1930785,1854556,1609963,1884565,1742295,1878559,1321737,1249983,1513679,1513670,1884534,1887797,1845357,1250039,1354074,1526139,1822425,1513579,1321734,1610212,1886418,1930306,1513759,1914551,1712746,1513011,1712588,1664315,1609491,1321736,1513188,1900004,1548903,1802250,1930689,1908116,1320287,1213721,1908231,1320304,1416433,1416469) 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