Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-811b60-1891c.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 (1642213,1642167,1642332,1694739,1642185,1642148,1642163,1809167,1642174,1642155,1819550,1642175,1642156,1642180,1642203,1694735,1642195,1839285,1642396,1642153,1767649,1780768,1819556,1819548,1571236,1809160,1819546,1819539,1642144,1819552,1642154,1642454,1527060,1819564,1731385,1642201,1642170,1571240,1549887,1668496,1642451,1731380,1819583,1668516,1819580,1642160,1565677,1731391,1642198,1642186,1549885,1819560,1819568,1642225,1642233,1642193,1819572,1819581,1819582,1744188,1571249,1819551,1731399,1642146,1731393,1642183,1642197,1642145,1642171,1819584,1819570,1642219,1819500,1642221,1819517,1549884,1549886,1571237,1571250,1571251,1642169,1642194,1694742,1732290,1732292,1732294,1732295,1819577,1732291,1819507,1642177,1642217,1819558,1565678,1571238,1819567,1642253,1642408,1819533,1819537,1549876,1549888,1819566,1732286,1819542,1549874,1819569,1642254,1819553,1819579,1780769,1819544,1819574,1819565,1819578,1642232,1809165,1819554,1799496,1809157,1732285,1819576,1732288,1668515,1549868,1549889,1565680,1565683,1571239,1571241,1571242,1571243,1571244,1571245,1571247,1571248,1582306,1642184,1692826,1694737,1732287,1732289,1732293,1744113,1799497,1809156,1809158,1809163,1809164,1819555,1819559,1819575) ORDER BY FIELD(p.product_id, 1642213,1642167,1642332,1694739,1642185,1642148,1642163,1809167,1642174,1642155,1819550,1642175,1642156,1642180,1642203,1694735,1642195,1839285,1642396,1642153,1767649,1780768,1819556,1819548,1571236,1809160,1819546,1819539,1642144,1819552,1642154,1642454,1527060,1819564,1731385,1642201,1642170,1571240,1549887,1668496,1642451,1731380,1819583,1668516,1819580,1642160,1565677,1731391,1642198,1642186,1549885,1819560,1819568,1642225,1642233,1642193,1819572,1819581,1819582,1744188,1571249,1819551,1731399,1642146,1731393,1642183,1642197,1642145,1642171,1819584,1819570,1642219,1819500,1642221,1819517,1549884,1549886,1571237,1571250,1571251,1642169,1642194,1694742,1732290,1732292,1732294,1732295,1819577,1732291,1819507,1642177,1642217,1819558,1565678,1571238,1819567,1642253,1642408,1819533,1819537,1549876,1549888,1819566,1732286,1819542,1549874,1819569,1642254,1819553,1819579,1780769,1819544,1819574,1819565,1819578,1642232,1809165,1819554,1799496,1809157,1732285,1819576,1732288,1668515,1549868,1549889,1565680,1565683,1571239,1571241,1571242,1571243,1571244,1571245,1571247,1571248,1582306,1642184,1692826,1694737,1732287,1732289,1732293,1744113,1799497,1809156,1809158,1809163,1809164,1819555,1819559,1819575) 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