Fatal error: Uncaught Exception: Error: Can't create/write to file '/tmp/#sql-temptable-1195ec-7c714b-4eca.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 (1631336,1694723,1809155,1631332,1631372,1631343,1631324,1631354,1631382,1819465,1631317,1631344,1631325,1631349,1631364,1839263,1694727,1631501,1631565,1631322,1767328,1780704,1819471,1571218,1809152,1819463,1819461,1819454,1631623,1527002,1631313,1819467,1631323,1819479,1731352,1631370,1631339,1571222,1549864,1668471,1731347,1631620,1668490,1819495,1819498,1631329,1565659,1549862,1731358,1631367,1631355,1819475,1819483,1631394,1631402,1631362,1819487,1819496,1819497,1571233,1744043,1631315,1819466,1731366,1731360,1631388,1631352,1631366,1631314,1631340,1819499,1819485,1819415,1631390,1732280,1549861,1571219,1571234,1571235,1631338,1631363,1694730,1732279,1732281,1732283,1732284,1819492,1819432,1549863,1819422,1565660,1571220,1631346,1631386,1819473,1819482,1631422,1631577,1549853,1819448,1819452,1549865,1732275,1549851,1819481,1819457,1819484,1631423,1819468,1819494,1780705,1819459,1819489,1809154,1819480,1819493,1799492,1631401,1809151,1819469,1732274,1819491,1732277,1668489,1809150,1549845,1549866,1565662,1565665,1571221,1571223,1571224,1571225,1571226,1571227,1571228,1571229,1571231,1571232,1582282,1631353,1692823,1694725,1732276,1732278,1732282,1743968,1786750,1799493,1809153,1819470,1819474,1819490) ORDER BY FIELD(p.product_id, 1631336,1694723,1809155,1631332,1631372,1631343,1631324,1631354,1631382,1819465,1631317,1631344,1631325,1631349,1631364,1839263,1694727,1631501,1631565,1631322,1767328,1780704,1819471,1571218,1809152,1819463,1819461,1819454,1631623,1527002,1631313,1819467,1631323,1819479,1731352,1631370,1631339,1571222,1549864,1668471,1731347,1631620,1668490,1819495,1819498,1631329,1565659,1549862,1731358,1631367,1631355,1819475,1819483,1631394,1631402,1631362,1819487,1819496,1819497,1571233,1744043,1631315,1819466,1731366,1731360,1631388,1631352,1631366,1631314,1631340,1819499,1819485,1819415,1631390,1732280,1549861,1571219,1571234,1571235,1631338,1631363,1694730,1732279,1732281,1732283,1732284,1819492,1819432,1549863,1819422,1565660,1571220,1631346,1631386,1819473,1819482,1631422,1631577,1549853,1819448,1819452,1549865,1732275,1549851,1819481,1819457,1819484,1631423,1819468,1819494,1780705,1819459,1819489,1809154,1819480,1819493,1799492,1631401,1809151,1819469,1732274,1819491,1732277,1668489,1809150,1549845,1549866,1565662,1565665,1571221,1571223,1571224,1571225,1571226,1571227,1571228,1571229,1571231,1571232,1582282,1631353,1692823,1694725,1732276,1732278,1732282,1743968,1786750,1799493,1809153,1819470,1819474,1819490) 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