Can't delete a Permission Schema with a "+" symbol in the name

Xabier Davila

Hi,

I've created a Permission Schema containing a + symbol in it's name.

Now, I cannot edit the schema nor delete it.

Can you help me getting rid of it?

Also, it'd be good to add some validation to schema names to avoid this issue in future versions.

Thanks

xab

rverschoor

This bug has been reported in https://jira.atlassian.com/browse/CRUC-6257.
To delete the scheme you first have to change the name in the database to get rid of the '+'.
You can then delete the scheme from the Administrator interface in FishEye/Crucible.

• Stop FishEye/Crucible.
• Run the following SQL on your database:
  

  UPDATE cru_perm_scheme SET cru_name = '<new_name>' WHERE cru_name = '<old_name>';

  E.g. if you created a permission scheme "devs+qa", run te following query:
  

  UPDATE cru_perm_scheme SET cru_name = '<devsqa>' WHERE cru_name = '<devs+qa>';

• Start FishEye/Crucible.
• Go to the Administration pages and delete the renamed permission scheme.