PandoraFMS 3.0 Scheduled Downtime SQL Error

[Sancho]

Like it

Up

0

Down

Drop it

::

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?