Error when I chose Sort By Price in OpenCart 4.1.0

Hello,

I am grateful for the availability of this great software. I setup a simple online store and everything seemed to work great. The only extension I added was the PayPal checkout extension. However when testing, I discovered an error when I choose Low to High or High to Low to sort the order of the products in categories. My expertise with websites, databases, etc is limited. Thanks in advance for any tip. I paste below the error that the browser displays

Regards, Luis

Error: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CASE WHEN `discount` IS NOT NULL THEN `discount` ELSE `p`.`price` END) ASC, LCAS' at line 1
Error No: 1064
SELECT DISTINCT *, `pd`.`name`, `p`.`image`, (SELECT (CASE WHEN `pd2`.`type` = 'P' THEN (`pd2`.`price` * (`p`.`price` / 100)) WHEN `pd2`.`type` = 'S' THEN (`p`.`price` - `pd2`.`price`) ELSE `pd2`.`price` END) FROM `ocq7_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` = '0000-00-00' OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` = '0000-00-00' OR `pd2`.`date_end` > NOW())) ORDER BY `pd2`.`priority` ASC, `pd2`.`price` ASC LIMIT 1) AS `discount`, (SELECT (CASE WHEN `ps`.`type` = 'P' THEN (`ps`.`price` * (`p`.`price` / 100)) WHEN `ps`.`type` = 'S' THEN (`p`.`price` - `ps`.`price`) ELSE `ps`.`price` END) FROM `ocq7_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` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW())) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1) AS `special`, (SELECT `pr`.`points` FROM `ocq7_product_reward` `pr` WHERE `pr`.`product_id` = `p`.`product_id` AND `pr`.`customer_group_id` = '1') AS `reward`, (SELECT COUNT(*) FROM `ocq7_review` `r` WHERE `r`.`product_id` = `p`.`product_id` AND `r`.`status` = '1' GROUP BY `r`.`product_id`) AS `reviews` FROM `ocq7_category_to_store` `c2s` LEFT JOIN `ocq7_product_to_category` `p2c` ON (`p2c`.`category_id` = `c2s`.`category_id` AND `c2s`.`store_id` = '0') LEFT JOIN `ocq7_product_to_store` `p2s` ON (`p2s`.`product_id` = `p2c`.`product_id` AND `p2s`.`store_id` = '0') LEFT JOIN `ocq7_product` `p` ON (`p`.`product_id` = `p2s`.`product_id` AND `p`.`status` = '1' AND `p`.`date_available` <= NOW()) LEFT JOIN `ocq7_product_description` `pd` ON (`p`.`product_id` = `pd`.`product_id`) WHERE `pd`.`language_id` = '1' AND `p2c`.`category_id` = '60' GROUP BY `p`.`product_id` ORDER BY (CASE WHEN `special` IS NOT NULL THEN `special` CASE WHEN `discount` IS NOT NULL THEN `discount` ELSE `p`.`price` END) ASC, LCASE(`pd`.`name`) ASC LIMIT 0,10 File: /home/ou2fwo6s/public_html/shop/system/library/db/mysqli.php Line: 122 Backtrace: 0 File: /home/ou2fwo6s/public_html/shop/system/library/db.php Line: 54 Class: Opencart\System\Library\DB\MySQLi Function: query Backtrace: 1 File: /home/ou2fwo6s/public_html/shop/catalog/model/catalog/product.php Line: 244 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /home/ou2fwo6s/public_html/shop/system/engine/loader.php Line: 343 Class: Opencart\Catalog\Model\Catalog\Product Function: getProducts Backtrace: 3 File: /home/ou2fwo6s/public_html/shop/system/engine/proxy.php Line: 87 Class: Opencart\System\Engine\Loader Function: {closure:Opencart\System\Engine\Loader::callback():312} Backtrace: 4 File: /home/ou2fwo6s/public_html/shop/catalog/controller/product/category.php Line: 227 Class: Opencart\System\Engine\Proxy Function: __call Backtrace: 5 File: /home/ou2fwo6s/public_html/shop/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Product\Category Function: index Backtrace: 6 File: /home/ou2fwo6s/public_html/shop/system/framework.php Line: 259 Class: Opencart\System\Engine\Action Function: execute Backtrace: 7 File: /home/ou2fwo6s/public_html/shop/index.php Line: 20 Function: require_once

See. https://github.com/opencart/opencart/issues/14437

Hello,

Thank you! Fantastic! Just made the correction found on GitHub and now it works perfectly. I leave here the correction as seen in GitHub