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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Jul 10, 2018 in Marketplace Apps

If you’re an Atlassian app developer, you’ll want to know about Atlas Camp!

This September 6-7, hundreds of Atlassian App developers will flock to Barcelona Spain to build skills, discover product roadmaps, meet face-to-face with the Atlassian team, and learn how to extend t...

181 views 0 4
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