Sonya* Posted December 13, 2021 Posted December 13, 2021 I have created a new bulk mail with following selection: And get this SQL error upon saving: SELECT DISTINCT COUNT(DISTINCT core_members.member_id) FROM `core_members` LEFT JOIN `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 (`members_bitoptions` & ~1 ) != 0 AND ( v.lost_pass=0 AND v.forgot_security=0 AND v.vid IS NOT NULL ) AND (temp_ban IS NULL OR temp_ban=0) AND ( (failed_login_count IS NULL OR failed_login_count=0) and (failed_mfa_attempts IS NULL OR failed_mfa_attempts=0) ) AND core_members.name <> '' IPS\Db\Exception: Unknown column 'v.lost_pass' in 'where clause' (1054) #0 C:\Users\Lenovo\Documents\web\_projects\ips46x\system\Db\Select.php(388): IPS\_Db->preparedQuery('/*ips46x::root:...', Array, true) #1 C:\Users\Lenovo\Documents\web\_projects\ips46x\system\Db\Select.php(446): IPS\Db\_Select->runQuery() #2 C:\Users\Lenovo\Documents\web\_projects\ips46x\system\Db\Select.php(370): IPS\Db\_Select->rewind() #3 C:\Users\Lenovo\Documents\web\_projects\ips46x\applications\core\modules\admin\bulkmail\bulkmail.php(260): IPS\Db\_Select->first() #4 C:\Users\Lenovo\Documents\web\_projects\ips46x\system\Dispatcher\Controller.php(90): IPS\core\modules\admin\bulkmail\_bulkmail->preview() #5 C:\Users\Lenovo\Documents\web\_projects\ips46x\applications\core\modules\admin\bulkmail\bulkmail.php(45): IPS\Dispatcher\_Controller->execute() #6 C:\Users\Lenovo\Documents\web\_projects\ips46x\system\Dispatcher\Dispatcher.php(153): IPS\core\modules\admin\bulkmail\_bulkmail->execute() #7 C:\Users\Lenovo\Documents\web\_projects\ips46x\admin\index.php(13): IPS\_Dispatcher->run() #8 {main}
Solution Stuart Silvester Posted December 31, 2021 Solution Posted December 31, 2021 Thank you, we'll make sure this is fixed in an upcoming release.
Recommended Posts