This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
April 11, 2012 10:59pm
Subscribe [2]#1 / Apr 11, 2012 10:59pm
i Have this error while deleting spam member, how to solve the problem
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 count(*) as count, `recipient_id` FROM (`exp_message_copies`) WHERE `message_read` = 'n' AND `sender_id` IN ('401', '399', '400', '398', '396', '397')
Filename: models/member_model.php
Line Number: 595#2 / Apr 12, 2012 3:33pm
Hey Tyas,
I am sorry to hear you are running into this bug.
But if you comment on the bug you will be notified of any progress on it.
There is also a fix listed. Can you try that out and let me know if it works for you?
Cheers,