ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Database Error Number: 1140

May 02, 2012 2:17pm

Subscribe [1]
  • #1 / May 02, 2012 2:17pm

    burkesam

    2 posts

    Hello.

    I was just deleting a few pending members from my EE 2.4 site and got the following error screen:

    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 ('106', '107', '108', '109', '110', '111', '112', '113', '114', '115', '116')
    
    Filename: models/member_model.php
    
    Line Number: 595
    
    « Back

    The members no longer appear in the control panel so the action seems to have worked. Just curious about the error screen and what steps I should take.

    Thanks.

  • #2 / May 02, 2012 4:48pm

    burkesam

    2 posts

  • #3 / May 03, 2012 11:51am

    Dan Decker

    7338 posts

    Hi burkesam,

    Sorry you ran into that bug!

    I’m glad to see you have the solution.

    If you need anything else, just let us know.

    Cheers,

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases