Post by vapestore » Wed May 08, 2013 11:24 pm

Hey guys,

I was adding languages to my products and everything was working well. Took a break, back to work and now I cannot edit any product any more.

This is the error message I'm getting

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/vapesqgc/public_html/system/database/ipsmysql.php on line 25Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, (SELECT keyword FROM oc_url_alias WHERE query = 'manufacturer_id=8') AS keyword FROM oc_manufacturer WHERE manufacturer_id = '8' in /home/vapesqgc/public_html/system/database/ipsmysql.php on line 53

Could someone help please?
Last edited by vapestore on Thu May 09, 2013 4:00 pm, edited 1 time in total.

Image
Africa's largest selection of herbal vaporizers. Be wise, Vaporize!


New member

Posts

Joined
Tue Mar 05, 2013 1:29 pm

Post by matteoraggi » Thu May 09, 2013 12:27 pm

How you was adding language to the products? normally I add language to the site..

http://www.restaurantsupplies.eu Restaurant Supplies
Opencart 1.5.6.4 VQMOD 2.4.1
Languages: Italian, French, German, Hungarian, English, Russian, Polish and Spanish


Active Member

Posts

Joined
Fri Apr 10, 2009 8:16 pm

Post by vapestore » Thu May 09, 2013 3:24 pm

matteoraggi wrote:How you was adding language to the products? normally I add language to the site..
I was translating products' descriptions, keywords and metatags into different languages.

I've actually resolved the issue which was language/keywords related as suspected: I've installed a language URLs extension and that solved the problem.

Image
Africa's largest selection of herbal vaporizers. Be wise, Vaporize!


New member

Posts

Joined
Tue Mar 05, 2013 1:29 pm

Post by crazykiddo » Sat Jun 22, 2013 10:53 am

What language url pack did you install? I got a section of your error as well 1242. Thanks in advance!

Newbie

Posts

Joined
Sat Jun 22, 2013 10:32 am

Post by pcmarket » Thu Feb 06, 2014 12:23 am

I use opencart 1.5.5.1
when I edit product page error

"Warning: mysql_query(): Unable to save result set in /home/tabpcmar/domains/tabpcmarket.ir/public_html/system/database/mysql.php on line 22Notice: Error: Subquery returns more than 1 row
Error No: 1242
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 = '2' GROUP BY cp.category_id) AS path, (SELECT keyword FROM oc_url_alias WHERE query = 'category_id=63') AS keyword FROM oc_category c LEFT JOIN oc_category_description cd2 ON (c.category_id = cd2.category_id) WHERE c.category_id = '63' AND cd2.language_id = '2' in /home/tabpcmar/domains/tabpcmarket.ir/public_html/system/database/mysql.php on line 50 "
PLZ hepl me
thanks alot of

Newbie

Posts

Joined
Fri Feb 03, 2012 9:47 pm
Who is online

Users browsing this forum: No registered users and 51 guests