MySql error: Incorrect date value: '0000-00-00'

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.