fracek91
Member
- Joined
- May 30, 2008
- Messages
- 423
- Reaction score
- 8
I've installed MAAC 1.0.2 and got this error:
found this thread: http://otland.net/f28/modern-aac-i-mysql-116166/ But it doesn't seem to work. Please help me
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()
found this thread: http://otland.net/f28/modern-aac-i-mysql-116166/ But it doesn't seem to work. Please help me