Class: Action
Method: add
The following statement should be verified.
It doesn't match to table definition
$actionid = get_dbid('actions', 'actionid');
$sql = 'INSERT INTO actions '.
'(actionid, actionid, eventid, userid, mediatypeid, clock, sendto, subject, message, status, retries, error, nextcheck, esc_step, actiontype) '.
' VALUES ('.$actionid.','.$action['actionid'].','.$action['eventid'].','.$action['userid'].','.$action['mediatypeid'].','.
$action['clock'].','.zbx_dbstr($action['sentto']).','.zbx_dbstr($action['subject']).','.zbx_dbstr($action['message']).','.
$action['status'].','.$action['retries'].','.zbx_dbstr($action['error']).','.$action['nextcheck'].','.
$action['esc_step'].','.$action['actiontype'].' )';
CREATE TABLE `zabbix`.`actions` (
`actionid` bigint(20) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`eventsource` int(11) NOT NULL default '0',
`evaltype` int(11) NOT NULL default '0',
`status` int(11) NOT NULL default '0',
`esc_period` int(11) NOT NULL default '0',
`def_shortdata` varchar(255) NOT NULL default '',
`def_longdata` blob NOT NULL,
`recovery_msg` int(11) NOT NULL default '0',
`r_shortdata` varchar(255) NOT NULL default '',
`r_longdata` blob NOT NULL,
PRIMARY KEY (`actionid`),
KEY `actions_1` (`eventsource`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;