PhotoPost Community - Error after upgrade

PhotoPost Community (http://www.photopost.com/forum/)

- ReviewPost Installation & Upgrades (http://www.photopost.com/forum/reviewpost-installation-upgrades/)

- - Error after upgrade (http://www.photopost.com/forum/reviewpost-installation-upgrades/115374-error-after-upgrade.html)

ljcook

August 25th, 2005 01:50 PM

Error after upgrade

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

Quote:

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

Quote:

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

Quote:

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

August 25th, 2005 03:19 PM

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

August 25th, 2005 03:32 PM

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

Chuck S

August 25th, 2005 06:50 PM

ah okay so you forgot to run the 2.5 upgrade ;)

ljcook

August 25th, 2005 06:58 PM

Quote:

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

August 25th, 2005 07:17 PM

Interesting indeed ;)

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

ljcook

August 25th, 2005 08:29 PM

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

August 25th, 2005 09:03 PM

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

WB	August 26th, 2005 04:30 PM

Quote:

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

August 26th, 2005 05:54 PM

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	August 27th, 2005 12:44 PM

omegatron:

Thanks.

All times are GMT -5. The time now is 09:23 PM.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97