Please disregard the 'View article...' shown at the bottom of many posts as this is the result of restoring old forum posts from a backup.

Fix problems running under mysql 5.7.x

If you are unable to insert new database records running under mysql 5.7.x, As of MySQL 5.7.5, the default SQL mode includes STRICT_TRANS_TABLES which prevents Exponent from creating new records (and possibly updating them?) since we pass (ALL) empty fields as null which is escaped to an empty string which is incompatible with an integer in strict mode.

This is most likely fixed by adding the following to the my.ini (mysql configuration) file in the 'mysqld' section

[mysqld]
sql_mode = ''
Sign In or Register to comment.