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 · Accepted solution]

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.

[Conor]

I have confirmed this is a bug

https://jira.atlassian.com/browse/FE-4359

[Zul NS [Atlassian]]

Unable to reproduce in 5.1. Can you provide the steps to reproduce and error logs?