Tygh\Exceptions\AException

Message

Table 'safqa_net.cscart_discussion_rating' doesn't exist (1146)

SELECT company_descriptions.*, companies.*, 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(companies.company_id, '_', IF ( cscart_discussion_rating.thread_id, cscart_discussion_rating.thread_id, '0')) AS company_thread_ids FROM cscart_companies AS companies LEFT JOIN cscart_company_descriptions AS company_descriptions ON company_descriptions.company_id = companies.company_id AND company_descriptions.lang_code = 'ar' LEFT JOIN cscart_vendor_plan_descriptions ON companies.plan_id = cscart_vendor_plan_descriptions.plan_id AND cscart_vendor_plan_descriptions.lang_code = 'ar' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 1 AND cscart_seo_names.type = 'm' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ar' LEFT JOIN cscart_discussion ON cscart_discussion.object_id = 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 companies.company_id = 1

Error at

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

Backtrace

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:414
Function:query
File:app/functions/fn.database.php
Line:60
Function:getRow
File:app/functions/fn.companies.php
Line:621
Function:db_get_row
File:app/controllers/frontend/companies.php
Line:315
Function:fn_get_company_data
File:app/functions/fn.control.php
Line:728
Function:include
File:app/functions/fn.control.php
Line:459
Function:fn_run_controller
File:index.php
Line:19
Function:fn_dispatch