Jump to content

skuba

Approved members
 View Profile  See their activity

  • Posts

    7

  • Joined

  • Last visited

 Content Type 

Posts posted by skuba

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

    in Managing Revive Adserver

    Posted

    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

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

    in Managing Revive Adserver

    Posted

    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.

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

    in Managing Revive Adserver

    Posted

    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

  7. Compatible With Php 5.3.28?

    in Managing Revive Adserver

    Posted

    Hi all, this question is about OpenX, if this is not the appropriate forum to do so, would you kindly point me to another site? I can't find any discussions on OpenX and their own forum is shut down.

     

    Basically my VPS host recently forced all accounts to migrate to a new server. Upon migration, none of my PHP programs including OpenX are running. They claim it's a PHP compatibility issue, which I really don't buy.

     

    "The error likely to be a PHP compatibility issue, your old server is using php 5.2 and which is reached end of life and no longer supported by cpanel. You probably need to contact your developer to adjust your coding according to support the current php version PHP 5.3.28 in your new server."

     

     

    What do you think?

    Let me know if you need more info.

    Thanks

     
×
×
  • Create New...