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?
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.
Africa's largest selection of herbal vaporizers. Be wise, Vaporize!
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
I was translating products' descriptions, keywords and metatags into different languages.matteoraggi wrote:How you was adding language to the products? normally I add language to the site..
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.
Africa's largest selection of herbal vaporizers. Be wise, Vaporize!
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
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
Who is online
Users browsing this forum: Baidu [Spider] and 65 guests