← Back to team overview

dhis2-devs team mailing list archive

Re: Migration from 2.11 to 2.14

 

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
>

Follow ups

References