unable to edit category.

Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/gtesc/public_html/uwlcd.com/system/library/db/mysqli.php 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(cd1.name 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=48') AS keyword FROM oc_category c LEFT JOIN oc_category_description cd2 ON (c.category_id = cd2.category_id) WHERE c.category_id = '48' AND cd2.language_id = '1'' in /home/gtesc/public_html/uwlcd.com/system/library/db/mysqli.php:40 Stack trace: #0 /home/gtesc/public_html/uwlcd.com/system/library/db.php(16): DB\MySQLi->query('SELECT DISTINCT...', Array) #1 /home/gtesc/public_html/uwlcd.com/admin/model/catalog/category.php(200): DB->query('SELECT DISTINCT...') #2 [internal function]: ModelCatalogCa in /home/gtesc/public_html/uwlcd.com/system/library/db/mysqli.php on line 40


I check the database 'oc_category_path'

Full texts category_id Ascending path_id level
Edit Edit Copy Copy Delete Delete 47 47 0
Edit Edit Copy Copy Delete Delete 48 48 0
Edit Edit Copy Copy Delete Delete 49 49 1
Edit Edit Copy Copy Delete Delete 49 47 0
Edit Edit Copy Copy Delete Delete 50 47 0
Edit Edit Copy Copy Delete Delete 50 50 1
Edit Edit Copy Copy Delete Delete 51 51 1
Edit Edit Copy Copy Delete Delete 51 47 0
Edit Edit Copy Copy Delete Delete 52 47 0
Edit Edit Copy Copy Delete Delete 52 52 1
Edit Edit Copy Copy Delete Delete 53 53 1
Edit Edit Copy Copy Delete Delete 53 47 0

don't have any problem.


'oc_category_description' don't have duplicate "category_id" product.

catalog/category.php don't have any problem also .


really don't know where's the problem. anybody know how to fix it, thanks.

already checked here, Google is full of this:
https://www.google.com/search?q=Error%3 ... n+opencart
Ernie

Try to check table oc_url_alias for duplicate with query = 'category_id=48'

AlexDW wrote:Try to check table oc_url_alias for duplicate with query = 'category_id=48'

The problem is in here. right.