Deleting records / Creating new account with same name or email


#1

I created a User account and deleted it. I was then unable to create it again, system reports that the username and email address already exist.

After I create a new Organization, if I delete the Organization record, it does not actually delete… the record still shows up in the list even though the system said ‘Record Deleted Successfully’.
Then if I try to create a User account for the user associated to the ‘deleted’ Organization, I get the same error - username and email already exist.


#2

I reported this earlier and Harald said that Orgs can’t really be deleted. Maybe you can go into the database and delete that way?


#3

I don’t know what syntax to run to delete it on the database side. Would it be a simple query?


#4

That would be an excellent question. @harald?


#5

The gentleman who managed summer reading here last year said that the prior developer had not included “delete an organization” functionality because it was complex and required changing too many database tables. If the tenant stuff is anything like the rest of the database, I suspect that there may not be foreign key constraints so it will be challenging to figure out exactly where in the application related tenant data is stored or referenced. Just removing the organization record and seeing which parts of the GRA work and which parts do not work sounds like quite a journey down the rabbit hole.

Unfortunately, between getting our winter reading program running and now preparing for our summer reading program, this issue has not reached the top of my priority list. I am hoping to address it for the 4.0 release which I hope is going to happen in the fall.