Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-7b801e-5739.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 (1607610,1607646,1607987,1607755,1608828,1607644,1607865,1607679,1607635,1607367,1607405,1607748,1607931,1607700,1607747,1607767,1607772,1607645,1607706,1607787,1607788,1608033,1608062,1607923,1607760,1607642,1607660,1607715,1607773,1608020,1607333,1608768,1608455,1608814,1608634,1608587,1608726,1607656,1608894,1608554,1608626,1608616,1608583,1608409,1608490,1608477,1608486,1608838,1608580,1608672,1608533,1608552,1607620,1608750,1608423,1607601,1607605,1608611,1608704,1608586,1608657,1608263,1608581,1608592,1608416,1608759,1608719,1608656,1608255,1608653,1607600,1608376,1608548,1608259,1608776,1608491,1608428,1608692,1608424,1608464,1608625,1608479,1608788,1607625,1608779,1608650,1608655,1608747,1608589,1607657,1608275,1608254,1608535,1608467,1608484,1608273,1607637,1608807,1607613,1608627,1608646,1608439,1608652,1608671,1608274,1608299,1608534,1608607,1607631,1608296,1608660,1608829,1608520,1608524,1608565,1608633,1608818,1608674,1608629,1608910,1608638,1608737,1608489,1608466,1607444,1607629,1607655,1608798,1608746,1608287,1608648,1608679,1608761,1608545,1607598,1607321,1607682,1607599,1608661,1608662,1608822,1608896,1608469,1608536,1608749,1608693,1607603,1608547,1608488,1608481,1607651,1607604,1607608,1607609,1608647,1608282,1608659,1607621,1608706,1607636,1608558,1608821,1608364,1608357,1608742,1608830,1608811,1608400,1608482,1373135,1608714,1608711,1607640,1607653,1608260,1608264,1608265,1608276,1608289,1608290,1608304,1608305,1608365,1608405,1608506,1608526,1608615,1608722,1608723,1608732,1608787,1608810,1608817,1608827) ORDER BY FIELD(p.product_id, 1607610,1607646,1607987,1607755,1608828,1607644,1607865,1607679,1607635,1607367,1607405,1607748,1607931,1607700,1607747,1607767,1607772,1607645,1607706,1607787,1607788,1608033,1608062,1607923,1607760,1607642,1607660,1607715,1607773,1608020,1607333,1608768,1608455,1608814,1608634,1608587,1608726,1607656,1608894,1608554,1608626,1608616,1608583,1608409,1608490,1608477,1608486,1608838,1608580,1608672,1608533,1608552,1607620,1608750,1608423,1607601,1607605,1608611,1608704,1608586,1608657,1608263,1608581,1608592,1608416,1608759,1608719,1608656,1608255,1608653,1607600,1608376,1608548,1608259,1608776,1608491,1608428,1608692,1608424,1608464,1608625,1608479,1608788,1607625,1608779,1608650,1608655,1608747,1608589,1607657,1608275,1608254,1608535,1608467,1608484,1608273,1607637,1608807,1607613,1608627,1608646,1608439,1608652,1608671,1608274,1608299,1608534,1608607,1607631,1608296,1608660,1608829,1608520,1608524,1608565,1608633,1608818,1608674,1608629,1608910,1608638,1608737,1608489,1608466,1607444,1607629,1607655,1608798,1608746,1608287,1608648,1608679,1608761,1608545,1607598,1607321,1607682,1607599,1608661,1608662,1608822,1608896,1608469,1608536,1608749,1608693,1607603,1608547,1608488,1608481,1607651,1607604,1607608,1607609,1608647,1608282,1608659,1607621,1608706,1607636,1608558,1608821,1608364,1608357,1608742,1608830,1608811,1608400,1608482,1373135,1608714,1608711,1607640,1607653,1608260,1608264,1608265,1608276,1608289,1608290,1608304,1608305,1608365,1608405,1608506,1608526,1608615,1608722,1608723,1608732,1608787,1608810,1608817,1608827) 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