Can't create/write to file '/tmp/#sql-temptable-31c-8718e3-13ee3e.MAI' (Errcode: 28 "No space left on device") (1)
SELECT cscart_companies.company_id, cscart_companies.lang_code, cscart_companies.email, cscart_companies.company, cscart_companies.timestamp, cscart_companies.status, cscart_companies.tax_number, cscart_company_descriptions.company_description, cscart_vendor_plan_descriptions.plan, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path, AVG(cscart_discussion_rating.rating_value) AS average_rating, CONCAT(cscart_companies.company_id, '_', IF (cscart_discussion_rating.thread_id, cscart_discussion_rating.thread_id, '0')) AS company_thread_ids FROM cscart_companies LEFT JOIN cscart_company_descriptions ON cscart_company_descriptions.company_id = cscart_companies.company_id AND cscart_company_descriptions.lang_code = 'en' LEFT JOIN cscart_vendor_plan_descriptions ON cscart_companies.plan_id = cscart_vendor_plan_descriptions.plan_id AND cscart_vendor_plan_descriptions.lang_code = 'en' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_companies.company_id AND cscart_seo_names.type = 'm' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' LEFT JOIN cscart_discussion ON cscart_discussion.object_id = cscart_companies.company_id AND cscart_discussion.object_type = 'M' LEFT JOIN cscart_discussion_posts ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id AND cscart_discussion_posts.status = 'A' LEFT JOIN cscart_discussion_rating ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id WHERE 1 AND cscart_companies.status = 'A' GROUP BY company_thread_ids ORDER BY cscart_companies.company asc LIMIT 120, 10
app/Tygh/Database/Connection.php, line: 1713
| File: | app/Tygh/Database/Connection.php |
| Line: | 1490 |
| Function: | throwError |
| File: | app/Tygh/Database/Connection.php |
| Line: | 700 |
| Function: | execQuery |
| File: | app/Tygh/Database/Connection.php |
| Line: | 333 |
| Function: | query |
| File: | app/functions/fn.database.php |
| Line: | 35 |
| Function: | getArray |
| File: | app/functions/fn.companies.php |
| Line: | 341 |
| Function: | db_get_array |
| File: | app/controllers/frontend/companies.php |
| Line: | 253 |
| Function: | fn_get_companies |
| File: | app/functions/fn.control.php |
| Line: | 722 |
| Function: | include |
| File: | app/functions/fn.control.php |
| Line: | 458 |
| Function: | fn_run_controller |
| File: | index.php |
| Line: | 27 |
| Function: | fn_dispatch |