Error: Error: Unknown column 'fd.filter_group_id' in 'ON'
Error No: 1054
SELECT f.filter_id id, fd.name filter_name, fg.filter_group_id filter_group_id, fgd.name filter_group_name, COUNT(*) total, f.sort_order sort_order FROM `oc_product` p LEFT JOIN `oc_product_filter` pf ON (p.product_id = pf.product_id) LEFT JOIN `oc_filter` f ON (f.filter_id = pf.filter_id) LEFT JOIN `oc_filter_description` fd ON (fd.filter_id = pf.filter_id) LEFT JOIN `oc_filter_group` fg ON (fg.filter_group_id = fd.filter_group_id) LEFT JOIN `oc_filter_group_description` fgd ON (fd.filter_group_id = fgd.filter_group_id) LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id) LEFT JOIN `oc_product_to_category` p2c ON (p2c.product_id = p.product_id) LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id) LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '1' AND p2c.category_id = '60' AND p.manufacturer_id IN (12) AND fd.language_id = '1' AND fgd.language_id = '1' GROUP BY pf.filter_id HAVING COUNT(*) > 0 ORDER BY fd.name File: /home/compuartstore/public_html/system/library/db/mysqli.php Line: 122 Backtrace: 0 File: /home/compuartstore/public_html/system/library/db.php Line: 54 Class: Opencart\System\Library\DB\MySQLi Function: query Backtrace: 1 File: /home/compuartstore/public_html/catalog/model/journal3/filter.php Line: 705 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /home/compuartstore/public_html/vqmod/vqcache/vq2-system_engine_loader.php Line: 343 Class: ModelJournal3Filter Function: getFilters Backtrace: 3 File: /home/compuartstore/public_html/system/engine/proxy.php Line: 87 Class: Opencart\System\Engine\Loader Function: Opencart\System\Engine\{closure} Backtrace: 4 File: /home/compuartstore/public_html/catalog/controller/journal3/filter.php Line: 402 Class: Opencart\System\Engine\Proxy Function: __call Backtrace: 5 File: /home/compuartstore/public_html/catalog/controller/journal3/filter.php Line: 151 Class: ControllerJournal3Filter Function: beforeRender Backtrace: 6 File: /home/compuartstore/public_html/vqmod/vqcache/vq2-system_engine_loader.php Line: 112 Class: ControllerJournal3Filter Function: index Backtrace: 7 File: /home/compuartstore/public_html/catalog/controller/journal3/grid.php Line: 266 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 8 File: /home/compuartstore/public_html/vqmod/vqcache/vq2-system_engine_loader.php Line: 112 Class: ControllerJournal3Grid Function: grid Backtrace: 9 File: /home/compuartstore/public_html/catalog/controller/journal3/event/layout.php Line: 318 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 10 File: /home/compuartstore/public_html/system/engine/action.php Line: 96 Class: ControllerJournal3EventLayout Function: controller_common_position_before Backtrace: 11 File: /home/compuartstore/public_html/system/engine/event.php Line: 72 Class: Opencart\System\Engine\Action Function: execute Backtrace: 12 File: /home/compuartstore/public_html/vqmod/vqcache/vq2-system_engine_loader.php Line: 110 Class: Opencart\System\Engine\Event Function: trigger Backtrace: 13 File: /home/compuartstore/public_html/catalog/controller/product/category.php Line: 435 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 14 File: /home/compuartstore/public_html/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Product\Category Function: index Backtrace: 15 File: /home/compuartstore/public_html/system/framework.php Line: 259 Class: Opencart\System\Engine\Action Function: execute Backtrace: 16 File: /home/compuartstore/public_html/index.php Line: 24 Function: require_once