ReviewPost 2.84: Upgrade problem

criscokid · January 4th, 2005, 08:42 AM

Downloaded ReviewPost 2.84 and trying to run /upgrades/upgrade25.php (upgrade 2.5.X version to the 2.8 release)
takes me to /upgrades/upgrade25.php?step=1 - I click on "Proceed to Upgrade -->" which takes me back to takes me to /upgrades/upgrade25.php?step=1

Changing to /upgrades/upgrade25.php?step=1 to to /party/upgrades/upgrade25.php?step=2 in browser doesn't have any effect.

Aarrgghh - need help.

Coastie · January 4th, 2005, 11:18 PM

move the upgrade25.php file to the same folder as your index.php folder and run it, not from the /upgrades folder

criscokid · January 5th, 2005, 08:58 AM

That doesn't help / makes no difference.

The upgrade25.php script - I assume all this does is moke changes to the database? If that's the case what's the raw instruction code that I can use to change the mySQL database through phpMyAdmin?

Once I've done that I can then just upload the changed files to my ReviewPost installation.

Michael P · January 5th, 2005, 09:18 AM

You probably don't have regsiter globals enabled; something I need to add to these upgrade scripts.

First, you need to run it from the main RP directory, not within upgrades.
Second, you can add this to your upgrade script, just under the top comments:

Code:

Content visible to verified customers only.

criscokid · January 6th, 2005, 02:20 PM

Thank you! That's done the trick but did generate the following errors towards the end of the script:

Performing MySQL command: ALTER TABLE rp_iponline DROP INDEX userid ... Error: Can't DROP 'userid'. Check that column/key exists
Performing MySQL command: ALTER TABLE rp_products DROP INDEX approved ... Error: Can't DROP 'approved'. Check that column/key exists
Performing MySQL command: ALTER TABLE rp_products DROP INDEX date ... Error: Can't DROP 'date'. Check that column/key exists

Anything to worry about?

criscokid · January 6th, 2005, 02:53 PM

(Post deleted)

criscokid · January 6th, 2005, 07:50 PM

Was trying to get vb3 intergration working ( http://www.photopost.com/members/for...44#post1087144 ) ando now when I view my reviewpost/index.php it shows up as blank and when I view reviewpost/adm-index.php I get the following error message:

MySQL error reported!

Script: adm-index

Query: SELECT userid,username,email,password,usergroupid,timezoneoffset,salt,membergroupids FROM bbuser WHERE username=''

Result: Table 'scene-outforums.bbuser' doesn't exist

Database handle: Resource id #7