Error: Error: Unknown column 'a.city_id' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS `total` FROM `sd_article` `a` LEFT JOIN `sd_article_description` `ad` ON (`a`.`article_id` = `ad`.`article_id`) LEFT JOIN `sd_article_to_store` `a2s` ON (`a`.`article_id` = `a2s`.`article_id`) WHERE `ad`.`language_id` = '2' AND `a2s`.`store_id` = '0' AND `a`.`status` = '1' AND `a`.`topic_id` = '10' AND `a`.`city_id` = '0' File: /home/tapplusc/flip67/system/library/db/mysqli.php Line: 122 Backtrace: 0 File: /home/tapplusc/flip67/system/library/db.php Line: 54 Class: Opencart\System\Library\DB\MySQLi Function: query Backtrace: 1 File: /home/tapplusc/flip67/catalog/model/cms/article.php Line: 276 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /home/tapplusc/flip67/system/engine/loader.php Line: 343 Class: Opencart\Catalog\Model\Cms\Article Function: getTotalArticles Backtrace: 3 File: /home/tapplusc/flip67/system/engine/proxy.php Line: 87 Class: Opencart\System\Engine\Loader Function: Opencart\System\Engine\{closure} Backtrace: 4 File: /home/tapplusc/flip67/catalog/controller/cms/blog.php Line: 305 Class: Opencart\System\Engine\Proxy Function: __call Backtrace: 5 File: /home/tapplusc/flip67/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Cms\Blog Function: index Backtrace: 6 File: /home/tapplusc/flip67/system/framework.php Line: 262 Class: Opencart\System\Engine\Action Function: execute Backtrace: 7 File: /home/tapplusc/flip67/index.php Line: 20 Function: require_once