I installed this plugin on my site: https://www.opencart.com/index.php?rout ... on_id=6182
Then I created Automatic SEO URLs etc. But now when I try to edit any category I get the following error.
Code: Select all
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 ' > ') 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 = '4' GROUP BY cp.category_id) AS path, (SELECT DISTINCT keyword FROM oc_url_alias WHERE query = 'category_id=127') AS keyword FROM oc_category c LEFT JOIN oc_category_description cd2 ON (c.category_id = cd2.category_id) WHERE c.category_id = '127' AND cd2.language_id = '4'' in /home/tahabuyu/XXXXXXXXXXXXX/system/library/db/mysqli.php:40 Stack trace: #0 /home/tahabuyu/XXXXXXXXXXXXX/vqmod/vqcache/vq2-system_storage_modification_system_library_db.php(85): DB\MySQLi->query('SELECT DISTINCT...', Array) #1 /home/tahabuyu/XXXXXXXXXXXXX/vqmod/vqcache/vq2-admin_model_catalog_category.php(380): DB->query('SELECT D in /home/tahabuyu/XXXXXXXXXXXXX/system/library/db/mysqli.php on line 40