Plugin crashed when accessed

[Iulian G]

After accessing the profile → Logged Work

the plugin crashed with the error attached.

[Johannes Heger]

Iulian, sorry for the inconvenience.

The following line in the logfile could indicate a database configuration Atlassian applications doesn’t support. It is about NO_AUTO_VALUE_ON_ZERO.

java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '0' for key 'PRIMARY'

Please could you check your database configuration against the following article: https://confluence.atlassian.com/adminjiraserver084/connecting-jira-applications-to-mysql-5-7-979404275.html, specially this:

// remove this if it exists
sql_mode = NO_AUTO_VALUE_ON_ZERO

Do the following steps in a staging instance first.

If this setting is active:

• disable Trock app
• comment-out the line above
• drop Trock’s tables: AO_A18366_ADMINCONFIG, AO_A18366_USERCONFIG
• restart your MySQL-server
• restart Jira.
• enable Trock app
• proceed evaluating Trock

If this isn’t the root cause, we’ll proceed on this issue as well as on #23.

Kind regards, Johannes

[Johannes Heger]

Iulian, did you solve this? Any further issues?

Best regards, Johannes