Error after upgrade from 4.04 to 4.1

imagirlgeek · April 19th, 2009, 10:04 PM

I just ran the upgrade from 4.04 to 4.1 and it all appears to have gone well...except when I click my Category link I get the following errors at the top of the page.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /path/to/my/reviewpost/showcat.php on line 577

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /path/to/my/reviewpost/showcat.php on line 615

Can you help me track down what I've done wrong?

imagirlgeek · April 19th, 2009, 11:15 PM

The 2 lines are:

577 $rowcnt = mysql_num_rows($queryv);
615 while ( $row = mysql_fetch_row($queryv) )

If I do this -->

577 $rowcnt = @mysql_num_rows($queryv);
615 while ( $row = @mysql_fetch_row($queryv) )

The error goes away. Does this mean my tables didn't get upgraded?

Chuck S · April 20th, 2009, 07:31 AM

well very strange if you set the debug option in admin global options to display errors what is the error it displays on showcat?

I think maybe you missed running an upgrade or have a corrupt table.

imagirlgeek · April 21st, 2009, 12:55 PM

I'm sorry...I can't track down what happened now. I found that any new categories I create don't display the errors, so I just did that (and removed the @). I only had 4.04 installed for a day before upgrading to 4.1, so I only had to replace 2 products.

Thank you for the suggestions though and I'll post back if I see anything weird going forward.

Chuck S · April 21st, 2009, 01:13 PM

Have a good day let me know

raynett · May 28th, 2009, 01:31 PM

Hi, I'm experiencing the same problem when upgrading from 4.04 to 4.11. This is the error message:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT id,user,userid,cat,date,title,description,keywords,bigimage,views,approved,rating,manu,numreviews,extra1,extra2,extra3,extra4,extra5,extra6,disporder,zipcode FROM products WHERE approved=1 AND cat=8 ORDER BY disporder,price DESC

Result: Unknown column 'price' in 'order clause'

Database handle: Resource id #22

Any help you can offer will be greatly appreciated. Thanks in advance!

Chuck S · May 28th, 2009, 02:16 PM

Yes there was a cross over in sort table settings in the translations.

Redownload the build and upload upgrade.php and phrases.php and run the 4.1 upgrade and reimport your phrases should fix your issue.

raynett · May 28th, 2009, 02:46 PM

Thank you so much! Worked like a charm!

Chuck S · May 28th, 2009, 02:55 PM

Glad to assist!