Plesk 9.0.1 MySQL Error Backup Manager after Upgrade

[Christian Vogt]

Hello, I have a problem with the backup manager.

First I am using Parallels Plesk Panel v9.0.1_build90090127.18 os_Debian 4.0 (Linux 2.6.18-5-amd64).

If I want to create a planned backup, I get the following error report:

MySQL query failed: Unknown column 'backup_time' in 'field list'

I deinstalled the backup manager already and again installed was, so as to read it in some contributions, however, the missing column is not after that available either. Somebody can tell me the MySQL Command, so that I can add the missing column alternative one other solution way's call?

Many thanks

German answers are preferred. ;-)

 

[Christian Vogt]

Anyone an idea?

 

[Christian Vogt]

After edititing the Database with:

ALTER TABLE `BackupsScheduled` CHANGE `backup_time` `backup_time` TIME NOT NULL DEFAULT '00:00:00'

I get the next error:

MySQL query failed: Unknown column 'backup_day' in 'field list'

Anyone who can send my a complete dump of the table BackupsScheduled???

 

[Christian Vogt]

Everything is cool now. Thx for the PM

--
-- Tabellenstruktur für Tabelle `BackupsScheduled`
--
-- Erzeugt am: 31. März 2009 um 14:35
--

DROP TABLE IF EXISTS `BackupsScheduled`;
CREATE TABLE IF NOT EXISTS `BackupsScheduled` (
`id` int(10) unsigned NOT NULL auto_increment,
`obj_id` int(10) unsigned NOT NULL,
`obj_type` enum('server','reseller','client','domain') NOT NULL,
`repository` enum('local','ftp') NOT NULL default 'local',
`last` datetime default NULL,
`period` int(10) unsigned NOT NULL,
`active` enum('true','false') NOT NULL,
`processed` enum('true','false') NOT NULL,
`rotation` int(11) NOT NULL default '0',
`prefix` varchar(255) character set utf8 default NULL,
`email` varchar(255) character set utf8 default NULL,
`split_size` int(10) unsigned NOT NULL default '0',
`suspend` enum('true','false') NOT NULL default 'false',
`with_content` enum('true','false') NOT NULL default 'true',
`backup_day` int(10) unsigned NOT NULL default '0',
`backup_time` time NOT NULL default '00:00:00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;