Invision Community 5: A video walkthrough creating a custom theme and homepage By Matt Thursday at 04:02 PM
dutchsnowden Posted January 11, 2022 Posted January 11, 2022 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.
Solution Daniel F Posted January 11, 2022 Solution Posted January 11, 2022 We have fixed this for the next upcoming release. dutchsnowden and SeNioR- 1 1
Marc Posted January 11, 2022 Posted January 11, 2022 4 hours ago, dutchsnowden said: Thank you? And the ETA for that? We cannot provide ETAs for releases of fixes unfortunately.
Recommended Posts