problem with loading old maps
There is an issue with some old maps being loaded in the 12.0.0.
originally reported by @alberto.noronha
The summary of the problem after debugging:
In 12.0.0 we enforced reaction identifier to be unique within single map (in submap we can have duplicate of the identifier though). This looked like relatively safe fix because all supported format enforce unique identified across the map. However, CellDesigner can produce a file where reaction id is duplicated (no idea how it could happen - probably a copy paste issue).
I think we should keep the unique id in the map rule, so user wouldn't be able to upload invalid files. And for time being fix the old projects with SQL query:
update reaction_table r set idreaction=concat(r.idreaction,'_',r.iddb) from (select idreaction, model_iddb from reaction_table group by idreaction, model_iddb having count(*)>1) t where r.idreaction=t.idreaction and r.model_iddb=t.model_iddb;
Edited by Piotr Gawron