Unable to delete Smart Group
civicrm mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, "CREATE TEMPORARY TABLE civicrm_temp_group_contact_cache1416 (SELECT 565 as gr...", "1139 ** Got error 'empty (sub)expression' from regexp")
post upgrade from 4.6 -> 4.7 -> Smart Groups with Children are broken (can't view Contacts; can't Delete; can't edit Search Criteria); relevant part of the critical Error in ConfigAndLog:
#6 (closed) /var/www/civicrm/4.7/packages/DB/mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, "CREATE TEMPORARY TABLE civicrm_temp_group_contact_cache1416 (SELECT 565 as gr...", "1139 ** Got error 'empty (sub)expression' from regexp")
Have advised client to recreate these Smart Groups; raising here for awareness;