Specify7 Login error for one user

Get Help
21

I tried, but I don thave this options

image
image773×111 21.7 KB

I only see this.

image

22

Hi @ray,

It looks like your account does not have permission to do perform the steps required to resolve this issue. Do you have access to an account that is an ‘Institution Admin’ in Specify? It should have the necessary permission to modify the agent associated with a Specify User.

If you would like, you can send us a backup of your database and we can help prepare a SQL script to resolve this issue for you on your end without any modification within Specify itself.

23

Hi, sounds good, thank you, I will send out a backup of our DB shortly.

24

Hi, I just sent a backup of our DB, thank you for the help.

25

Thank you @ray!
We’ve received the database and we’ll investigate as soon as possible.

26

Hi @ray,

I was able to recreate your issue exactly when performing a record merge and when logging in as bhollingsworth in your database.

To resolve these issues, all you need to do is run a simple SQL script to remove the duplicate that is causing login issues for the user and blocking the agent merge.

UPDATE agent
	SET SpecifyUserID=NULL
	WHERE AgentID=2117;

This will remove the problematic Specify User association for that second agent.

In a test instance I was able to log in as bhollingsworth without any issues after this fix!

image

27

HI! sorry for my late reply, was out for a couple of weeks due to Covid :confused:

I will update with the result of the query. Thank you!

28

That fixed the issue, thank you very much for all your help!

1 Like