Unknown column 'host' in 'field list'

[gizm0luvsu]

ok i just installed plesk on a fresh server using ubuntu. Everything installed good but when ever i go to install accts
or finish up anything i get this error

mysql query failed: Unknown column 'host' in 'field list' does any one know how to fix that

 

[aelbler]

maybe

check mysqldb "psa", table "exp_event", if there are the fields "id, source, event_type, event_time, obj_class, obj_id, host, user, flushed".
If not implement sql:

--
-- Table structure for table `exp_event`
--

DROP TABLE IF EXISTS `exp_event`;
CREATE TABLE `exp_event` (
`id` bigint(10) unsigned NOT NULL auto_increment,
`source` enum('pa','plesk') default NULL,
`event_type` enum('started','stopped','created','updated','deleted','status_changed','terminated','flushed','installed','uninstalled','siteapp_added','siteapp_removed','expired','exceeded') NOT NULL default 'started',
`event_time` datetime NOT NULL default '0000-00-00 00:00:00',
`obj_class` enum('license','service','ip_address','admin_info','siteapp','session_preferences','client','client_limits','client_status','client_prefs','client_perms','client_ip_pool','client_limit_traffic','client_limit_size','domain','domain_limits','domain_user','domain_alias','domain_limit_traffic','domain_limit_size','domain_status','phosting','fhosting','db_server','domain_alias','subdomain','mailname','webuser','maillist','dns_zone','mailname_antivirus','mailname_spamfilter','mailname_mailgroup','mailname_autoresponder','mailname_attachment','dashboard_preset','dashboard_preset_type','dashboard_preset_name') NOT NULL default 'license',
`obj_id` varchar(255) character set utf8 NOT NULL default '',
`host` varchar(255) character set utf8 NOT NULL default '',
`user` varchar(255) character set ascii NOT NULL default '',
`flushed` enum('true','false') NOT NULL default 'false',
PRIMARY KEY (`id`)
) TYPE=InnoDB;

--
--
--

this worked for me after damaged upgrade