Post by kristoz » Fri Nov 09, 2012 3:21 am

I upgraded 1.5.1.3 to 1.5.4.1 , but I have litte problem...

When I want to edit some products in admin panel I am getting this error:

Code: Select all

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/myfitne1/public_html/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=527') AS keyword FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '527' AND pd.language_id = '1' in /home/myfitne1/public_html/system/database/mysql.php on line 49
Could someone help me to fix it?

New member

Posts

Joined
Sun Sep 25, 2011 9:53 pm

Post by kristoz » Fri Nov 09, 2012 3:26 am

Error log showing this:

Code: Select all

2012-11-08 19:25:22 - PHP Warning:  mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Unable to save result set in /home/myfitne1/public_html/system/database/mysql.php on line 21
2012-11-08 19:25:22 - PHP Notice:  Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT DISTINCT *, (SELECT keyword FROM url_alias WHERE query = 'product_id=843') AS keyword FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '843' AND pd.language_id = '1' in /home/myfitne1/public_html/system/database/mysql.php on line 49

New member

Posts

Joined
Sun Sep 25, 2011 9:53 pm

Post by arunjc » Sun Dec 16, 2012 8:02 pm

i am also facing the same problem any one help

Newbie

Posts

Joined
Fri Nov 16, 2012 7:59 pm

Post by cwswebdesign » Wed Dec 19, 2012 10:02 am

Sounds like you're missing a column in the database. Did you run the upgrade script without any issues?

DL

This account is inactive. Look for us under the name 'EvolveWebHosting' and contact us under that username.

Thanks!


User avatar
Active Member

Posts

Joined
Sun Dec 11, 2011 12:26 am
Location - USA
Who is online

Users browsing this forum: No registered users and 3 guests