1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Unknown column 'host' in 'field list'

Discussion in 'Plesk for Linux - 8.x and Older' started by gizm0luvsu, Sep 11, 2006.

  1. gizm0luvsu

    gizm0luvsu Guest

    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
  2. aelbler

    aelbler Guest


    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