But now when I visit the URL, it shows the following error:-
Code: Select all
Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /www/wwwroot/shop.example.com/system/library/db/mysqli.php on line 18
Fatal error: Uncaught Exception: Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' 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 price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '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 ps.date_end FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '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 in /www/wwwroot/shop.example.com/system/library/db/mysqli.php on line 40
OpenCart version: 3.0.3.2
Edit 1: I've also removed the duplicate data on the table oc_product_special. The way I did that was by exporting the table, editing it with text editor to remove the duplicate lines, and then importing the SQL file. Let me know if this method can cause an issue as well.