Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-7c9b7b-69f7.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 (1948281,1948279,1507972,1948627,1947894,1947786,1948626,1948237,1948282,1948424,1947789,1947956,1947969,1947790,1947851,1947852,1948618,1947782,1947783,1947788,1947791,1947794,1947795,1947802,1947809,1947814,1947816,1947832,1947845,1947850,1947863,1947864,1947886,1947888,1947900,1947910,1947914,1947927,1947928,1947933,1947934,1947942,1947965,1947966,1947968,1947975,1947983,1947984,1947990,1947991,1947993,1947995,1947997,1947998,1947999,1948000,1948002,1948004,1948005,1948006,1948009,1948013,1948014,1948015,1948016,1948017,1948018,1948019,1948020,1948022,1948023,1948024,1948025,1948027,1948028,1948029,1948030,1948031,1948032,1948033,1948034,1948035,1948044,1948050,1948052,1948054,1948055,1948061,1948080,1948082,1948085,1948093,1948094,1948096,1948098,1948099,1948100,1948102,1948103,1948104,1948106,1948107,1948109,1948112,1948113,1948120,1948132,1948133,1948140,1948145,1948147,1948178,1948181,1948185,1948186,1948251,1948253,1948254,1948256,1948258,1948259,1948260,1948261,1948262,1948263,1948264,1948265,1948266,1948272,1948274,1948276,1948280,1948283,1948284,1948287,1948288,1948289,1948319,1948366,1948367,1948371,1948378,1948379,1948380,1948381,1948382,1948383,1948384,1948386,1948389,1948421,1948432,1948433,1948436,1948437,1948446,1948454,1948470,1948506,1948521,1948522,1948533,1948534,1948535,1948536,1948568,1948569,1948570,1948571,1948572,1948573,1948574,1948576,1948577,1948578,1948579,1948581,1948582,1948583,1948591,1948596,1948598,1948601,1948605,1948617,1948619,1948623,1948625,1948633,1948644,1948649,1948655,1948656,1947818,1947831,1947837,1947840,1947841,1947855,1947873,1947879,1947882,1947891,1947898,1947899,1947902,1947903,1947907,1947908,1947909,1947911,1947918,1947920,1947921,1947925,1947930,1947931,1947941,1947944,1947945,1947946,1947947,1947949,1947952,1947955,1947960,1947961,1947967,1947970,1947971,1947974,1947978,1947979,1947982,1947985,1948021,1948065,1948067,1948158,1948161,1948165,1948177,1948180,1948248,1948291,1948292,1948296,1948297,1948300,1948301) ORDER BY FIELD(p.product_id, 1948281,1948279,1507972,1948627,1947894,1947786,1948626,1948237,1948282,1948424,1947789,1947956,1947969,1947790,1947851,1947852,1948618,1947782,1947783,1947788,1947791,1947794,1947795,1947802,1947809,1947814,1947816,1947832,1947845,1947850,1947863,1947864,1947886,1947888,1947900,1947910,1947914,1947927,1947928,1947933,1947934,1947942,1947965,1947966,1947968,1947975,1947983,1947984,1947990,1947991,1947993,1947995,1947997,1947998,1947999,1948000,1948002,1948004,1948005,1948006,1948009,1948013,1948014,1948015,1948016,1948017,1948018,1948019,1948020,1948022,1948023,1948024,1948025,1948027,1948028,1948029,1948030,1948031,1948032,1948033,1948034,1948035,1948044,1948050,1948052,1948054,1948055,1948061,1948080,1948082,1948085,1948093,1948094,1948096,1948098,1948099,1948100,1948102,1948103,1948104,1948106,1948107,1948109,1948112,1948113,1948120,1948132,1948133,1948140,1948145,1948147,1948178,1948181,1948185,1948186,1948251,1948253,1948254,1948256,1948258,1948259,1948260,1948261,1948262,1948263,1948264,1948265,1948266,1948272,1948274,1948276,1948280,1948283,1948284,1948287,1948288,1948289,1948319,1948366,1948367,1948371,1948378,1948379,1948380,1948381,1948382,1948383,1948384,1948386,1948389,1948421,1948432,1948433,1948436,1948437,1948446,1948454,1948470,1948506,1948521,1948522,1948533,1948534,1948535,1948536,1948568,1948569,1948570,1948571,1948572,1948573,1948574,1948576,1948577,1948578,1948579,1948581,1948582,1948583,1948591,1948596,1948598,1948601,1948605,1948617,1948619,1948623,1948625,1948633,1948644,1948649,1948655,1948656,1947818,1947831,1947837,1947840,1947841,1947855,1947873,1947879,1947882,1947891,1947898,1947899,1947902,1947903,1947907,1947908,1947909,1947911,1947918,1947920,1947921,1947925,1947930,1947931,1947941,1947944,1947945,1947946,1947947,1947949,1947952,1947955,1947960,1947961,1947967,1947970,1947971,1947974,1947978,1947979,1947982,1947985,1948021,1948065,1948067,1948158,1948161,1948165,1948177,1948180,1948248,1948291,1948292,1948296,1948297,1948300,1948301) 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