Pandora FMS Community

PandoraFMS 3.0 Scheduled Downtime SQL Error

JeeSee · 17 feb 2010, 12:44 · 2 mensajes · 55 visitas

  1. Inicio del debate

    When configuring Scheduled Downtime FMS results in a SQL Error: SQL error: Unknown column 'id_group' in 'where clause' ('SELECT * FROM tplanned_downtime WHERE id_group IN (1,12,8,4,9,2,10,13,11)') in /srv/www/htdocs/pandora_console/include/functions_db.php on line 1788 This error occurs when clicking on "Scheduled Downtime" menu item under Manage Agents. It isn't possible to create a new Scheduled downtime. What can I do to create new scheduled downtimes for my servers?

  2. Seems you have an outdated tplanned_downtime table version ¿?, what version are you running ?. Schema for this table should be something like: CREATE TABLE IF NOT EXISTS `tplanned_downtime` (   `id` MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT,   `name` VARCHAR( 100 ) NOT NULL,   `description` TEXT NOT NULL,   `date_from` bigint(20) NOT NULL default '0',   `date_to` bigint(20) NOT NULL default '0',   `executed` tinyint(1) UNSIGNED NOT NULL default 0,   `id_group` mediumint(8) unsigned NULL default 0,   PRIMARY KEY (  `id` ) ) ENGINE = InnoDB DEFAULT CHARSET=utf8; You can see your current version in the DB Interface extension doing a "describe tplanned_downtime". If its different, just do a "DROP table tplanned_downtime" and later copy the creation information above this text.

    When configuring Scheduled Downtime FMS results in a SQL Error: SQL error: Unknown column 'id_group' in 'where clause' ('SELECT * FROM tplanned_downtime WHERE id_group IN (1,12,8,4,9,2,10,13,11)') in /srv/www/htdocs/pandora_console/include/functions_db.php on line 1788 This error occurs when clicking on "Scheduled Downtime" menu item under Manage Agents. It isn't possible to create a new Scheduled downtime. What can I do to create new scheduled downtimes for my servers?

Entra en tu cuenta para publicar.