Upgraded From Openx To Revive But It's Not Pulling Data From Existing Db

[skuba]

Hi, I had to upgrade from Open Ads and followed all instructions. Everything went fine, but it's not pulling data from the DB. I see all tables there, but on Revive there are no campaigns, banners, etc...

 

I followed the instructions by copying all tables from the OA database into a brand new Revive db. I changed the original conf.php file and put on the root of the new adserver folder, where I also put all files. During installation I again pointed to the new DB.

 

Does anybody know what could be going wrong?

 

Thanks

 

PS: Could this be an issue because my Open Ads was an older version, my tables prefixes are from the time it was phpabds

[skuba]

Guys, I think it was related to the table prefixes. Revive create all new tables with prefix rv_ although I pointed to the correct DB. I am going to start from scratch and see what happens. Will report back here.

[skuba]

So, I started everything again from scratch. I think the problem with the previous upgrade was that during the upgrade wizard STEP 2 the advanced settings are collapsed and the default database prefix is rv_. So now on this fresh install, I changed the prefix to phpads_ as that's what it is on my existing openx database.

 

But it won't let me get through this step, throwing this error:

 

 

 

Your database contains an old OpenX configuration table: phpads_preferences. If you are trying to upgrade this database, please copy your existing configuration file into the var folder of this install. If you wish to proceed with a fresh installation, please either choose a new Table Prefix or a new Database.

 

This step (choosing the prefix) is not mentioned on the upgrade instructions at all. The instructions do say "don't copy the conf file into the var folder" so why is the error telling me to do it? I don't want a fresh install, by goal is to upgrade from OpenX to Revive.

 

I would really appreciate if someone can help. Thanks you very much.

[skuba]

Nobody?

 

Thanks

[skuba]

Hi, all there is so much spam on this forum, I had to bump my thread up. Still trying to get help with this issue. 

 

Just to add to my issue:

 

I manually changed the prefix setting on the conf file to phpads_, but now I am getting errors when revive tries to access DB.

 

 

 

An error occurred while accessing the database

Due to a problem with the database Revive Adserver couldn't retrieve or store data. If this problem is reproducable it might be caused by a bug in Revive Adserver. Please report the following information to the creators of Revive Adserver. Also try to describe the actions that led to this error as clearly as possible.

Version:    Revive Adserver v3.0.3 PHP/DB: PHP 5.3.28 / MySQL 5.5.36-cll Page: /oa10/www/admin/advertiser-index.php Error: Unknown column 'type' in 'field list' Query: SELECT clientname , an_adnetwork_id , type , clientid
FROM phpads_clients

WHERE ( type = '0' ) AND ( phpads_clients.agencyid = 1 )


ORDER BY (type=0) ASC , clientname ASC $_POST: Empty $_GET: Empty

 

 

Can someone please help? I much appreciate.

 

Thanks

[Matteo Beccati]

The instructions do say "don't copy the conf file into the var folder" so why is the error telling me to do it?

 

Are you sure? I'm pretty sure the instructions tell you to copy the old conf file over to the new var folder.

[skuba]

 

 

Are you sure? I'm pretty sure the instructions tell you to copy the old conf file over to the new var folder.

 

You are right. The warning was to not upload on the /adserver.

 

It seems to be working now but I had to move my images/ contents to the new folder.

 

Thanks