Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-8012ad-bbc8.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 (1621752,1621722,1743211,1621797,1621716,1621727,1621718,1743213,1621775,1765401,1743207,1824824,1621719,1621774,1621725,1621717,1621735,1621744,1621773,1694641,1484610,1484653,1621742,1621721,1621737,1884382,1731154,1621770,1743215,1414438,1915011,1414822,1471311,1621739,1743325,1824789,1747785,1743236,1414817,1622953,1414469,1621732,1623032,1743310,1824808,1622964,1824787,1824795,1743204,1824810,1621724,1621747,1621714,1621740,1743268,1414437,1824809,1818905,1743219,1621805,1743287,1743242,1621799,1622037,1743306,1849171,1914985,1621720,1621865,1621755,1743220,1743250,1849192,1915009,1685254,1824797,1913666,1621767,1731160,1743276,1743322,1622051,1824796,1824804,1824822,1747792,1822521,1743290,1743295,1621729,1915007,1582160,1743274,1623104,1622036,1743245,1621901,1824807,1621726,1526621,1526622,1549681,1549682,1549685,1549695,1582141,1621738,1621750,1621763,1621788,1622023,1694652,1732213,1732214,1743235,1747786,1747788,1747789,1747791,1747793,1747795,1747800,1818982,1818985,1824813,1824819,1913663,1913664,1913665,1668310,1688162,1824803,1743284,1824775,1824798,1621891,1582146,1621801,1743297,1747797,1668311,1824801,1694654,1484583,1747784,1758713,1743320,1822524,1484651,1484652,1621715,1822522,1484635,1484637,1484649,1484650,1526604,1526605,1549684,1565535,1582137,1582138,1582139,1582140,1582148,1582149,1582150,1582151,1582152,1582153,1582154,1582155,1582157,1582158,1582159,1621745,1622696,1623060,1668308,1685247,1694644,1694653,1743212,1743246,1743260,1743309,1743311,1747787,1747790,1747794,1747796,1747798,1747799,1758714,1818960,1822518,1822520,1822523,1822525,1822526,1824816,1824821) ORDER BY FIELD(p.product_id, 1621752,1621722,1743211,1621797,1621716,1621727,1621718,1743213,1621775,1765401,1743207,1824824,1621719,1621774,1621725,1621717,1621735,1621744,1621773,1694641,1484610,1484653,1621742,1621721,1621737,1884382,1731154,1621770,1743215,1414438,1915011,1414822,1471311,1621739,1743325,1824789,1747785,1743236,1414817,1622953,1414469,1621732,1623032,1743310,1824808,1622964,1824787,1824795,1743204,1824810,1621724,1621747,1621714,1621740,1743268,1414437,1824809,1818905,1743219,1621805,1743287,1743242,1621799,1622037,1743306,1849171,1914985,1621720,1621865,1621755,1743220,1743250,1849192,1915009,1685254,1824797,1913666,1621767,1731160,1743276,1743322,1622051,1824796,1824804,1824822,1747792,1822521,1743290,1743295,1621729,1915007,1582160,1743274,1623104,1622036,1743245,1621901,1824807,1621726,1526621,1526622,1549681,1549682,1549685,1549695,1582141,1621738,1621750,1621763,1621788,1622023,1694652,1732213,1732214,1743235,1747786,1747788,1747789,1747791,1747793,1747795,1747800,1818982,1818985,1824813,1824819,1913663,1913664,1913665,1668310,1688162,1824803,1743284,1824775,1824798,1621891,1582146,1621801,1743297,1747797,1668311,1824801,1694654,1484583,1747784,1758713,1743320,1822524,1484651,1484652,1621715,1822522,1484635,1484637,1484649,1484650,1526604,1526605,1549684,1565535,1582137,1582138,1582139,1582140,1582148,1582149,1582150,1582151,1582152,1582153,1582154,1582155,1582157,1582158,1582159,1621745,1622696,1623060,1668308,1685247,1694644,1694653,1743212,1743246,1743260,1743309,1743311,1747787,1747790,1747794,1747796,1747798,1747799,1758714,1818960,1822518,1822520,1822523,1822525,1822526,1824816,1824821) 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