Hi, Thanks a lot for the quick answer. On server start (2.24 server on a 2.22 DB) I get errors such as: "cannot run ALTER TABLE table XXX contains null values".
>From my understanding of the release notes, looks like 2.23 was creating/populating some columns and 2.24 putting them as not null, correct ? Martin On Tue, Mar 28, 2017 at 3:06 PM, Lars Helge Øverland <l...@dhis2.org> wrote: > Hi Martin, > > going directly from 2.22 -> 2.24 should in theory be fine, as we retain > all the update statements in the source code. Look for TableAlteror.java. > > Could you paste the actual SQL errors you get during update? I am sure we > can work around this without upgrading to each instance. > > regards, > > Lars > > > > > > > On Tue, Mar 28, 2017 at 8:40 AM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Hello, >> We're upgrading a 2.22 instance to 2.24. >> Looking at the release notes, 2.23 has a SQL to run for ProgramIndicators >> (which we don't have) but 2.24 warns about setting some columns as "not >> null" and that those should be filled by the 2.23. To avoid installing each >> version in turn, is there any way to find the SQL that are run by the 2.23 >> to fill those column, so I can just run them on my 2.22 based DB & have the >> 2.24 run directly ? >> >> I tried to have a look in the source code with could not find the initial >> SQLs. >> >> Thanks ! >> >> Martin >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Lars Helge Øverland > Lead developer, DHIS 2 > University of Oslo > Skype: larshelgeoverland > l...@dhis2.org > http://www.dhis2.org <https://www.dhis2.org/> > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp