Anti-Fraud Rules tab in ACP giving error on click

[David..]

SELECT p_id FROM `ipb__nexus_member_subscription_packages` AS `nexus_member_subscription_packages`
IPS\Db\Exception: Unknown column 'p_id' in 'field list' (1054)
#0 /public_html/system/Db/Select.php(388): IPS\_Db->preparedQuery()
#1 /public_html/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 /public_html/applications/nexus/sources/Fraud/Rule.php(1224): iterator_to_array()
#4 /public_html/applications/nexus/sources/Fraud/Rule.php(102): IPS\nexus\Fraud\_Rule->isSubsetOf()
#5 /public_html/system/Patterns/ActiveRecord.php(335): IPS\nexus\Fraud\_Rule->get__description()
#6 /public_html/system/Node/Controller.php(223): IPS\Patterns\_ActiveRecord->__get()
#7 /public_html/system/Node/Controller.php(113): IPS\Node\_Controller->_getRow()
#8 /public_html/system/Helpers/Tree/Tree.php(130): IPS\Node\_Controller->_getRoots()
#9 /public_html/system/Node/Controller.php(99): IPS\Helpers\Tree\_Tree->__toString()
#10 /public_html/applications/nexus/modules/admin/payments/fraud.php(66): IPS\Node\_Controller->manage()
#11 /public_html/system/Dispatcher/Controller.php(118): IPS\nexus\modules\admin\payments\_fraud->manage()
#12 /public_html/system/Node/Controller.php(69): IPS\Dispatcher\_Controller->execute()
#13 /public_html/applications/nexus/modules/admin/payments/fraud.php(54): IPS\Node\_Controller->execute()
#14 /public_html/applications/nexus/modules/admin/payments/paymentsettings.php(81): IPS\nexus\modules\admin\payments\_fraud->execute()
#15 /public_html/system/Dispatcher/Controller.php(118): IPS\nexus\modules\admin\payments\_paymentsettings->__call()
#16 /public_html/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#17 /public_html/Prevail/index.php(13): IPS\_Dispatcher->run()
#18 {main}

 

Does anyone else have the same issue?

[Jim M]

There is a call here that is making incorrect queries on your instance. You will want to:

• Fix items highlighted in ACP -> Support. You have a few modified files, database errors, patches available, etc...
• If that does not help, disable all third party applications/plugins then try again. There are a lot of hooks being loaded there on your installation.