mysqli::query(): (HY000/1021): Disk full (/tmp/#sql-temptable-739-d92063-f9dc5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
app/Tygh/Backend/Database/Mysqli.php, line: 89
| File: | app/Tygh/Backend/Database/Mysqli.php |
| Line: | 89 |
| Function: | {closure} |
| File: | app/Tygh/Database/Connection.php |
| Line: | 458 |
| Function: | query |
| File: | app/Tygh/Database/Connection.php |
| Line: | 239 |
| Function: | query |
| File: | app/functions/fn.database.php |
| Line: | 42 |
| Function: | getArray |
| File: | app/functions/fn.catalog.php |
| Line: | 7060 |
| Function: | db_get_array |
| File: | app/functions/fn.catalog.php |
| Line: | 7143 |
| Function: | {closure} |
| File: | app/addons/bestsellers/controllers/frontend/products.post.php |
| Line: | 76 |
| Function: | fn_get_products |
| File: | app/functions/fn.control.php |
| Line: | 712 |
| Function: | include |
| File: | app/functions/fn.control.php |
| Line: | 470 |
| Function: | fn_run_controller |
| File: | index.php |
| Line: | 35 |
| Function: | fn_dispatch |
Disk full (/tmp/#sql-temptable-739-d92063-f9dc5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (1021)
SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, IF(shared_prices.product_id IS NOT NULL, MIN(IF (shared_prices.percentage_discount = 0, shared_prices.price, shared_prices.price - (shared_prices.price * shared_prices.percentage_discount) / 100)), MIN(IF (prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount) / 100))) as price FROM ssl_myproducts as products LEFT JOIN ssl_myproduct_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'de' LEFT JOIN ssl_myproduct_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ssl_myproducts_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ssl_mycategories ON ssl_mycategories.category_id = products_categories.category_id AND (ssl_mycategories.usergroup_ids = '' OR FIND_IN_SET(0, ssl_mycategories.usergroup_ids) OR FIND_IN_SET(1, ssl_mycategories.usergroup_ids)) AND ssl_mycategories.status IN ('A', 'H') LEFT JOIN ssl_myult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'de' LEFT JOIN ssl_myult_product_prices as shared_prices ON shared_prices.product_id = products.product_id AND shared_prices.lower_limit = 1 AND shared_prices.usergroup_id IN (0, 0, 1) AND shared_prices.company_id = 1 WHERE 1 AND ssl_mycategories.company_id = 1 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id ORDER BY price asc, product_id ASC LIMIT 400, 80
app/Tygh/Database/Connection.php, line: 1133
| File: | app/Tygh/Database/Connection.php |
| Line: | 499 |
| Function: | throwError |
| File: | app/Tygh/Database/Connection.php |
| Line: | 239 |
| Function: | query |
| File: | app/functions/fn.database.php |
| Line: | 42 |
| Function: | getArray |
| File: | app/functions/fn.catalog.php |
| Line: | 7060 |
| Function: | db_get_array |
| File: | app/functions/fn.catalog.php |
| Line: | 7143 |
| Function: | {closure} |
| File: | app/addons/bestsellers/controllers/frontend/products.post.php |
| Line: | 76 |
| Function: | fn_get_products |
| File: | app/functions/fn.control.php |
| Line: | 712 |
| Function: | include |
| File: | app/functions/fn.control.php |
| Line: | 470 |
| Function: | fn_run_controller |
| File: | index.php |
| Line: | 35 |
| Function: | fn_dispatch |