← Back to team overview

dhis2-devs team mailing list archive

Re: Migration from 2.11 to 2.14

 

yes in mysql when we converted from 2.12 to 2.14 it doesn't work, I
manually executed update query.


On Thu, Mar 27, 2014 at 2:13 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:

>
> On Mar 27, 2014 7:41 AM, "Bharath" <chbharathk@xxxxxxxxx> wrote:
> >
> > One thing you can check is datavalue  table.
> > When you upgrade to 2.14, new column with the
> name attributeoptioncomboid will be created in datavalue table and it will
> populated with 0 by default. So you may run query to change this value from
> 0 to default categoryoptioncomboid (most of the cases it will be 1).
> >
> > query will be some thing similar to: update datavalue
> set attributeoptioncomboid = 1 (here 1 is default categoryoptioncomboid)
>
> Hi, this should happen automatically. Works on postgres, I guess what you
> are saying is that it does not work on mysql?
>
> >
> >
> >
> >
> >
> > On Wed, Mar 26, 2014 at 8:25 PM, Marcio Thome <mthome@xxxxxxxxxxxxx>
> wrote:
> >>
> >> Hi all
> >>
> >>
> >>
> >> Is anyone out there that could help us in using DHIS2 2.14?
> >>
> >>
> >>
> >> I am not being able to migrate from 2.11 to 2.14. I run DHIS2 2.14 with
> the old MySQL database but cannot visualize the data in data entry or in
> the reports. It is fine in 2.11. When I attempt to run Analytics I am
> confronted with an exception error. All the screen shots are attached. I am
> running on Apache Tomcat, MySQL, DHIS2 version 2.14 build 13815 and Version
> 2.11 build 10550.
> >>
> >>
> >>
> >> Thank you for assisting. We are resisting in giving up on version 2.14
> and hoping someone already had similar issues already resolved.
> >>
> >>
> >>
> >> Best
> >>
> >>
> >>
> >> Marcio
> >>
> >>
> >>
> >> --
> >> Márcio Thomé
> >>
> >> Coordenador
> >> Departamento de Avaliação e Estatísticas
> >> BEMFAM - Bem Estar Familiar no Brasil
> >> Avenida Carlos Chagas Filho, 791. Ilha do Fundão.
> >> Rio de Janeiro. 21941-599
> >> Tel.: 55-21-30057207 R. 2408
> >> Skype: Marcio-Deav
> >>
> >> _______________________________________________
> >> Mailing list: https://launchpad.net/~dhis2-devs
> >> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >> Unsubscribe : https://launchpad.net/~dhis2-devs
> >> More help   : https://help.launchpad.net/ListHelp
> >>
> >
> >
> >
> > --
> >
> > Regards,
> > Bharath Kumar. Ch
> >
> > _______________________________________________
> > Mailing list: https://launchpad.net/~dhis2-devs
> > Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~dhis2-devs
> > More help   : https://help.launchpad.net/ListHelp
> >
>



-- 

Regards,
Bharath Kumar. Ch

Follow ups

References