Unable to filter Bulk Mail by Expired Subscription

[AlexWebsites]

I've tested this multiple times after disabling all 3rd party apps and plugins. I still get an error when trying to filter by:

System Log

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 core_members.name <> '' AND nexus_purchases.ps_id IS NOT NULL
IPS\Db\Exception: Unknown column 'nexus_purchases.ps_id' in 'where clause' (1054)
#0 /home/site/public_html/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*site_ipb::q...', Array, true)
#1 /home/site/public_html/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 /home/site/public_html/system/Db/Select.php(370): IPS\Db\_Select->rewind()
#3 /home/site/public_html/applications/core/modules/admin/bulkmail/bulkmail.php(260): IPS\Db\_Select->first()
#4 /home/site/public_html/system/Dispatcher/Controller.php(107): IPS\core\modules\admin\bulkmail\_bulkmail->preview()
#5 /home/site/public_html/applications/core/modules/admin/bulkmail/bulkmail.php(45): IPS\Dispatcher\_Controller->execute()
#6 /home/site/public_html/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\bulkmail\_bulkmail->execute()
#7 /home/site/public_html/admin/index.php(13): IPS\_Dispatcher->run()
#8 {main}

Backtrace

#0 /home/site/public_html/init.php(1033): IPS\_Log::log('SELECT DISTINCT...', 'uncaught_except...')
#1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception))
#2 {main}

[Marc]

Thank you for bringing this issue to our attention! I can confirm this should be further reviewed and I have logged an internal bug report for our development team to investigate and address as necessary, in a future maintenance release.

 

[AlexWebsites]

On 1/1/2024 at 11:48 AM, Marc Stridgen said:

Thank you for bringing this issue to our attention! I can confirm this should be further reviewed and I have logged an internal bug report for our development team to investigate and address as necessary, in a future maintenance release.

Any chance this fix is coming in the next maintenance release? https://invisioncommunity.com/release-notes/

[Marc]

This is still an open bug at present

[Marc]

This has now been resolved in the 4.7.16 release. Please update if you are seeing this issue. If you are then still seeing the issue, please let us know.