SQL exception when filtering customers group

[a_smith]

PS 1.5.6.2

BO

Go to Customers tab and then Groups

Click on the chosen group to see all customers in this group.

Then if changing the filter on the ACTIVE/NOT ACTIVE column I get:

 

 

[PrestaShopDatabaseException]

Unknown column 'a.active' in 'where clause'

        SELECT SQL_CALC_FOUND_ROWS
         a.*
        , c.*
        FROM `ps_customer_group` a
        
        LEFT JOIN `ps_customer` c ON (a.`id_customer` = c.`id_customer`)
        
        WHERE 1 AND a.`id_group` = 6 AND c.`deleted` != 1  AND a.`active` = 1
        
        
        ORDER BY a.`id_group` ASC LIMIT 0,100

 

Edited April 6, 2014 by a_smith (see edit history)