Error No: 1242 HELP cant edit products and categories
Posted: Fri Nov 09, 2012 9:19 pm
Hi Everyone
I hope someone can help me
I have the problem that after upgrading from 1.5.1 to latest version i cant edit some of my categories and products
The error i get is:
Warning: mysql_query() [function.mysql-query.php]: Unable to save result set in /home/xxx/www/shop.xxxxx.xx/system/database/mysql.php on line 21Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, (SELECT keyword FROM url_alias WHERE query = 'product_id=341') AS keyword FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '341' AND pd.language_id = '1' in /home/xxxxx/www/shop.xxxx/system/database/mysql.php on line 49
Similar erros on other products and categories
Everything else works fine no erros on front or so
I just cant edit any more cats and products
I really would like to get some help or advice
I think this is the first ever major error i got since I use OC from earlest versions
I hope someone can help me
I have the problem that after upgrading from 1.5.1 to latest version i cant edit some of my categories and products
The error i get is:
Warning: mysql_query() [function.mysql-query.php]: Unable to save result set in /home/xxx/www/shop.xxxxx.xx/system/database/mysql.php on line 21Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, (SELECT keyword FROM url_alias WHERE query = 'product_id=341') AS keyword FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '341' AND pd.language_id = '1' in /home/xxxxx/www/shop.xxxx/system/database/mysql.php on line 49
Similar erros on other products and categories
Everything else works fine no erros on front or so
I just cant edit any more cats and products
I really would like to get some help or advice
I think this is the first ever major error i got since I use OC from earlest versions