Laravel 5.5 ->groupBy('created_at') error?

I want to group my data by date and need to use created_at date. But there I get permanently this error:

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'laravelapp.items.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: select * from `items` group by DATE_FORMAT(created_at, '%Y-%m-%d'))

My method is:

public function scopeUserArchive($query)
    {
        return $query->select('*')
            ->groupBy(DB::raw("DATE_FORMAT(created_at, '%Y-%m-%d')"));
    }

How can I fix that to get grouped data?