- This topic has 5 replies, 2 voices, and was last updated 4 years, 3 months ago by Norine Spears.
January 25, 2018 at 1:38 pm #2371Grau
Unfortunately, I uploaded a faulty taxon tree. I now want to delete the old taxon tree. Is there a way to do this? Using the MySQL Workbench (not the specify Workbench), I would have to set the keys to ON DELETE CASCADE, which I don’t wannt to do as I am not good at sql programming.
Is there a features in specify, that allows the admin user to delete taxon trees?
Thank you!February 16, 2018 at 7:39 pm #2801Norine Spears
You can delete a tree that is not associated with collection objects by deleting the top node of the tree (typically Kingdom). Right-mouse-click on the top node and you are given a dialog of options. Delete will be available if there are no associations to collection objects.
If you do have associations between your collection objects (specimens) and tree taxonomy nodes, then deleting the tree nodes will delete these associations and you would need to re-establish them. You should proceed with caution and consider your options. We appreciate your apprehension in working with MySQL if you are not familiar with databases. If you do not have access to IT support our engineers are happy to assist you through our Data Cleanup Management services. We are happy to discuss your situation with you.
– NorineFebruary 21, 2018 at 9:32 am #2804Grau
thank you for your answer. However, the delete option does not appear (it is greyed out). I waited 30 minutes(!), because I realized that sometimes it needs a few seconds to become click-able. Did not happen. There were no collection objects associated. I am also the admin of this database so I should have all the rights. No one else was logged in at that time.
The delete option does work when I try to delete a genus or species. I think, the bigger the tree is the longer the delete option needs to appear. If you try to delete a whole kingdom, division, or phylum it takes forever.February 21, 2018 at 2:15 pm #2806Norine Spears
You are very observant! Yes, the Delete will be disabled as Specify checks each node on the tree to ensure there are no associations — and this can take time depending on the size of your tree and your CPU performance. Therefore, the lower the node, the less time it takes to check for these associations.
To make the Taxon table work in trees each node has to be numbered in the database – and then renumbered with each change; therefore, after you delete a node Specify then has to work in the background to update the tree. So, when you right-mouse-click on the next node, to delete it, Specify is very likely still updating and once that is finished starts all over checking each node for associations.
Of course, the alternative is to perform the deletion in MySQL and we are happy to discuss this with you.
– NorineFebruary 21, 2018 at 2:20 pm #2807Grau
Thank you for your answer =)
I managed to delete the tree via mysql!February 22, 2018 at 4:12 pm #2809Norine Spears
- You must be logged in to reply to this topic.