Error: Error: Unknown column 'p.sku' in 'WHERE'
Error No: 1054
SELECT COUNT(DISTINCT `p`.`product_id`) AS `total` FROM `oc_product_to_store` `p2s` LEFT JOIN `oc_product` `p` ON (`p`.`product_id` = `p2s`.`product_id` AND `p`.`status` = '1' AND `p2s`.`store_id` = '0' AND `p`.`date_available` <= NOW()) LEFT JOIN `oc_product_description` `pd` ON (`p`.`product_id` = `pd`.`product_id`) WHERE `pd`.`language_id` = '1' AND ( (`pd`.`name` LIKE '%bg%') OR `pd`.`description` LIKE '%bg%' OR (`pd`.`tag` LIKE '%bg%') OR LCASE(`p`.`model`) = 'bg' OR LCASE(`p`.`sku`) = 'bg' OR LCASE(`p`.`upc`) = 'bg' OR LCASE(`p`.`ean`) = 'bg' OR LCASE(`p`.`jan`) = 'bg' OR LCASE(`p`.`isbn`) = 'bg' OR LCASE(`p`.`mpn`) = 'bg')
File: /home/cmstory1/octest41.cmstory.com/system/library/db/mysqli.php
Line: 122
Backtrace: 0
File: /home/cmstory1/octest41.cmstory.com/system/library/db.php
Line: 54
Class: Opencart\System\Library\DB\MySQLi
Function: query
Backtrace: 1
File: /home/cmstory1/octest41.cmstory.com/catalog/model/catalog/product.php
Line: 376
Class: Opencart\System\Library\DB
Function: query
Backtrace: 2
File: /home/cmstory1/octest41.cmstory.com/vqmod/vqcache/vq2-system_engine_loader.php
Line: 343
Class: Opencart\Catalog\Model\Catalog\Product
Function: getTotalProducts
Backtrace: 3
File: /home/cmstory1/octest41.cmstory.com/system/engine/proxy.php
Line: 87
Class: Opencart\System\Engine\Loader
Function: Opencart\System\Engine\{closure}
Backtrace: 4
File: /home/cmstory1/octest41.cmstory.com/catalog/controller/product/search.php
Line: 393
Class: Opencart\System\Engine\Proxy
Function: __call
Backtrace: 5
File: /home/cmstory1/octest41.cmstory.com/system/engine/action.php
Line: 96
Class: Opencart\Catalog\Controller\Product\Search
Function: index
Backtrace: 6
File: /home/cmstory1/octest41.cmstory.com/system/framework.php
Line: 259
Class: Opencart\System\Engine\Action
Function: execute
Backtrace: 7
File: /home/cmstory1/octest41.cmstory.com/index.php
Line: 24
Function: require_once