Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-7aaa94-373d.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 = '9') WHERE p.product_id in (1250064,1250063,1702255,1702194,1249995,1250109,1249986,1250106,1250110,1702287,1250100,1250083,1250001,1250105,1702308,1250017,1250099,1250107,1449790,1250005,1249999,1250015,1250009,1250087,1250089,1249998,1250013,1250000,1249984,1249987,1249989,1249996,1250003,1250051,1250052,1250053,1250057,1250059,1250061,1250075,1250077,1250078,1250079,1250090,1250027,1250035,1250073,1702193,1702195,1702196,1702234,1250004,1250010,1250040,1250042,1250069,1702192,1250050,1250054,1250074,1250084,1250086,1250091,1250104,1250065,1250071,1250085,1250092,1250098,1249992,1702189,1702198,1702199,1702222,1702307,1250093,1250111,1250058,1250097,1250088,1250007,1250044,1250012,1250056,1250080,1250108,1250076,1250041,1249985,1249988,1250055,1250060,1250067,1250072,1250081,1250008,1449800,1449819,1702203,1702204,1702206,1702215,1702221,1702231,1702244,1702279,1249993,1249994,1250002,1250112,1249983,1250014,1250034,1250068,1250096,1250019,1250038,1250021,1250047,1449772,1249991,1249997,1250024,1250026,1250030,1250032,1250033,1250082,1250036,1250039,1250028,1250031,1249990,1702217,1702226,1702282,1702292,1702296,1250101,1250102,1250020,1250045,1250046,1702214,1702290,1250066,1702184,1702207,1702208,1702219,1702233,1702240,1702242,1702250,1702269,1702297,1702300,1702305,1250049,1250006,1250029,1250018,1250037,1702211,1702286,1702299,1702302,1250043,1250022,1250048,1250070,1702185,1702186,1702191,1702216,1702220,1702241,1702265,1702291,1702295,1449823,1702188,1702190,1702251,1702270,1702276,1702187,1702197,1702237,1702249,1702277,1250025,1320343,1702202,1702209,1702248,1702262,1702294,1702205,1702225,1250023,1702288) ORDER BY FIELD(p.product_id, 1250064,1250063,1702255,1702194,1249995,1250109,1249986,1250106,1250110,1702287,1250100,1250083,1250001,1250105,1702308,1250017,1250099,1250107,1449790,1250005,1249999,1250015,1250009,1250087,1250089,1249998,1250013,1250000,1249984,1249987,1249989,1249996,1250003,1250051,1250052,1250053,1250057,1250059,1250061,1250075,1250077,1250078,1250079,1250090,1250027,1250035,1250073,1702193,1702195,1702196,1702234,1250004,1250010,1250040,1250042,1250069,1702192,1250050,1250054,1250074,1250084,1250086,1250091,1250104,1250065,1250071,1250085,1250092,1250098,1249992,1702189,1702198,1702199,1702222,1702307,1250093,1250111,1250058,1250097,1250088,1250007,1250044,1250012,1250056,1250080,1250108,1250076,1250041,1249985,1249988,1250055,1250060,1250067,1250072,1250081,1250008,1449800,1449819,1702203,1702204,1702206,1702215,1702221,1702231,1702244,1702279,1249993,1249994,1250002,1250112,1249983,1250014,1250034,1250068,1250096,1250019,1250038,1250021,1250047,1449772,1249991,1249997,1250024,1250026,1250030,1250032,1250033,1250082,1250036,1250039,1250028,1250031,1249990,1702217,1702226,1702282,1702292,1702296,1250101,1250102,1250020,1250045,1250046,1702214,1702290,1250066,1702184,1702207,1702208,1702219,1702233,1702240,1702242,1702250,1702269,1702297,1702300,1702305,1250049,1250006,1250029,1250018,1250037,1702211,1702286,1702299,1702302,1250043,1250022,1250048,1250070,1702185,1702186,1702191,1702216,1702220,1702241,1702265,1702291,1702295,1449823,1702188,1702190,1702251,1702270,1702276,1702187,1702197,1702237,1702249,1702277,1250025,1320343,1702202,1702209,1702248,1702262,1702294,1702205,1702225,1250023,1702288) ASC, LCASE(pd.name) ASC, p.product_id ASC LIMIT 40,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