Unable to create a Plan in Portfolio

[mpilleux]

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,

[mpilleux · Accepted solution]

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.