Error after upgrade from 4.04 to 4.1
 

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?

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?

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.

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.

Have a good day let me know

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!

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.

Thank you so much! Worked like a charm!

Glad to assist!