Bug in code

[Callum MacGregor]

Line 1224 in applications\nexus\sources\Fraud\Rule.php is currently:

'subscriptions'		=> iterator_to_array( \IPS\Db::i()->select( 'p_id', 'nexus_member_subscription_packages' ) ),

But should be

'subscriptions'		=> iterator_to_array( \IPS\Db::i()->select( 'sp_id', 'nexus_member_subscription_packages' ) ),

Trying to check my anti-fraud rules in the admincp results in the following exception due to the this faulty code:

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

 

[Daniel F]

Thanks, I have submitted a fix for an upcoming release.