Hello,
I need help installing portfolio. Once it is installed, I can't create a plan with portfolio.
I also can't assign permissions to persons or groups within portfolio.
Once I try to add permissions to my users, i get the following error
com.atlassian.activeobjects.internal.ActiveObjectsSqlException :There was a SQL exception thrown by the Active Objects library: Database: - name:MySQL - version:5.6.42 - minor version:6 - major version:5 Driver: - name:MySQL Connector Java - version:mysql-connector-java-5.1.47 ( Revision: fe1903b1ecb4a96a917f7ed3190d80c049b1de29 ) com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '0' for key 'PRIMARY'
I tried reinstalling portfolio for JIRA, but I keep getting the same errors.
I think the problem lies in the AOPERMISSION table which inserts a row with all null values except the ID_OTHER field which is initialized in 0.
I appreciate the help
Cheers,
The problem was due to a bad MySQL configuration.
We had the variable sql_mode = NO_AUTO_VALUE_ON_ZERO set.
Removing this variable was able to fix the problem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.