Error after upgrade

[ljcook]

Everything went well with the upgrade of my 2.91 version to 3.00. I did get one upgrade script error.

Performing MySQL command: INSERT INTO rp_admingroups VALUES (12, 'Forum Settings') ... Error: Duplicate entry '12' for key 1

But it does not seem to be the problem.

When I go to Reviews Home I get

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\program files\apache group\apache\htdocs\reviewpost\pp-inc.php on line 692

And if I go to a product page I get a similar error meesage

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\program files\apache group\apache\htdocs\reviewpost\showproduct.php on line 109

Any ideas what is causing this?

Thanks!

edit - integration is with IPB2

[Chuck S]

I would make sure you ran all the upgrades you needed to.

Your missing a field or so from your cats table.

If you run this query in phpmyadmin you should be able to find out which one

SELECT catname,extra1,extra2,extra3,extra4,extra5,extra6,template,thumbnail FROM rp_categories

Note this below

template was added in the 2.1 upgrade
thumbnail was added in the 2.5 upgrade
the extra fields where added in the 2.9-3.0 upgrade


There is nothing missing from the upgrade scripts

[ljcook]

Thanks, the field that was missing was thumbnail. I added it and all is fine now.
Thank you!

[Chuck S]

ah okay so you forgot to run the 2.5 upgrade

[ljcook]

Originally Posted by omegatron

ah okay so you forgot to run the 2.5 upgrade

First version I purchased was 2.91 (in April) - so I did the 2.9-3.0 upgrade. Extra fields were there thumbnail wasn't.

[Chuck S]

Interesting indeed

2.5 added that field in. Maybe the install file did not have that field in 2.91 who knows.

[ljcook]

It's fixed now (on my test machine) so I'll likely upgrade my live site tomorrow.
I checked my live machine and it is missing there too. I'll just add it manually if the upgrade script doesn't.
Thanks again for your help.

[Chuck S]

Just run the 2.5 upgrade most likely Michael just missed altering the install file for 2.9

[WB]

Originally Posted by omegatron

Just run the 2.5 upgrade most likely Michael just missed altering the install file for 2.9

omegatron:

Just to make sure I'm reading you right, even if we started using RP at 2.91, if the thumbnail field isn't in rp_categories, when upgrading we should run:

Upgrade from ReviewPost 2.5 -> 2.8 (or should that be Upgrade from ReviewPost 2.1 -> 2.5.1)

first? And then run

Upgrade from ReviewPost 2.9X -> 3.0 ?

Thanks.

[Chuck S]

Yes that should be fine.

I can't comment on what was or was not in the script for 2.9 since I no longer have a copy. I can only go with what I see and that is that the field was added in 2.8 by the upgrade script.

So if by chance the categories table did not have that field on a new install for 2.8/2.9 I can't say but running that upgrade would create it

[WB]

omegatron:

Thanks.