User Picker From Project Role plugin error

I use the User Picker From Project Role plugin. This plugin occurs some trouble.

[Trouble]

1. I create the custom field "test" as "User Picker From Project".

2. I add our custom field configuration it.

3. I browse the configure page about "test" .

4. I click the "Edit Selected role" link.

5. Displaying Error.

I think I need to edit selected role to use this plugin but I can't do it. Additionaly, I have error on "Create Issue" page because I have not setting about selected role. If you know workaround this error, tell me it.

I attached the screen shots and error log. Please, check it.

(error.txt)

3 answers

Hi Daniel

Thank you for your advice. I tried to find who has NULL in username but there is nobody.

mysql> select count(*) from cwd_user where user_name is NULL;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.01 sec)

The reason why there are different from my command and your refference page is that JIRA database table had changed from JIRA 4.3.

https://confluence.atlassian.com/display/JIRA044/JIRA+4.3+Upgrade+Guide#JIRA43UpgradeGuide-Databasetableshavechanged

Thanks,

Tarr

0 vote

Seems to be failing to find the field config scheme in the database. I've never seen this one before...

Can you try it again, maybe in a different instance? Perhaps there is something else wrong with this instance.

Hi Jamie,

Thank you for your comment. I tried to another instance but I couldn't find NULL username user. I use Crowd database as JIRA user directory.

mysql> select count(*) from cwd_user where user_name is NULL;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from cwd_user where user_name = "takahiro.tokunaga";
+----------+
| count(*) |
+----------+
|        1 |
+----------+
1 row in set (0.01 sec)

Please, check this. There is my account "takahiro.tokunaga" in this table but I couldn't find NULL username user.

If I made mistake, tell me about it.

Thanks,

Tarr

I don't think you should have user with username null... can you delete that one from the db?

Have you solved this problem ? I have the same problem on our jira and we also don't have a username null in the database.

BR Elke

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published Thursday in Marketplace Apps

Calling all developers––You're invited to Atlas Camp 2018

 Atlas Camp   is our developer event which will take place in Barcelona, Spain  from the 6th -7th of   September . This is a great opportunity to meet other developers and get n...

348 views 0 6
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you