Conflict between date and created_at column

[simonelepore]

In two of my projects I've had the same issue. If I have a table with both a 'date' column and the default 'created_at' column, the Trend query will not work. I think it's because the alias 'date' that is internally used in the query conflicts with the actual other 'date' column (when it performs a group by and order by 'date').

In fact, if I change name to the 'date' column to something else, it will work. Or if I set the mysql 'strict' property to false in database.php

Is there a way to fix this? thank you!