Не работает запрос на веб сервере

Здравствуйте! Есть запрос:

select
  date_format(from_unixtime(datetime), '%Y-%m-%d') as datetime,
  sum(sum) as sum
from
  payments
WHERE
  `datetime` BETWEEN '1407872709' AND '1707872709'
group by
  date(from_unixtime(datetime))

Запрос нормально работает на локальном сервере и не работает веб сервере. Версии php и mysql везде одинаковы. myAdmin возвращает такой результат:

SQL query: Documentation
select date_format( from_unixtime(datetime), '%Y-%m-%d') as datetime, sum(sum) as sum from payments WHERE datetime BETWEEN '1407872709' AND '1707872709' group by date(from_unixtime(datetime)) LIMIT 0, 25

MySQL said: Documentation
#1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'carilla.payments.datetime' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by