Jump to content

Database Error After Updated To 3.1.0


Recommended Posts

I upgarded to 3.1.0. Everything went smoothly, but after last step i entered admin  page, i got this:

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.5
PHP/DB: PHP 5.3.3 / MySQL 5.0.83-community
Page: /op/www/admin/advertiser-index.php
Error: Unknown column 'an_adnetwork_id' in 'field list'
SELECT  clientname ,  an_adnetwork_id ,  type ,  clientid  
 FROM ox_clients 
 WHERE ( type = '0' )  AND (  ox_clients.agencyid = 1 ) 
 ORDER BY (type=0) ASC  , clientname  ASC 

Everything seems working, should i be worryed about that?

Admin panel says

You are currently using Revive Adserver v3.1.0 running on Apache, PHP 5.3.3 and MySQL 5.0.83-community.



Link to comment
Share on other sites

  • 2 weeks later...

The an_adnetwork_id column was removed from the clients table in August 21 of 2013, as part of the preparations for launching Revive Adserver 3.0.0. See https://github.com/revive-adserver/revive-adserver/issues/68


As far as I'm aware, there isn't any code that actually references this column, unless you have a deprecated plugin from well before Revive Adserver 3 that's being dragged along in your installation.


What was your version before you upgraded to v3.1.0?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...