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 <[email protected]> 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 <[email protected]> > 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 : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
