Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-1427

Errors API class Action method add

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9.0 (alpha)
    • Fix Version/s: 1.8.1
    • Component/s: API (A)
    • Labels:
      None
    • Environment:
      Any

      Description

      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;

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            yaap yaap
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: