Jump to content
scott001

Issue with Upgrade to 5.0

Recommended Posts

I just upgraded to 5.0, ran the upgrade wizard, all seemed to go fine, but was expecting after it ran that when I went to my acp I would be prompted to update my database...I was not. When I go now to the Product Updates area I see:

  • You are currently using Revive Adserver v5.0.0 (warning: database is stamped as v4.2.1) running on Apache, PHP 7.3.10 and MySQL 5.5.5-10.3.18-MariaDB.

So was my database supposed to upgrade with 5.0? Now that it didn't happen, how can I upgrade it?

Share this post


Link to post
Share on other sites

PS - I did follow your upgrade process perfectly, copied over the new files, etc. I've been running this for over 10 years now, so know how to upgrade. I think you have a bug in your updater this time. I reverted my copy back to 4.2.1.

Share this post


Link to post
Share on other sites

We have deleted old campaigns through the interface, eliminatiing potential old targeting rules and reducing the database from 34gb to 20gb. upgrade tasks performed quicker but we still get the same warning as before: "Sie nutzen derzeit Revive Adserver v5.0.0 (warning: database is stamped as v4.2.1)"

no matter what we do, we are still not able to fully upgrade our revive instance. 

Share this post


Link to post
Share on other sites

I still have not tried to upgrade again. If you have made no changes to the 5.0 release, the same thing will happen, and I won't be able to upgrade. Were there any changes made to the software since I had this issue? 

Share this post


Link to post
Share on other sites

It's possible that by doing an upgrade but keeping the old database, it also show the old version of revive adserver.

Edit database inside table: rv_application_variable and table name: oa_version

change from 4.2.1 to 5.0.0

it should do the trick

Share this post


Link to post
Share on other sites

We have updated from RV 4.2.1 now to 5.0.2 (upgrading to 5.0 was not working due to the bugs already described). The upgrade to 5.0.2 worked fine now (no Errors) however, the data base ist still stamped to v4.2.1

"Sie nutzen derzeit Revive Adserver v5.0.2 (warning: database is stamped as v4.2.1) laufend auf nginx 1.10.3, PHP 7.0.33-0ubuntu0.16.04.7 und MySQL 5.7.28-0ubuntu0.16.04.2".

 

In the mainatainance wizard the interface asks to upgrade to Version 5.0.2 because we do not have the latest Version ...

In the install log of previous Version we receive this:

                                                             
openads_upgrade_5.0.0-beta-rc1.xml 4.2.1 5.0.0-beta-rc1    2019-11-21 17:12:53  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: openads_upgrade_5.0.0-beta-rc1_2019_11_21_05_12_53.log
 
break.gif
 upgrade_openX3rdPartyServers 1.3.1 1.5.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:06  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: plugins.log
 
break.gif
 ox3rdPartyServers_version_stamp_1.5.0 1.3.1 1.5.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:06  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: ox3rdPartyServers_upgrade.log
 
break.gif
 upgrade_openXVideoAds 1.11.9 1.12.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:09  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: plugins.log
 
break.gif
 vastInlineBannerTypeHtml_version_stamp_1.12.0 1.11.9 1.12.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:09  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: vastInlineBannerTypeHtml_upgrade.log
 
break.gif
 vastOverlayBannerTypeHtml_version_stamp_1.12.0 1.11.9 1.12.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:09  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: vastOverlayBannerTypeHtml_upgrade.log
 
break.gif
 oxLogVast_version_stamp_1.12.0 1.11.9 1.12.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:09  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: oxLogVast_upgrade.log
 
break.gif
 vastServeVideoPlayer_version_stamp_1.12.0 1.11.9 1.12.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:09  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: vastServeVideoPlayer_upgrade.log
 
break.gif
 videoReport_version_stamp_1.12.0 1.11.9 1.12.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:09  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: videoReport_upgrade.log
 
break.gif
 upgrade_openXReports 1.5.5 1.6.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:13  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: plugins.log
 
break.gif
 oxReportsStandard_version_stamp_1.6.0 1.5.5 1.6.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:12  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: oxReportsStandard_upgrade.log
 
