problem facing in creating issue on jira 5.0.7

[kanthu kumar]

while creating the issue we are facing the problem called "Error creating issue:-Error occured while storing issue"

[Nic Brough -Adaptavist-]

You will need to read the application log for more details on what the actual error is.

[Vishnukumar Vasudevan]

Also check the permissions in DB side.

[kanthu kumar]

After checking logs i can see this below error

Exception while executing the following:INSERT INTO jiraaction (ID, issueid, AUTHOR, actiontype,
actionlevel, rolelevel, actionbody, CREATED, UPDATEAUTHOR, UPDATED, actionnum) VALUES (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?) (Incorrect string value: *'\xD1\x82\xD0\xB5\xD1\x81...'* for column 'actionbody' at
row 1))

[Nic Brough -Adaptavist-]

So there's rubbish being put into a comment somehow. Check with the user to see what they are entering? I'd also check if you've got everything set up for utf-8 correctly

And, again, read the application logs - that database error is likely to be only part of the problem, and you need to know what all of it is.

[Renjith Pillai]

What is the database type? MySQL? Like Nic said, check the character set for the database.

Read the command at - https://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+MySQL#ConnectingJIRAtoMySQL-2.CreateandConfiguretheMySQLDatabase