#147 The field could not be created. Please check the values you entered.

[Alexander Pannwitz]

Hi,

I have installed the latest version of OpenEMM (2015 R2). Adding a new field in "Edit Profile Fields" results always in "The field could not be created. Please check the values you entered." doesn't matter what kind of fields I try to add.

Best regards
Alex

[Martin Aschoff]

You should check Tomcat's log catalina.out for any related error messages. Maybe you did not grant sufficient database rights to OpenEMM?

[Alexander Pannwitz]

Hi, thank you for the hint. There are error messages like:

2016-08-30 14:15:41,303: ERROR [http-nio-8080-exec-8] org.agnitas.util.DbUtilities - Cannot create db column: ALTER TABLE customer_1_tbl ADD (aaa VARCHAR(20) DEFAULT ' em')
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [ALTER TABLE customer_1_tbl ADD (aaa VARCHAR(20) DEFAULT ' em')]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'creation_date'

Doesn't matter what kind of column I am trying to add. The error message is always "Invalid default value for 'creation_date'")

[Martin Aschoff]

Which version of MySQL do you use?

[Alexander Pannwitz]

$ apt --installed list | grep mysql

libmysqlclient20/xenial-updates,xenial-security,now 5.7.13-0ubuntu0.16.04.2 amd64 [installed,automatic]
mysql-client-5.7/xenial-updates,xenial-security,now 5.7.13-0ubuntu0.16.04.2 amd64 [installed,automatic]
mysql-client-core-5.7/xenial-updates,xenial-security,now 5.7.13-0ubuntu0.16.04.2 amd64 [installed,automatic]
mysql-common/xenial-updates,xenial-updates,xenial-security,xenial-security,now 5.7.13-0ubuntu0.16.04.2 all [installed,automatic]
mysql-server/xenial-updates,xenial-updates,xenial-security,xenial-security,now 5.7.13-0ubuntu0.16.04.2 all [installed]
mysql-server-5.7/xenial-updates,xenial-security,now 5.7.13-0ubuntu0.16.04.2 amd64 [installed,automatic]
mysql-server-core-5.7/xenial-updates,xenial-security,now 5.7.13-0ubuntu0.16.04.2 amd64 [installed,automatic]
python-mysqldb/xenial,now 1.3.7-1build2 amd64 [installed]

[Martin Aschoff]

Sorry, OpenEMM does not support MySQL 5.7. AFAIK, there is a backward incompatibility with date formats.

[Alexander Pannwitz]

ok, also in der Doku steht "MySQL ab Version 5.5". Welche soll ich nun am besten benutzen? 5.6?

[Martin Aschoff]

We recommend 5.6, but 5.5 is fine as well. Also, you might try MariaDB 10. Opposed to MySQL 5.7, MariaDB is backward compatible with MySQL 5.5.