From version 5.7 MySQL stops supporting zeros value in date / datetime. If you have those values in your database you get errors for queries, like group by. Also you are not able to insert zero dates. When you need a fast fix and are not willing to change it for a NULL for an example. You can change it from mysql configuration file or run this query before you start your own queries.
Source code viewer
- SET SQL_MODE='';Programming Language: MySQL