Jump to content

Error selecting bulk mail users


Go to solution Solved by Stuart Silvester,

Recommended Posts

I have created a new bulk mail with following selection:

screenshot-2021_12.13-18_39_31.thumb.png.90ebac033a96d3ed134809228e0a58fb.png

And get this SQL error upon saving:

screenshot-2021_12.13-18_41_24.thumb.png.162b8eb18a02c0818afb9758350466ed.png

 

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

  • 3 weeks later...
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...