Post by binkenvil » Tue Aug 09, 2016 11:42 am

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 '&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 = '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

Newbie

Posts

Joined
Tue Aug 09, 2016 11:36 am

Post by paulfeakins » Tue Aug 09, 2016 6:42 pm

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.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Legendary Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom
Who is online

Users browsing this forum: No registered users and 2 guests