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?
PandoraFMS 3.0 Scheduled Downtime SQL Error
JeeSee · 17 feb 2010, 12:44 · 2 mensajes · 55 visitas
- Inicio del debate
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.
