Copied Reviewpost to new site - evrything points to old site

criscokid · January 7th, 2005, 06:42 AM

I've been running my site with vBulletin 2, vbPortal and Photopost, & Reviewpost up until. Now that vbPortal 3 is available I've taken the plunge...

To make sure things go smoothly for the users of my site I've made a copy of my site onto a new domain where I can get things working (behind the scenes) without breaking my site at then done the necessary upgrades to latest version, etc. I've remembered to change the config-inc.php file every case regarding the paths, etc so that everything points to my new site on the new domain.

Upgraded to vBulletin 3.0.3 and installed vbPortal 3. Upgraded vBulletin to 3.0.4 when it was released earlier this week. Got Photopost upgraded to latest version and working ok with intergation, etc.

I'm having a problem with Reviewpost... copied it (ver 2.5) to the new domain, ran the upgrade script to take it to version 2.84 which ran ok except for these errors:

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

Checked my config-inc file is correct regarding paths, etc... everything looks correct. In a web browser I go to /reviews/index.php and evrything is appearing as it should (also got the vBulletin/vbPortal intergration working).

Howeverer in the section of the screen where my Reviewpost is displayed... all of the links are pointing to the reviewpost installation of my original site - not my new site. I've cleared all the cookies in the browser to make sure that's not causing the problem but that gasn't helped.

criscokid · January 8th, 2005, 01:13 PM

Can anyone help me here? Please.

Chuck S · January 8th, 2005, 01:55 PM

You would need to login and upgrade your admin section global options with the correct url and paths to everything as well as updating the config.

You made no mention of updating the admin paths and urls which tell the program where to run

criscokid · January 9th, 2005, 03:20 AM

Going to reviews/adm-index.php and logging in works ok but it's directing me to the the admin section on my original section - I guess the esiest way around this is to edit the relevant database table... (of to try that)

criscokid · January 9th, 2005, 03:41 AM

Maybe a good idea to do upgrades, etc in the morning when one's mind is fresh and uncluttered - easier to spot the obvious.

Made the relevant changes but now get the following error message:

MySQL error reported!

Script: index

Query: SELECT u.userid,u.username,u.email,u.password,u.usergroupid,u.timezoneoffset,s.sessionhash,u.salt,u.membergroupids FROM bbuser u LEFT JOIN bbsession s ON s.userid=u.userid WHERE u.userid='1'

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

Database handle: Resource id #8

And going to /reviews/adm-index.php generates the following error:

MySQL error reported!

Script: adm-index

Query: SELECT u.userid,u.username,u.email,u.password,u.usergroupid,u.timezoneoffset,s.sessionhash,u.salt,u.membergroupids FROM bbuser u LEFT JOIN bbsession s ON s.userid=u.userid WHERE u.userid='1'

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

Database handle: Resource id #7

Is it possible that the upgrade script didn't modify all of the tables corectly?

Chuck S · January 9th, 2005, 09:05 AM

Your integrating with VB3 right

Is the vb3 database scene-outforums?

Is the vb3 database prefix bb? I think not. I think you placed the cookie prefix where the table prefix goes.

well mornings are alright just make sure to have plenty of java

criscokid · January 9th, 2005, 01:03 PM

Quote:

Originally Posted by omegatron

Is the vb3 database prefix bb? I think not. I think you placed the cookie prefix where the table prefix goes.

That's exactly what I did - DOH!

Edited my header-inc.php for intergating with vBulletin but now I don't get the skin like I do on my Photopost installation - my Reviewpost installation is on a white background.

My$vbpath & $pppath are set correctly.