Error: Error: Unknown column 'p.variant_color' in 'SELECT'
Error No: 1054
SELECT `p`.`product_id`, `p`.`variant_color`, `pd`.`name` FROM `cm_product` `p` LEFT JOIN `cm_product_description` `pd` ON (`p`.`product_id` = `pd`.`product_id` AND `pd`.`language_id` = '2') LEFT JOIN `cm_product_to_store` `p2s` ON (`p2s`.`product_id` = `p`.`product_id`) WHERE (`p`.`product_id` = '7019431' OR `p`.`master_id` = '7019431') AND `p2s`.`store_id` = '0' AND `p`.`status` = '1' AND `p`.`date_available` <= NOW() ORDER BY `p`.`variant_color` ASC File: /home/partz/public_html/cm/system/library/db/mysqli.php Line: 122 Backtrace: 0 File: /home/partz/public_html/cm/system/library/db.php Line: 54 Class: Opencart\System\Library\DB\MySQLi Function: query Backtrace: 1 File: /home/partz/public_html/catalog/model/catalog/product.php Line: 128 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /home/partz/public_html/cm/system/engine/loader.php Line: 346 Class: Opencart\Catalog\Model\Catalog\Product Function: getColorVariants Backtrace: 3 File: /home/partz/public_html/cm/system/engine/proxy.php Line: 87 Class: Opencart\System\Engine\Loader Function: Opencart\System\Engine\{closure} Backtrace: 4 File: /home/partz/public_html/catalog/controller/product/product.php Line: 620 Class: Opencart\System\Engine\Proxy Function: __call Backtrace: 5 File: /home/partz/public_html/cm/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Product\Product Function: index Backtrace: 6 File: /home/partz/public_html/cm/system/framework.php Line: 259 Class: Opencart\System\Engine\Action Function: execute Backtrace: 7 File: /home/partz/public_html/cm/index.php Line: 21 Function: require_once