Jump to content

Bulk email filter editing error


dutchsnowden
 Share

Go to solution Solved by Daniel F,

Recommended Posts

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?

image.thumb.png.87967475a678f69b73e4638ca129c3cb.png

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.

image.png.ce107ff4b28afbc31d5aaebf65df0dd0.png

Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

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