Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-811b1a-1859f.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 (1948608,1948614,1948611,1948606,1948599,1948615,1948598,1948601,1948607,1948619,1948618,1948612,1948603,1946350,1946352,1948589,1948600,1948602,1948604,1948613,1947888,1948000,1948005,1948006,1948009,1948013,1948014,1948019,1948020,1948024,1948025,1948027,1948028,1948029,1948030,1948031,1948032,1948033,1948034,1948035,1948044,1948047,1948050,1948051,1948052,1948055,1948061,1948080,1948085,1948094,1948109,1948112,1948113,1948132,1948133,1948147,1948178,1948245,1948251,1948255,1948259,1948261,1948262,1948263,1948264,1948265,1948272,1948284,1948287,1948288,1948289,1948401,1948421,1948583,1948605,1948617,1947872,1947935,1947957,1947963,1947972,1947973,1947976,1947980,1947981,1948001,1948003,1948008,1948010,1948011,1948012,1948026,1948036,1948037,1948040,1948041,1948045,1948046,1948048,1948053,1948056,1948058,1948062,1948064,1948066,1948068,1948069,1948070,1948091,1948092,1948101,1948111,1948116,1948117,1948122,1948128,1948129,1948134,1948135,1948137,1948138,1948139,1948142,1948144,1948146,1948182,1948183,1948184,1948238,1948240,1948252,1948268,1948269,1948270,1948271,1948273,1948275,1948286,1948392,1948399,1948584,1948585,1948616,1946351,1947962,1948179,1948609,1948610,1508220,1410677,1508230,1554199,1508235,1928300,1410680,1321695,1883296,1721918,1778919,1928409,1637129,1637137,1637205,1410674,1410678,1410675,1410676,1410679,1410681,1410682,1410683,1410684,1721912,1410696,1637709,1637713,1410693,1410690,1410694,1553271,1507925,1508232,1738599,1507834,1507842,1507887,1508051,1508069,1508075,1508077,1508216,1508229,1508234,1553252,1559761,1666741,1883116,1507853,1507886,1507936,1507952,1507986,1508038,1508041,1508056,1508061,1508080,1508084,1508101,1508165,1508167,1508174,1508227,1508239,1508244,1559749,1559778,1670343,1709154,1709163,1720429,1720436,1738591,1738618,1822277,1822278,1822280,1832153,1883117,1884258,1566072,1822283,1928408,1518321) ORDER BY FIELD(p.product_id, 1948608,1948614,1948611,1948606,1948599,1948615,1948598,1948601,1948607,1948619,1948618,1948612,1948603,1946350,1946352,1948589,1948600,1948602,1948604,1948613,1947888,1948000,1948005,1948006,1948009,1948013,1948014,1948019,1948020,1948024,1948025,1948027,1948028,1948029,1948030,1948031,1948032,1948033,1948034,1948035,1948044,1948047,1948050,1948051,1948052,1948055,1948061,1948080,1948085,1948094,1948109,1948112,1948113,1948132,1948133,1948147,1948178,1948245,1948251,1948255,1948259,1948261,1948262,1948263,1948264,1948265,1948272,1948284,1948287,1948288,1948289,1948401,1948421,1948583,1948605,1948617,1947872,1947935,1947957,1947963,1947972,1947973,1947976,1947980,1947981,1948001,1948003,1948008,1948010,1948011,1948012,1948026,1948036,1948037,1948040,1948041,1948045,1948046,1948048,1948053,1948056,1948058,1948062,1948064,1948066,1948068,1948069,1948070,1948091,1948092,1948101,1948111,1948116,1948117,1948122,1948128,1948129,1948134,1948135,1948137,1948138,1948139,1948142,1948144,1948146,1948182,1948183,1948184,1948238,1948240,1948252,1948268,1948269,1948270,1948271,1948273,1948275,1948286,1948392,1948399,1948584,1948585,1948616,1946351,1947962,1948179,1948609,1948610,1508220,1410677,1508230,1554199,1508235,1928300,1410680,1321695,1883296,1721918,1778919,1928409,1637129,1637137,1637205,1410674,1410678,1410675,1410676,1410679,1410681,1410682,1410683,1410684,1721912,1410696,1637709,1637713,1410693,1410690,1410694,1553271,1507925,1508232,1738599,1507834,1507842,1507887,1508051,1508069,1508075,1508077,1508216,1508229,1508234,1553252,1559761,1666741,1883116,1507853,1507886,1507936,1507952,1507986,1508038,1508041,1508056,1508061,1508080,1508084,1508101,1508165,1508167,1508174,1508227,1508239,1508244,1559749,1559778,1670343,1709154,1709163,1720429,1720436,1738591,1738618,1822277,1822278,1822280,1832153,1883117,1884258,1566072,1822283,1928408,1518321) ASC, LCASE(pd.name) ASC, p.product_id ASC LIMIT 20,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