Sonya* Posted December 13, 2021 Share 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} Link to comment Share on other sites More sharing options...
Solution Stuart Silvester Posted December 31, 2021 Solution Share Posted December 31, 2021 Thank you, we'll make sure this is fixed in an upcoming release. Link to comment Share on other sites More sharing options...
Recommended Posts