Bulk email filter editing error

Posted January 11, 20223 yr

I was editing a bulk email. Changed text, changed filters, all went ok. Then went back to re-adjust filters and so on, and when I clicked SAVE, this error happened. Can someone help?

SELECT DISTINCT COUNT(DISTINCT core_members.member_id) FROM `bb_core_members` AS `core_members`  LEFT JOIN `bb_core_pfields_content` AS `core_pfields_content` ON core_members.member_id=core_pfields_content.member_id WHERE core_members.allow_admin_mails=1 AND core_members.temp_ban=0 AND core_members.email!='' AND ( ! (`members_bitoptions` & 1 ) != 0 ) AND ( member_group_id IN(15,3) OR FIND_IN_SET(15,mgroup_others) OR FIND_IN_SET(3,mgroup_others) ) AND ( v.vid IS NULL ) AND (temp_ban IS NULL OR temp_ban=0) AND GREATEST( core_members.last_activity, core_members.last_visit ) BETWEEN 1577836800 AND 1638316800 AND member_posts>10 AND core_members.name <> ''
IPS\Db\Exception: Unknown column 'v.vid' in 'where clause' (1054)
#0 /var/www/html/forums/system/Db/Select.php(388): IPS\_Db->preparedQuery()
#1 /var/www/html/forums/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 /var/www/html/forums/system/Db/Select.php(370): IPS\Db\_Select->rewind()
#3 /var/www/html/forums/applications/core/modules/admin/bulkmail/bulkmail.php(260): IPS\Db\_Select->first()
#4 /var/www/html/forums/system/Dispatcher/Controller.php(90): IPS\core\modules\admin\bulkmail\_bulkmail->preview()
#5 /var/www/html/forums/applications/core/modules/admin/bulkmail/bulkmail.php(45): IPS\Dispatcher\_Controller->execute()
#6 /var/www/html/forums/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\bulkmail\_bulkmail->execute()
#7 /var/www/html/forums/admin/index.php(13): IPS\_Dispatcher->run()
#8 {main}

Found out what triggers it is changing from ANY to NOT VALIDATING then SAVE. If ANY is left in place, all is ok. If switch to "not validating" while it seem to SAVE the configuration, it throws above error.