Tygh\Exceptions\AException

Message

Disk full (/tmp/#sql_1436_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (1021)

SELECT cscart_companies.company_id, cscart_companies.lang_code, cscart_companies.email, cscart_companies.company, cscart_companies.timestamp, cscart_companies.status, cscart_company_descriptions.company_description, absolute_rating.rating AS absolute_vendor_rating, 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, cscart_companies.suspend_date, cscart_companies.last_time_suspended 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_absolute_rating AS absolute_rating ON absolute_rating.object_id = cscart_companies.company_id AND absolute_rating.object_type = 'company' 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' AND cscart_companies.company_id IN (5, 7, 8, 10, 12, 13, 14) GROUP BY company_thread_ids ORDER BY cscart_companies.company asc LIMIT 0, 10

Error at

app/Tygh/Database/Connection.php, line: 1155

Backtrace

File:app/Tygh/Database/Connection.php
Line:518
Function:throwError
File:app/Tygh/Database/Connection.php
Line:226
Function:query
File:app/functions/fn.database.php
Line:31
Function:getArray
File:app/functions/fn.companies.php
Line:335
Function:db_get_array
File:app/controllers/frontend/companies.php
Line:211
Function:fn_get_companies
File:app/functions/fn.control.php
Line:685
Function:include
File:app/functions/fn.control.php
Line:434
Function:fn_run_controller
File:index.php
Line:25
Function:fn_dispatch