Feeling Lucky
?
[#14012] - Incorrect datetime/incorrect default value in MySQL 5.7.14
- Closed
- 10 Feb 2017
- Urgent
- Build: 3.6.5
- # 14012
Steps to reproduce the issue
Upgrade wampserver (Windows) with MySQL 5.7.14
Try to import into/duplicate a table having checked_out_time field (with default 0000-00-00 00:00:00)
Expected result
Actual result
MySQL outputs incorrect datetime/incorrect default value errors and the operation fails.
System information (as much as possible)
Windows 10
WampServer Version 3.0.6 64bit
Apache 2.4.23 - PHP 5.6.25 - MySQL 5.7.14
PHP 5.6.25 for CLI (Command-Line Interface)
Additional comments
joomla-cms-bot
- 
sural98
- comment
- 10 Feb 2017
Turning off restricted mode in my.ini solved the problem.
Thanks
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/14012.
zero-24
- | Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-02-10 19:07:50 |
| Closed_By | ⇒ | zero-24 |
Before you run a query which create/copy table you should add a line:
which turns off restricted mode on mysql 5.7 per connection.
You can also disable that in global mysql configuration.