mình bị lõi này khi vào phần Category trong admin mong mọi nguoi hương dan chach khắc phục
Fatal error: Uncaught Exception: 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 = '3' GROUP BY cp.category_id) AS path, (SELECT DISTINCT keyword FROM oc_url_alias WHERE query = 'category_id=33') AS keyword FROM oc_category c LEFT JOIN oc_category_description cd2 ON (c.category_id = cd2.category_id) WHERE c.category_id = '33' AND cd2.language_id = '3' in C:\xampp\htdocs\inti\system\library\db\mysqli.php:40 Stack trace: #0 C:\xampp\htdocs\inti\system\library\db.php(16): DB\MySQLi->query('SELECT DISTINCT...', Array) #1 C:\xampp\htdocs\inti\admin\model\catalog\category.php(200): DB->query('SELECT DISTINCT...') #2 C:\xampp\htdocs\inti\vqmod\vqcache\vq2-system_engine_loader.php(150): ModelCatalogCategory->getCategory('33') in C:\xampp\htdocs\inti\system\library\db\mysqli.php on line 40
I'm not sure what you're trying to do but the problem is:
"Subquery returns more than 1 row"
Which means you could fix it by putting a LIMIT in to the subquery.
"Subquery returns more than 1 row"
Which means you could fix it by putting a LIMIT in to the subquery.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Who is online
Users browsing this forum: No registered users and 2 guests