
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 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
Referenced by
-
1372 No user created on install There are some issues with MySQL v5.7.x since it defaults...