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