Hello all,
On our QA server in the OpenSpecimen UI, I can create elements (institutes, sites, containers etc) but I cannot delete them again. If I try to delete them, I get a notification that deletion was successful but then the element is still there in the list, also after refreshing. In the MySQL database, the entry is not marked as disabled. If I change the status to ‘Disabled’ in the MySQL DB then it disappears from the user interface.
What is very strange, is that on our productive server, I have installed OpenSpecimen in exactly the same way but there the deletion works fine. The two virtual servers are identical.
I thought of logging all the SQL commands that OpenSpecimen sends to the DB, but I don’t know how to go about it. Actually I think it might have something to do with the integer that normally gets appended to a disabled element in the MySQL DB.
Any help would be greatly appreciated.