Problem:


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.



Solution:


  1. Open PGAdmin
  2. Connect to your database
  3. Highlight the company in question
  4. Click on the Execute Arbitrary SQL Queries button
  5. 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');

  6. Click on the Execute Query button

  7. That User should now be able to edit User Settings.