That was from memory, hence the lack of details, sorry for that. I'll get my 2.24 instance back and send you the exact messages.
Regards, Martin On Tue, Mar 28, 2017 at 3:12 PM, Lars Helge Øverland <[email protected]> wrote: > Okay. Which ones - could you paste the exact errors? > > On Tue, Mar 28, 2017 at 9:12 AM, Martin Van Aken <[email protected]> > 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 <[email protected]> >> 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 < >>> [email protected]> 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 : [email protected] >>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >>>> Company website : www.joyouscoding.com >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~dhis2-users >>>> Post to : [email protected] >>>> 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 >>> [email protected] >>> 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 : [email protected] >> 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 > [email protected] > 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 : [email protected] Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
