OpenCart Community

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?

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

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.

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

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