Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-7c2a9f-1b18f.MAD' (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 (1512826,1512861,1810139,1512841,1773902,1512863,1863263,1512844,1733497,1512853,1512825,1733496,1733498,1773922,1512858,1863198,1733456,1863167,1512854,1773875,1863209,1733461,1773923,1773935,1512804,1895908,1512855,1733480,1733435,1863166,1773905,1863192,1733463,1512158,1895904,1512832,1512869,1863180,1810147,1773940,1733469,1733465,1773920,1733457,1512766,1512828,1512833,1512836,1733485,1733486,1733492,1733493,1733494,1733501,1773897,1773898,1773946,1773982,1773988,1863202,1863211,1863230,1895913,1895915,1733444,1288620,1733464,1512153,1512790,1288548,1733441,1512847,1733484,1288619,1733502,1512157,1512764,1512805,1512866,1512868,1512870,1699685,1699700,1699800,1733438,1733439,1733450,1733451,1733452,1733453,1733454,1733459,1733460,1733467,1733471,1733472,1733473,1733474,1733475,1733476,1733477,1733478,1733479,1733481,1733482,1733483,1733487,1733491,1733500,1733504,1733509,1773873,1773899,1773900,1773903,1773921,1773933,1773941,1773949,1773950,1773957,1773998,1774001,1810132,1810134,1810137,1810138,1810140,1863178,1863194,1863199,1863200,1863206,1863224,1863266,1895898,1895899,1895900,1895901,1895903,1895906,1895909,1895911,1895914,1895916,1733462,1288532,1288523,1288528,1733458,1733434,1288608,1733468,1733455,1288517,1288533,1288543,1733507,1733436,1773904,1288617,1288537,1512770,1733470,1288539,1288610,1288547,1288540,1288538,1288546,1288534,1288541,1288516,1288531,1288536,1288542,1733503,1288525,1288544,1288549,1288611,1288612,1288613,1512838,1699691,1733437,1733440,1733442,1733443,1733466,1733495,1733499,1773937,1773947,1810133,1810141,1863208,1863228,1895905,1895925,1288618,1288535) ORDER BY FIELD(p.product_id, 1512826,1512861,1810139,1512841,1773902,1512863,1863263,1512844,1733497,1512853,1512825,1733496,1733498,1773922,1512858,1863198,1733456,1863167,1512854,1773875,1863209,1733461,1773923,1773935,1512804,1895908,1512855,1733480,1733435,1863166,1773905,1863192,1733463,1512158,1895904,1512832,1512869,1863180,1810147,1773940,1733469,1733465,1773920,1733457,1512766,1512828,1512833,1512836,1733485,1733486,1733492,1733493,1733494,1733501,1773897,1773898,1773946,1773982,1773988,1863202,1863211,1863230,1895913,1895915,1733444,1288620,1733464,1512153,1512790,1288548,1733441,1512847,1733484,1288619,1733502,1512157,1512764,1512805,1512866,1512868,1512870,1699685,1699700,1699800,1733438,1733439,1733450,1733451,1733452,1733453,1733454,1733459,1733460,1733467,1733471,1733472,1733473,1733474,1733475,1733476,1733477,1733478,1733479,1733481,1733482,1733483,1733487,1733491,1733500,1733504,1733509,1773873,1773899,1773900,1773903,1773921,1773933,1773941,1773949,1773950,1773957,1773998,1774001,1810132,1810134,1810137,1810138,1810140,1863178,1863194,1863199,1863200,1863206,1863224,1863266,1895898,1895899,1895900,1895901,1895903,1895906,1895909,1895911,1895914,1895916,1733462,1288532,1288523,1288528,1733458,1733434,1288608,1733468,1733455,1288517,1288533,1288543,1733507,1733436,1773904,1288617,1288537,1512770,1733470,1288539,1288610,1288547,1288540,1288538,1288546,1288534,1288541,1288516,1288531,1288536,1288542,1733503,1288525,1288544,1288549,1288611,1288612,1288613,1512838,1699691,1733437,1733440,1733442,1733443,1733466,1733495,1733499,1773937,1773947,1810133,1810141,1863208,1863228,1895905,1895925,1288618,1288535) 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