There is a problem for some users who had multiple permission records where the user Settings became unavailable when updating to Spire 1.1.8 and higher. It also can affect new migrations from BVE.
- Open PGAdmin
- Connect to your database
- Highlight the company in question
- Click on the Execute Arbitrary SQL Queries button
- Paste this script:
insert into system_settings values ('spire.user.allow_edit','USERNAME',0,null,null,'Y');
(replace USERNAME with a User Name from the company)
*** Please note USERNAME is case sensitive and should be in uppercase.
For Example ;
insert into system_settings values ('spire.user.allow_edit','JOHN', 0, null, null, 'Y');
Click on the Execute Query button
- That User should now be able to edit User Settings.