Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted December 29, 20231 yr 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}
January 1, 20241 yr 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.
January 15, 20241 yr Author 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/
March 14, 2024Mar 14 Solution 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.