![]() |
PerkinElmer Informatics Support Forum | ![]() |
Topic Title: Can't view users and groups page - Error 500 Topic Summary: Can't view users and groups page - Error 500 Created On: 1/7/2015 6:59 AM Status Post and Reply |
Linear : Threading : Single : Branch |
![]()
|
![]() |
|
The issue appears with users that are not member of any group but active. this is not allowed in omero 4.4. those users will not be able to login. unfortunately one cannot change the user groups of such an account in Columbus, it will throw and internal server error again, which we cannot fix as it is within the Omero server. In order to solve this problem one needs to remove the 'user' group from the account in the database to make the user inactive. once this is done it can be edited again and groups can be added, as well as the account marked active again. psql> select e.id, e.omename, g.name as groupname from experimenter as e id | omename | groupname Now with that information you see that the user with id 103 is active but not in any other group. You can then delete all entries from the groupexperimentermap table for that user. psql> delete from groupexperimentermap where child=103; |
|
|
|
![]() |
FuseTalk Basic Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.