Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-8249d3-fc86.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 (1685185,1685173,1231174,1415997,1685157,1231010,1685162,1685158,1685152,1685183,1416002,1685175,1685193,1685154,1685159,1685160,1685192,1484433,1685169,1415996,1484375,1685182,1416000,1484434,1416007,1685165,1685189,1685156,1685161,1231624,1685153,1416006,1415978,1484424,1415999,1484427,1415974,1231508,1484399,1484348,1685171,1416028,1685148,1685167,1685168,1685180,1685170,1416021,1685191,1416025,1685178,1685155,1416034,1685188,1685166,1230916,1416032,1231660,1230979,1685194,1685184,1415985,1685149,1685151,1484435,1685147,1685164,1230892,1231115,1231164,1231603,1415976,1484362,1231124,1484353,1231099,1230997,1254018,1231233,1685163,1231766,1415998,1415988,1415993,1415990,1231751,1685181,1230969,1231267,1231656,1416026,1685150,1415972,1231210,1231201,1231104,1685196,1415973,1231264,1231616,1231209,1231760,1231831,1685174,1415984,1230872,1230982,1231349,1231556,1415989,1231158,1416027,1685190,1685172,1416014,1416035,1231001,1231135,1685179,1231499,1415980,1416024,1231147,1685195,1231075,1231169,1231375,1231512,1685186,1254013,1231639,1231298,1231682,1685176,1254025,1231854,1254011,1685177,1254002,1714133,1230850,1231630,1231277,1231266,1230988,1231200,1231228,1231246,1231281,1231311,1231507,1231685,1416017,1416023,1416033,1732669) ORDER BY FIELD(p.product_id, 1685185,1685173,1231174,1415997,1685157,1231010,1685162,1685158,1685152,1685183,1416002,1685175,1685193,1685154,1685159,1685160,1685192,1484433,1685169,1415996,1484375,1685182,1416000,1484434,1416007,1685165,1685189,1685156,1685161,1231624,1685153,1416006,1415978,1484424,1415999,1484427,1415974,1231508,1484399,1484348,1685171,1416028,1685148,1685167,1685168,1685180,1685170,1416021,1685191,1416025,1685178,1685155,1416034,1685188,1685166,1230916,1416032,1231660,1230979,1685194,1685184,1415985,1685149,1685151,1484435,1685147,1685164,1230892,1231115,1231164,1231603,1415976,1484362,1231124,1484353,1231099,1230997,1254018,1231233,1685163,1231766,1415998,1415988,1415993,1415990,1231751,1685181,1230969,1231267,1231656,1416026,1685150,1415972,1231210,1231201,1231104,1685196,1415973,1231264,1231616,1231209,1231760,1231831,1685174,1415984,1230872,1230982,1231349,1231556,1415989,1231158,1416027,1685190,1685172,1416014,1416035,1231001,1231135,1685179,1231499,1415980,1416024,1231147,1685195,1231075,1231169,1231375,1231512,1685186,1254013,1231639,1231298,1231682,1685176,1254025,1231854,1254011,1685177,1254002,1714133,1230850,1231630,1231277,1231266,1230988,1231200,1231228,1231246,1231281,1231311,1231507,1231685,1416017,1416023,1416033,1732669) 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