Modern AAC i mysql

[Adiko]

Czy modern AAC potrzebuje mysql 5.1, bo mam pewne problemy na mysql 5.0

A Database Error Occurred

Error Number: 1140

Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

SELECT p.id, p.question, GROUP_CONCAT(a.answer SEPARATOR ';') AS answers, GROUP_CONCAT(a.id SEPARATOR ';') AS answers_id FROM poll p JOIN poll_answer a ON p.id = a.poll_id WHERE p.status = 1 AND date_start <= NOW() AND date_end >= NOW()

 

[Azi]

SQL:

set sql_mode='ONLY_FULL_GROUP_BY';

Jak nie zadziała to szukaj pod tym hasłem w google...,bo nie pamiętam dokładnie