search

ohmage / server

The ohmage server application.
37 stars 25 forks source link

migrations will fail on mysql 5.7.15 ubuntu 16.04 #897

Closed dPeS closed 8 years ago

dPeS commented 8 years ago

with: Incorrect datetime value: '0' for column 'last_modified_timestamp' at row 1 on: UPDATE class SET last_modified_timestamp = 0

since mysql switched to strict SQL mode on this:

https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_sql_mode

the workaround is to add:

sql_mode = '' in [mysqld] section of /etc/mysql/mysql.conf.d/mysqld.cnf file + mysqld restart

regards,

stevenolen commented 8 years ago

thank you for reporting! in our README we currently mention to use mysql 5.5 (although mysql 5.6 is also compatible). MySQL 5.7 has some changes that may cause some issues (one of those you're seeing above!)

MySQL 5.7 support is not currently slated.