Database Integrity check detected problem

[Jeff]

My OpenX that I've run for years on my site went wrong.  So we reinstalled it and now get this error:

- database integrity check detected problems with the database

- 1 tables to add

Any ideas?  Have run this for years and managed ads on my site.  Now, no dice.  I thought it was because of upgrading php but that wasn't it. When we went back to the old install, problem persists. Thanks for any suggestions.

• Errors were found when detecing previous installations of OpenX
  We have detected integrity issues with your database. This means that the layout of your database differs from what we expect it to be. This could be due to customization of your database.

Check name	Current value	Status
application - database integrity check detected problems with the database - 1 tables to add	NOT OK

[andrewatfornax]

Hi @Jeff,

Well, the first thing I would do would be to roll back to the original code and database from before you started trying to re-install it, and look at the original problem, and attempt to diagnose that. I'm not sure why you're trying to re-install the code base over an existing system.

If you can't do that, though - do the logs give you any indication of what the change to the database is?

[Jeff]

Thanks. Problem surfaced when our OpenX 2.4 stopped loading after PHP update to 5.6,
error from apache's error_log is:
PHP Fatal error:  Cannot redeclare getHostName() in
/home/veggie10/public_html/openx/www/delivery/ajs.php on line 165, referer:
http://www.vegsource.com/pt/pt.js
After rolling back to PHP 5.3 error persists.

[andrewatfornax]

Hi @Jeff,

Sorry, I missed before that it's OpenX you are talking about. That's really, really, really old. 

If it was working before you upgraded PHP, but it's not any more, then I don't think the rollback has been done fully. I would start there, and see if there's something been missed with the rollback.

[Jeff]

Okay, thanks.  Here is what my guy asked me to post to you:

When trying to update OpenX from 2.4 to 2.8 installer complains about this:
comparing database veggie08_openx with schema
/home/veggie10/public_html/openx/etc/changes/schema_tables_core_515.xml
table is missing: data_raw_ad_impression
table is not part of schema: database_action
table is not part of schema: upgrade_action
to version: 515
timing: constructive
target database: veggie08_openx
table prefix: ox_
successfully initialised DB Upgrade
verifying/creating constructive tasklist
task found: doAddTable__data_raw_ad_impression
#! database integrity check detected problems with the database
#! 1 tables to add

 

[andrewatfornax]

Hi @Jeff,

Well, I'm not really sure how I can help. I feel your pain, but man, OpenX 2.4? It's so very, very old. 

I don't know why the data_raw_ad_impression table is missing, but you could try doing a clean install of OpenX 2.4 in a new database, and then dump the database schema, and use that to create the missing table in your real database, and try the upgrade again?

[Jeff]

Thanks, we already tried this.  Can you tell me -- is any way
to import data from OpenX 2.4 to Revive?  Thanks.

[andrewatfornax]

Hi @Jeff,

Only by running the upgrade process. Revive Adserver supports upgrading from all 2.x versions of OpenX.

Unfortunately, though, if your OpenX 2.4 database doesn't match the expected specification, you're going to get the same error, though. It can only upgrade when the database it sees present matches what is expected.

[Jeff]

Is there any way to create this 'data_raw_ad_impression' table ? It seems
it's the only missing table when trying to update to OpenX 2.6 or 2.8

[andrewatfornax]

Hi @Jeff,

The easiest way would be to install a separate, clean install of OpenX 2.4, and then use your DB management tools to dump out the table schema, and import it into the database you're trying to upgrade.