Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from table
- >> Mysql2::Error: Invalid date: 1900-00-00
- mysql --version
- mysql Ver 14.14 Distrib 5.1.61, for debian-linux-gnu (i686) using readline 6.1
- mysql> select @@global.sql_mode;
- +-------------------+
- | @@global.sql_mode |
- +-------------------+
- | |
- SET SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
- set global sql_mode="NO_ENGINE_SUBSTITUTION";
- [mysqld]
- sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
- sudo service mysql restart
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement