Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-7b2a91-11749.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 (1408526,1576277,1408459,1576266,1576267,1576253,1576257,1576273,1408454,1576264,1408451,1408490,1472087,1472094,1408450,1576270,1576259,1576279,1408455,1576250,1576256,1576258,1576263,1576268,1576269,1576276,1576286,1576287,1472093,1481467,1481471,1576260,1576285,1481465,1408528,1408453,1472089,1472091,1408509,1408464,1408492,1576274,1408508,1408462,1408465,1408468,1408476,1472090,1472092,1472099,1408510,1408525,1408527,1576288,1408512,1408513,1408511,1481468,1576251,1576261,1576278,1576280,1576281,1576282,1408470,1408471,1408473,1408479,1408481,1408483,1408485,1408487,1408491,1408493,1481462,1576262,1576271,1576275,1576284,1408467,1408469,1408474,1408475,1408477,1408480,1408482,1408484,1408486,1408488,1408489,1472108,1472085,1408445,1481464,1868115,1811457,1408456,1408460,1408461,1408463,1408466,1408531,1472100,1472115,1481466,1481479,1576254,1576272,1868108,1931294) ORDER BY FIELD(p.product_id, 1408526,1576277,1408459,1576266,1576267,1576253,1576257,1576273,1408454,1576264,1408451,1408490,1472087,1472094,1408450,1576270,1576259,1576279,1408455,1576250,1576256,1576258,1576263,1576268,1576269,1576276,1576286,1576287,1472093,1481467,1481471,1576260,1576285,1481465,1408528,1408453,1472089,1472091,1408509,1408464,1408492,1576274,1408508,1408462,1408465,1408468,1408476,1472090,1472092,1472099,1408510,1408525,1408527,1576288,1408512,1408513,1408511,1481468,1576251,1576261,1576278,1576280,1576281,1576282,1408470,1408471,1408473,1408479,1408481,1408483,1408485,1408487,1408491,1408493,1481462,1576262,1576271,1576275,1576284,1408467,1408469,1408474,1408475,1408477,1408480,1408482,1408484,1408486,1408488,1408489,1472108,1472085,1408445,1481464,1868115,1811457,1408456,1408460,1408461,1408463,1408466,1408531,1472100,1472115,1481466,1481479,1576254,1576272,1868108,1931294) 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