Post by jordydejager » Fri Nov 04, 2016 12:31 am

When i try to edit a product or category, i get this error in return:

Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/ on line 18
Fatal error: Uncaught exception 'Exception' with message 'Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT DISTINCT *, (SELECT GROUP_CONCAT( ORDER BY level SEPARATOR '&nbsp;&nbsp;>&nbsp;&nbsp;') FROM oc_category_path cp LEFT JOIN oc_category_description cd1 ON (cp.path_id = cd1.category_id AND cp.category_id != cp.path_id) WHERE cp.category_id = c.category_id AND cd1.language_id = '1' GROUP BY cp.category_id) AS path, (SELECT DISTINCT keyword FROM oc_url_alias WHERE query = 'category_id=59') AS keyword FROM oc_category c LEFT JOIN oc_category_description cd2 ON (c.category_id = cd2.category_id) WHERE c.category_id = '59' AND cd2.language_id = '1'' in /home/ Stack trace: #0 /home/ DB\MySQLi->query('SELECT DISTINCT...', Array) #1 /home/ DB->query('SELECT DISTINCT...') #2 [internal function]: Mode in /home/ on line 40

There are certain categories and products where this error doesn't come up.

Does anyone know how to fix this problem? Thanks in advance!



Tue Oct 11, 2011 9:56 pm
Who is online

Users browsing this forum: No registered users and 37 guests