Hi Friends,
We had an odd occurrence. A patron contacted our box office saying when she logs in to our website with her email address it says her name is Eileen Wilcox, when really her name is Linda Corcorran. I went into Eileen Wilcox's account, and sure enough Linda's email address is in her record and it can not be inactivated because it is used by a login.
I don't know how this happened, but would like to fix it. After some researching, I think this will be a SQL task, but wondering if anyone can tell me what needs to be done.
Thanks,
Kanani
Weird indeed. But we had a situation like this a few months ago. It is possible for your DBA to transfer the email and login to the correct account using SQL.
Or if you'd prefer to do it from the front end you can inactive the login then inactive the email address on the wrong account. Then simply add the email address and create a new login on the correct account.
If I can do it from the front end that would be best. Where do you inactivate the login?
p.s. I'm now essentially the DBA and learning SQL so if you know which table this would be under that would be helpful, but like I said front end is preferred.
Thanks for you reply!
I'm also recently a DBA who is learning SQL. So I share your pain! :)
The table that holds login info is T_CUST_LOGIN. I wouldn't recommend making changes here unless you are totally comfortable doing it (or unless you are able to test, test, test before doing it live!).
I'm assuming you are on V11 so let me know if you are not. From the front end, load the constituent record and go to the Contact Details tab. Under the Logins button you should be able to edit the login you want to inactivate. You have to uncheck the primary box first and then check the inactivate box.
Hope that helps!