break.gif
 oxReportsAdmin_version_stamp_1.6.0 1.5.4 1.6.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:12  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: oxReportsAdmin_upgrade.log
 
break.gif
 uninstall_openXMaxMindGeoIP 1.3.10 ---    2019-11-21 16:13:15  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: plugins.log
 
break.gif
 uninstall_oxMaxMindGeoIP 1.3.10 ---    2019-11-21 16:13:15  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: plugins.log
 
break.gif
 upgrade_openXInvocationTags 1.4.7 1.5.1 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:18  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: plugins.log
 
break.gif
 oxInvocationTags_version_stamp_1.5.1 1.4.7 1.5.1 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:18  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: oxInvocationTags_upgrade.log
 
break.gif
 upgrade_openXDeliveryLog 1.1.2 1.5.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:22  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: plugins.log
 
break.gif
 oxDeliveryDataPrepare_version_stamp_1.5.0 1.1.2 1.5.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:22  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: oxDeliveryDataPrepare_upgrade.log
 
break.gif
 oxLogClick_version_stamp_1.5.0 1.1.2 1.5.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:22  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: oxLogClick_upgrade.log
 
break.gif
 oxLogConversion_version_stamp_1.5.0 1.1.2 1.5.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:22  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: oxLogConversion_upgrade.log
 
break.gif
 oxLogImpression_version_stamp_1.5.0 1.1.2 1.5.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:22  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: oxLogImpression_upgrade.log
 
break.gif
 oxLogRequest_version_stamp_1.5.0 1.1.2 1.5.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:22  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: oxLogRequest_upgrade.log
 
break.gif
 upgrade_openXDeliveryLimitations 2.2.1 5.0.3 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:26  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: plugins.log
 
break.gif
 Client_version_stamp_5.0.3 2.2.1 5.0.3 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:26  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: Client_upgrade.log
 
break.gif
 Geo_version_stamp_5.0.3 2.2.1 5.0.3 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:26  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: Geo_upgrade.log
 
break.gif
 Site_version_stamp_5.0.3 2.2.1 5.0.3 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:26  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: Site_upgrade.log
 
break.gif
 Time_version_stamp_5.0.3 2.2.1 5.0.3 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:26  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: Time_upgrade.log
 
break.gif
 upgrade_openXDeliveryCacheStore 1.2.0 1.5.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:29  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: plugins.log
 
break.gif
 oxCacheFile_version_stamp_1.5.0 1.2.0 1.5.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:29  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: oxCacheFile_upgrade.log
 
break.gif
 oxMemcached_version_stamp_1.5.0 1.2.0 1.5.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:29  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: oxMemcached_upgrade.log
 
break.gif
 upgrade_openXBannerTypes 1.3.0 1.5.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:32  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: plugins.log
 
break.gif
 oxHtml_version_stamp_1.5.0 1.3.0 1.5.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:32  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: oxHtml_upgrade.log
 
break.gif
 oxText_version_stamp_1.5.0 1.3.0 1.5.0 UPGRADE ABGESCHLOSSEN  2019-11-21 16:13:32  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: oxText_upgrade.log
 
break.gif
 install_reviveMaxMindGeoIP2 --- 1.0.4    2019-11-21 16:13:41  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: plugins.log
 
break.gif
 install_rvMaxMindGeoIP2 --- 1.0.4    2019-11-21 16:13:41  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: plugins.log
 
break.gif
 install_rvMaxMindGeoIP2Maintenance --- 1.0.4    2019-11-21 16:13:41  
spacer.gif break-l.gif
 
Restbestandteil: 1 Löschen
Logfiles: plugins.log

 

Despite my initial thought that the update worked fine and just the DB Version was not stamped correctly, I have no realized that no Banners work anymore: all banners got the "last update" timestamp "01.01.2000 00:00:01"; clicking on the banner details page in the admin interface opens a white page. seems,  interface is not able to load banner details.

we have rolled back now to 4.2.1 version again. 

 

Share this post


Link to post
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.

Guest
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...