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

huh? database error when accessing my domains

Discussion in 'Plesk for Windows - 8.x and Older' started by builtnetwork, Aug 9, 2005.

  1. builtnetwork

    builtnetwork Guest

    0
     
    Hello all, first time poster, long time forum reader.
    I've searched the forums and net extensively and can't find a solution, so here it goes:

    I get the following error when I try to add, delete or disable a domain:

    Unable to activate/deactivate domain: domainmng failed:
    Run-Time error: Can't query SELECT h.dom_id, d.name, d.htype, d.displayName, d.cl_id, ipa.ip_address, c.email, u.login, a.password, h.fp, h.fp_ssl, h.fp_enable, h.fp_adm, h.fp_pass, h.coldfusion,h.ssi, h.ssi_html, h.php, h.php_isapi, h.cgi, h.perl, h.asp, h.asp_dot_net, h.python, h.ssl, h.webstat, h.at_domains,cert.name cert_name, cert.pvt_key, cert.cert, cert.ca_cert FROM hosting h, domains d, clients c, IP_Addresses ipa, certificates cert, sys_users u LEFT OUTER JOIN accounts a ON a.id = u.account_id WHERE u.id = h.sys_user_id AND h.dom_id = d.id AND d.cl_id = c.id AND h.ip_address_id = ipa.id AND ipa.ssl_certificate_id = cert.id AND (d.id = '5'): MySQL error 1054:Unknown column 'h.ssi_html' in 'field list'")

    I had recently reinstalled IIS and attempted to reinstall Plesk 7.5.4 over an old installation (7.5.3) in order to preserve email and domain setups. Email boxes and settings carried over and work fine.... but the domain stuff is still whacked.

    Any help/advice would be greatly appreciated.

    Mars
     
  2. nimal_ds

    nimal_ds Guest

    0
     
    I found this somewhere on this forum via Google, its complicated. hah.

    anyway, you have to manually modify the mysql db:

    ALTER TABLE `hosting` ADD COLUMN `ssi_html` enum('false', 'true') NOT NULL
    default 'false' AFTER `ssi`;

    ALTER TABLE `subdomains` ADD COLUMN `ssi_html` enum('false', 'true') NOT NULL
    default 'false' AFTER `ssi`;

    ALTER TABLE `web_users` ADD COLUMN `ssi_html` enum('false', 'true') NOT NULL
    default 'false' AFTER `ssi`;
     
  3. builtnetwork

    builtnetwork Guest

    0
     
    Thanks for the suggestion... but the only way I was able to fix it was (sigh) a complete uninstall and reinstall... and when i say complete, I really mean complete, as in removing all content and leftover directories and files.

    I *really* hope I never have to do that again.
     
Loading...