Jump to content

Featured Replies

Posted

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

Could contain: Page, Text

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}

Solved by Marc

Go to solution

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.

 

  • 2 weeks later...
  • 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/

  • 1 month later...
  • 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.

Recently Browsing 0

  • No registered users viewing this page.