dhis2-users team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

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 <martin@xxxxxxxxxxxxxxxx>
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 : martin@xxxxxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxxxxxx
> 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
lars@xxxxxxxxx
http://www.dhis2.org <https://www.dhis2.org/>