Upgrading ReviewPost v.2.91 to v.4.2 - which config files NOT to relace

[Khashyar]

Hello,

I just finished a successful upgrade of the newest version of PhotoPost.

I am about to upgrade RP from our current 2.91 to the newest 4.2

Just as in the PhotoPost upgrade, are there any config and template files that we should NOT replace when uploading new files?

Here are files that I believe that we do NOT have to replace in our current installation:

1) Header.htm

2) Footer.htm

3) config-inc.php

4) config-int.php (although, in the 4.2 version, I see that there is a "config-intr.php file... Is that just a spelling mistake?)

>>What is the file that controls the VB integration?

Thank you for your help,

K

[Chuck S]

the config-intr.php file is native to reviewpost just like config-int.php is native to photopost

The same files you dont have to replace in reviewpost and of course you forgot about install.php as thats only needed on a new install

[Khashyar]

Originally Posted by Chuck S

the config-intr.php file is native to reviewpost just like config-int.php is native to photopost

The same files you dont have to replace in reviewpost and of course you forgot about install.php as thats only needed on a new install

Thanks, Chuck...

My version 2.91 of RP uses a config-int.php file, and not a config-intr.php file.

Does this mean that the name of the config file changed since my version?

K

[Khashyar]

I'm uploading the new files now... I will try to use and reconfigure the config-intr.php file.

[Chuck S]

it could be sure although I think config-intr.php has been used for years.

[Khashyar]

Thanks, Chuck... I did not have a config-intr.php file in my 2.91 RP install... Anyway, I used the new config-intr.php...

[Chuck S]

okay enjoy

[Khashyar]

Hi Chuck...

I ran through the Upgrade script (beginning with 2.9 -> 3.0), and my RP install is working.

However, I received a few errors during the install at different times.

I do not have any customizations in my 2.9.1 RP installation, although again, my VB version is 3.0.x

Can you please let me know if these errors are anything that I need to worry about:


2.9 -> 3.0 upgrade:

Preparing to update 2.9 database...


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


Performing MySQL command: ALTER TABLE rp_categories ADD thumbnail INT(15) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'thumbnail'

upgrade your 3.11 release:

Preparing to update 3.11 database...

Performing MySQL command: REPLACE INTO rp_settings VALUES (224, 'setting224', 'ppboards', 'open', 20, 1); ... Error: Column count doesn't match value count at row 1

3.32 release to 4.0

Preparing to update database...

Error performing MySQL command: ALTER TABLE rp_users ADD realname varchar(80) default NULL, ADD title varchar(30) default NULL, ADD signature varchar(250) default NULL, ADD avatar varchar(120) default NULL, ADD invites int(6) NOT NULL default '0', ADD accepts int(6) NOT NULL default '0', ADD laston int(15) NOT NULL default '0'
Error: Table 'russianm_reviewpost.rp_users' doesn't exist

Error performing MySQL command: ALTER TABLE rp_users ADD paypal VARCHAR(75) NOT NULL DEFAULT ''
Error: Table 'russianm_reviewpost.rp_users' doesn't exist

4.0 release to 4.1:

Preparing to update database...

Error performing MySQL command: ALTER TABLE rp_users CONVERT TO CHARACTER SET utf8;
Error: Table 'russianm_reviewpost.rp_users' doesn't exist

Error performing MySQL command: ALTER TABLE rp_users ADD language VARCHAR(75) NOT NULL DEFAULT ''
Error: Table 'russianm_reviewpost.rp_users' doesn't exist

Thanks for your confirmation that everything is OK, or if I need to make some correction to a config setting and run any of these scripts again.

K

[Khashyar]

Hi Chuck...

I am also receiving an error, I think because of double slashes after the "data" folder...

Where should I change this setting:

Warning: getimagesize(/reviews/data//9/thumbs/1Didulya_the_best.jpg) [function.getimagesize]: failed to open stream: No such file or directory in /hermes/bosweb/web260/b2603/ipw.URL/public_html/reviews/inc_reviews.php on line 146

Thanks,

K

[Khashyar]

Hello...

I fixed the double slash error by NOT including the end slash in the config-intr file (even though it says to):

// The URL of your photo dir where your images are stored (with / at end)
$rpdata_dir = "/reviews/data";

I hope that the upgrade errors don't cause any issues...

If you have any thoughts about if they are serious, please let me know.

Thanks.

[Chuck S]

Well duplicate errors are not a big deal just means you already ran that upgrade.

Now your rp_users table should exist so you would have had to delete it. You want to create it

Content visible to verified customers only.

[Khashyar]

Thanks, Chuck... I didn't mess with the RP database, so I didn't delete them, unless they were dropped unintentionally...

However, this RP installation has a separate Database from VB, but uses VB users... Is there a chance that there is an integration config setting that is not set correctly?

[Chuck S]

No even though you integrate with vb reviewpost should still also have its own users table always has.

[Khashyar]

Thanks Chuck...

I am in PHPMyAdmin...

Should I run the queries that you mentioned above through this function:

SQL query on database:

[Khashyar]

OK, Chuck...

I ran the query (I believe successfully) through "Run SQL query/queries on database xxxxx" function on phpmyadmin...

Is there anything else I need to do?

Do I need to rerun the upgrade scripts again?

[Chuck S]

as long as you added that table you should be okay so view your site and see that everything is working.