Post by 8pmshop » Wed Dec 14, 2016 10:35 pm

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.

User avatar
New member

Posts

Joined
Sat Oct 08, 2016 11:27 pm
Location - new york

Post by IP_CAM » Thu Dec 15, 2016 4:42 am

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

I don't use Forum Mail, to reach me, contact: jti@jacob.ch
-
Server Q & A Basic Information on Code + Settings
http://www.everyauction.info/serverinfo.html
Demoversion OpenCart LIGHT v.1.5.6.5
http://www.jti.li/shop/
1'400+ FREE OC Extensions - from OC v.1.5.x up,
on the world's largest OC-related Github Site: https://github.com/IP-CAM
-
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by AlexDW » Fri Dec 16, 2016 3:52 am

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

Useful Opencart extensions


User avatar
New member

Posts

Joined
Sun Jun 05, 2016 3:32 am

Post by 8pmshop » Tue Dec 20, 2016 12:03 am

AlexDW wrote:Try to check table oc_url_alias for duplicate with query = 'category_id=48'
The problem is in here. right.

User avatar
New member

Posts

Joined
Sat Oct 08, 2016 11:27 pm
Location - new york
Who is online

Users browsing this forum: No registered users and 31 guests