Query:
INSERT INTO `sys_alerts`(`unit`, `action`, `handler_id`) VALUES('', 'add', '94')
INSERT INTO `sys_alerts`(`unit`, `action`, `handler_id`) VALUES('', 'add', '94')
Mysql error:
Duplicate entry 'add-94' for key 2
Duplicate entry 'add-94' for key 2
Found error in the file '/modules/boonex/wall/classes/BxWallDb.php' at line 37.
Called 'query' function with erroneous argument #0.
Called 'query' function with erroneous argument #0.
foreach($aData['alerts'] as $aAlert)
$this->query("INSERT INTO `sys_alerts`(`unit`, `action`, `handler_id`) VALUES('" . $aAlert['unit'] . "', '" . $aAlert['action'] . "', '" . $iHandlerId . "')");
}
I have no clue why it's trying to add the same thing twice. I also don't know what table it's getting the information from to place in the sys_alerts table.
Any one have a fix for this one ?
EDIT:
forgot to add this happens with the spy module as well. (all other modules seem to be ok)
Query:
INSERT INTO `sys_alerts` SET `unit` = '', `action` = 'add', `handler_id` = '95'
INSERT INTO `sys_alerts` SET `unit` = '', `action` = 'add', `handler_id` = '95'
Mysql error:
Duplicate entry 'add-95' for key 2
Duplicate entry 'add-95' for key 2
Found error in the file '/modules/boonex/spy/classes/BxSpyDb.php' at line 249.
Called 'query' function with erroneous argument #0.
Called 'query' function with erroneous argument #0.
