dhis2-devs team mailing list archive

[Jose Garcia Muñoz <josemp10@xxxxxxxxx>]

Thanks for the quick answer Morten,

I have executed those SQL sentences, and got no rows as result, so I am
assuming that the database is ok (without 'default' duplicates). I am
downloading the lastest version of 2.20 (it has to be 2.20), and will let
you know. Thanks

Regards
Jose

On Fri, Nov 20, 2015 at 4:53 AM, Morten Olav Hansen <mortenoh@xxxxxxxxx>
wrote:

> Hi Jose
>
> Could you try again with the latest version of 2.20 (or 2.21 / trunk),
> give our servers 40-45 min to compile it, then download and try again.
>
> If you already have duplicates in your database, you might want to check
> and delete the old ones
>
> select * from categoryoptioncombo coc inner join
> categorycombos_optioncombos ccoc on
> coc.categoryoptioncomboid=ccoc.categoryoptioncomboid inner join
> categorycombo cc on ccoc.categorycomboid=cc.categorycomboid where cc.name =
> 'default' offset 1;
>
> select * from categoryoptioncombo coc inner join
> categoryoptioncombos_categoryoptions cocco on
> coc.categoryoptioncomboid=cocco.categoryoptioncomboid inner join
> dataelementcategoryoption co on cocco.categoryoptionid=co.categoryoptionid
> where co.name = 'default' offset 1;
>
> --
> Morten
>
> On Fri, Nov 20, 2015 at 5:38 AM, Jose Garcia Muñoz <josemp10@xxxxxxxxx>
> wrote:
>
>>
>> Hi devs,
>>
>> I am exporting all metadata from a database (which seems to be ok) to
>> completely empty one. However, during the import process I am getting an
>> error of duplication in the 'default' category... Both databases are
>> running under 2.20 (build revision 19973), and I can not see any
>> duplications in the original database (maybe I didnt check that properly,
>> but i only can see in thhe database one categoryoption and category as
>> 'default'). I have also read some tickets related to this problem.... in
>> the 2.20 I think?
>>
>> Do you have any ideas? Could it be a bug during the metadata
>> export/import process?
>>
>> Thanks
>> Jose
>>
>> _______________________________________________
>> 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
>>
>>
>