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?
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@gmail.com 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?
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@gmail.com 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@gmail.com 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?