Okay. Which ones - could you paste the exact errors? On Tue, Mar 28, 2017 at 9:12 AM, Martin Van Aken <mar...@joyouscoding.com> wrote:
> 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 > -- Lars Helge Øverland Lead developer, DHIS 2 University of Oslo Skype: larshelgeoverland l...@dhis2.org http://www.dhis2.org <https://www.dhis2.org/>
_______________________________________________ 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