Warning: pg_query(): Query failed: ERROR: syntax error at or near "." LINE 1: SELECT DISTINCT *, `pd`.`name`, `p`.`image`, (SELECT (CASE W... ^ in /var/www/vhosts/carsibu.com/public_html/system/library/db/pgsql.php on line 61Error: Error: ERROR: syntax error at or near "." LINE 1: SELECT DISTINCT *, `pd`.`name`, `p`.`image`, (SELECT (CASE W... ^
SELECT DISTINCT *, `pd`.`name`, `p`.`image`, (SELECT (CASE WHEN pd2.type = 'P' THEN (p.price - (p.price * (pd2.price / 100))) WHEN pd2.type = 'S' THEN (p.price - pd2.price) ELSE pd2.price END) FROM cbp.product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND pd2.special = '0' AND ((pd2.date_start = '1970-01-01' OR pd2.date_start <= NOW()) AND (pd2.date_end = '1970-01-01' OR pd2.date_end >= NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT (CASE WHEN ps.type = 'P' THEN (p.price - (p.price * (ps.price / 100))) WHEN ps.type = 'S' THEN (p.price - ps.price) ELSE ps.price END) FROM cbp.product_discount ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ps.quantity = '1' AND ps.special = '1' AND ((ps.date_start = '1970-01-01' OR ps.date_start <= NOW()) AND (ps.date_end = '1970-01-01' OR ps.date_end >= NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT pr.points FROM cbp.product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT COUNT(*) FROM cbp.review r WHERE r.product_id = p.product_id AND r.status = '1' GROUP BY r.product_id) AS reviews FROM `cbp.product_to_store` `p2s` LEFT JOIN `cbp.product` `p` ON (`p`.`product_id` = `p2s`.`product_id` AND `p`.`status` = '1' AND `p`.`date_available` <= NOW()) LEFT JOIN `cbp.product_description` `pd` ON (`p`.`product_id` = `pd`.`product_id`) WHERE `p2s`.`store_id` = '0' AND `p2s`.`product_id` = '43' AND `pd`.`language_id` = '0' File: /var/www/vhosts/carsibu.com/public_html/system/library/db/pgsql.php Line: 64 Backtrace: 0 File: /var/www/vhosts/carsibu.com/public_html/system/library/db.php Line: 61 Class: Opencart\System\Library\DB\PgSQL Function: query Backtrace: 1 File: /var/www/vhosts/carsibu.com/public_html/frontend/model/catalog/product.php Line: 74 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /var/www/vhosts/carsibu.com/public_html/system/engine/loader.php Line: 343 Class: Opencart\Catalog\Model\Catalog\Product Function: getProduct Backtrace: 3 File: /var/www/vhosts/carsibu.com/public_html/system/engine/proxy.php Line: 87 Class: Opencart\System\Engine\Loader Function: {closure:Opencart\System\Engine\Loader::callback():312} Backtrace: 4 File: /var/www/vhosts/carsibu.com/public_html/extension/opencart/catalog/controller/module/featured.php Line: 33 Class: Opencart\System\Engine\Proxy Function: __call Backtrace: 5 File: /var/www/vhosts/carsibu.com/public_html/system/engine/loader.php Line: 112 Class: Opencart\Catalog\Controller\Extension\Opencart\Module\Featured Function: index Backtrace: 6 File: /var/www/vhosts/carsibu.com/public_html/frontend/controller/common/content_top.php Line: 101 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 7 File: /var/www/vhosts/carsibu.com/public_html/system/engine/loader.php Line: 112 Class: Opencart\Catalog\Controller\Common\ContentTop Function: index Backtrace: 8 File: /var/www/vhosts/carsibu.com/public_html/frontend/controller/common/home.php Line: 28 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 9 File: /var/www/vhosts/carsibu.com/public_html/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Common\Home Function: index Backtrace: 10 File: /var/www/vhosts/carsibu.com/public_html/system/framework.php Line: 259 Class: Opencart\System\Engine\Action Function: execute Backtrace: 11 File: /var/www/vhosts/carsibu.com/public_html/index.php Line: 19 Function: require_once