clnsdev Posted October 27, 2017 Report Share Posted October 27, 2017 Hello people, unfortunately, my installation still can't digest the update starting from 4.0.2. I first tried to update to 4.1.0, but even with version 4.1.1 get the following error messages (as in install.log): successfully initialised DB Upgrade verifying/creating constructive tasklist checking field: banners append found field append checking field: zones prepend found field prepend checking field: zones append found field append #! database integrity check detected problems with the database #! 3 fields to change Installation "entry point" (OX) follows: Name From Version To Version Status Date install_2.8.2 --- 2.8.2 UPGRADE COMPLETE 2011-01-31 18:17:40 What else could I try to solve? Thanks in advance and keep up the good work! Quote Link to comment Share on other sites More sharing options...
Matteo Beccati Posted October 27, 2017 Report Share Posted October 27, 2017 @clnsdev Could you please post here just the definition of the append/prepend fields in the banner and zones table? I.e. from SHOW CREATE TABLE ox_zones Quote Link to comment Share on other sites More sharing options...
Richard Cook Posted October 28, 2017 Report Share Posted October 28, 2017 I upgraded using 4.1.1. I got no errors during the upgrade process. When I go to the product upgrade screen to view the version number I see. You are currently using Revive Adserver v4.0.2 (warning: database is stamped as v4.1.1) Rich Quote Link to comment Share on other sites More sharing options...
gabrielt Posted October 29, 2017 Author Report Share Posted October 29, 2017 (edited) @Matteo Beccati Just to confirm that the new 4.1.1 version solved the issue. Many thanks for fixing this promptly. PS: on the downloads page, the link to the 4.1.1 tar.gz version is pointing to the 4.1.0 version. I am not facing the issue mentioned by @Richard Cook above. For me opening /www/admin/updates-product.php shows: You are currently using Revive Adserver v4.1.1 running on nginx 1.12.1, PHP 7.1.11 and MySQL 5.6.37-82.2-log. Cheers. Edited October 29, 2017 by gabrielt mibert 1 Quote Link to comment Share on other sites More sharing options...
mibert Posted October 29, 2017 Report Share Posted October 29, 2017 Hi Matteo, thank you very much!! Version 4.1.1. has performed the upgrade without any problem as usual. Best regards and have a great Sunday Michael Quote Link to comment Share on other sites More sharing options...
clnsdev Posted October 29, 2017 Report Share Posted October 29, 2017 @Matteo Beccati Hello Matteo, those are the definitions of the fields: banners: `append` varchar(255) DEFAULT NULL, `prepend` varchar(0) DEFAULT NULL, (I've once set it to 0 to avoid some SQL injections we had in our installation and strangely doesn't fire any warnings) zones: `prepend` varchar(255) DEFAULT NULL, `append` varchar(255) DEFAULT NULL, Thanks and have a nice day Quote Link to comment Share on other sites More sharing options...
Matteo Beccati Posted October 30, 2017 Report Share Posted October 30, 2017 @clnsdev The field type definition should be "text NOT NULL", that's why Revive is complaining. It is possible that varchar(0) is wrongly treated as being a text field, and if so that would be a bug. Quote Link to comment Share on other sites More sharing options...
clnsdev Posted October 30, 2017 Report Share Posted October 30, 2017 @Matteo Beccati Seems to be the right thing to do, thanks Matteo. I'll try an update tonight and report the result. Quote Link to comment Share on other sites More sharing options...
clnsdev Posted November 3, 2017 Report Share Posted November 3, 2017 @Matteo Beccati Hello there, I confirm that after changing the fields mentioned above the update worked without a problem. Cheers! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.