OP5 Monitor - How to fix "1364 Field 'alias' doesn't have a default value".

Sometimes you get the following error message when importing configuration:

You might want to do a complete reimport?
No imported configuration exists
A bug was encountered in /monitor/op5/nacoma/index.php Please contact OP5 Support regarding this matter. There was a SQL error The debug information in /tmp/nacoma-stacktraces/... will be essential to troubleshooting the problem, so please include it if you file a bug report or contact op5 Support.

If the stack trace file contains something like:

There was a SQL error
SQLSTATE[HY000]: General error: 1364 Field 'alias' doesn't have a default value

You probably have sql_mode set to "STRICT_TRANS_TABLES" in the MySQL/MariaDB configuration. Verify by checking your /etc/my.cnf or using the MySQL cli:

# grep sql_mode /etc/my.cnf
# mysql -e "show variables like 'sql_mode'"

By default, this setting isn't set:

# mysql -e "show variables like 'sql_mode'"
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| sql_mode | |
+---------------+-------+

Because of database design, we don't support the use of "STRICT_TRANS_TABLES", so you need to remove this setting in /etc/my.cnf and restart MySQL/MariaDB afterwards:

# systemctl restart mariadb # EL7
# service mysqld restart # EL6

If you can't find the stack trace in EL7, you can easily find it by issuing this command:

# find /tmp -type d -name "nacoma-stacktraces"