OK thanks. On Tue, Mar 28, 2017 at 9:30 AM, Martin Van Aken <mar...@joyouscoding.com> wrote:
> 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 <l...@dhis2.org> > wrote: > >> 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/> >> >> > > > -- > *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