Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-829945-d44d.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 (1940361,1947205,1948821,1942553,1927109,1947204,1948822,1942713,1940741,1948823,1940734,1942558,1927110,1927145,1927146,1940735,1940728,1940730,1940733,1940355,1404532,1942507,1940431,1942725,1942761,1940726,1940727,1940739,1940740,1940363,1939940,1939942,1940038,1940729,1940245,1940263,1940404,1940406,1940408,1940418,1940719,1940429,1940434,1939936,1388568,1940357,1941112,1942724,1942762,1948825,1942743,1940298,1940410,1940365,1940367,1940369,1939932,1942555,1940304,1940306,1940308,1940335,1940420,1940359,1940268,1939928,1940481,1940485,1942520,1940717,1940718,1942554,1334310,1940723,1940724,1940174,1940353,1940284,1940414,1942737,1940135,1940138,1940141,1940144,1940213,1940219,1940222,1168765,1941465,1941466,1941476,1910457,1910462,1940162,1940165,1940168,1940171,1864989,1940428,1865000,1910512,1940433,1941478,1939922,1940039,1940041,1941467,1941474,1940083,1942272,1864964,1886817,1940046,1941464,1942730,1942739,1939972,1939973,1941410,1940017,1940021,1940029,1940081,1899302,1207631,1940286,1886822,1941434,1864990,1941438,1941472,1939962,1942745,1940150,1940266,1940280,1864973,1413590,1940274,1940277,1940720,1940721,1942249,1942274,1942296,1942330,1942333,1942338,1941471,1940023,1332096,1833959,1864883,1939968,1940722,1940180,1940183,1940186,1940189,1940192,1940195,1940198,1940201,1940204,1940207,1940210,1940153,1886896,1940147,1833840,1833853,1941435,1940156,1941468,1886826,1941111,1899306,1910460,1252205,1833831,1830971,1833843,1833981,1864882,1910463,1910464,1917696,1917704,1927073,1927132,1939908,1939984,1939994,1940030,1940055,1940059,1940060,1940069,1940071,1940072,1940073,1940077,1940080,1940725,1941406) ORDER BY FIELD(p.product_id, 1940361,1947205,1948821,1942553,1927109,1947204,1948822,1942713,1940741,1948823,1940734,1942558,1927110,1927145,1927146,1940735,1940728,1940730,1940733,1940355,1404532,1942507,1940431,1942725,1942761,1940726,1940727,1940739,1940740,1940363,1939940,1939942,1940038,1940729,1940245,1940263,1940404,1940406,1940408,1940418,1940719,1940429,1940434,1939936,1388568,1940357,1941112,1942724,1942762,1948825,1942743,1940298,1940410,1940365,1940367,1940369,1939932,1942555,1940304,1940306,1940308,1940335,1940420,1940359,1940268,1939928,1940481,1940485,1942520,1940717,1940718,1942554,1334310,1940723,1940724,1940174,1940353,1940284,1940414,1942737,1940135,1940138,1940141,1940144,1940213,1940219,1940222,1168765,1941465,1941466,1941476,1910457,1910462,1940162,1940165,1940168,1940171,1864989,1940428,1865000,1910512,1940433,1941478,1939922,1940039,1940041,1941467,1941474,1940083,1942272,1864964,1886817,1940046,1941464,1942730,1942739,1939972,1939973,1941410,1940017,1940021,1940029,1940081,1899302,1207631,1940286,1886822,1941434,1864990,1941438,1941472,1939962,1942745,1940150,1940266,1940280,1864973,1413590,1940274,1940277,1940720,1940721,1942249,1942274,1942296,1942330,1942333,1942338,1941471,1940023,1332096,1833959,1864883,1939968,1940722,1940180,1940183,1940186,1940189,1940192,1940195,1940198,1940201,1940204,1940207,1940210,1940153,1886896,1940147,1833840,1833853,1941435,1940156,1941468,1886826,1941111,1899306,1910460,1252205,1833831,1830971,1833843,1833981,1864882,1910463,1910464,1917696,1917704,1927073,1927132,1939908,1939984,1939994,1940030,1940055,1940059,1940060,1940069,1940071,1940072,1940073,1940077,1940080,1940725,1941406) 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