Database error: Unknown column 'active_count.product_count' in 'field list' (1054)
Invalid query: SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.product_count,ifnull(active_count.product_count,0) as active_product_count FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'EN' WHERE 1 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A') AND cscart_categories.parent_id IN (165) AND cscart_categories.id_path LIKE '165/%' ORDER BY cscart_categories.position asc, cscart_category_descriptions.category asc


Backtrace:
File:/home/pepe2712/public_html/core/fn.database.php
Line:259
Function:db_error
File:/home/pepe2712/public_html/core/fn.database.php
Line:54
Function:db_query
File:/home/pepe2712/public_html/core/fn.catalog.php
Line:828
Function:db_get_hash_array
File:/home/pepe2712/public_html/core/fn.catalog.php
Line:630
Function:fn_get_categories
File:/home/pepe2712/public_html/controllers/customer/categories.php
Line:52
Function:fn_get_subcategories
File:/home/pepe2712/public_html/core/fn.control.php
Line:578
Function:include
File:/home/pepe2712/public_html/core/fn.control.php
Line:432
Function:fn_run_controller
File:/home/pepe2712/public_html/index.php
Line:28
Function:fn_dispatch