Bug: Unable to insert new database records running under mysql 5.7.x
Reported by dleffler | November 9th, 2015 @ 08:28 PM | in 2.5.2 (closed)
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.
Comments and changes to this ticket
-
-
-
dleffler February 27th, 2016 @ 03:25 PM
- State changed from “new” to “knownissue”
- Milestone cleared.
This is most likely fixed by adding the following to the my.ini (mysql configuration) file in the 'mysqld' section
[mysqld] sql_mode = '' -
-
dleffler June 24th, 2016 @ 05:01 PM
The longer term fix for this issue will require some extensive rewriting of the database engine and may possibly break backwards compatibility?
-
dleffler September 16th, 2016 @ 11:01 AM
- Tag changed from “database” to “database, mysql”
-
dleffler March 12th, 2020 @ 02:34 PM
- State changed from “knownissue” to “resolved”
- Assigned user set to “dleffler”
- Milestone set to “2.5.2”
This has been fixed with a recent code push
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป
Bug Tracker for Exponent CMS
dleffler
expNinja
Referenced by
-
1372
No user created on install
There are some issues with MySQL v5.7.x since it defaults...