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

Plesk 8.1.1 upgrade failed, domains down: h.miva problem

Discussion in 'Plesk for Linux - 8.x and Older' started by akamaka, Mar 28, 2007.

  1. akamaka

    akamaka New Pleskian

    Jan 19, 2004
    Likes Received:
    My upgrade form Plesk 8.1.0 to 8.1.1 has failed, now all domains come up with CentOS default page, and websrvmng -av get this error:

    websrvmng: Unable to define virtual hosts parameters: Unknown column 'h.miva' in 'field list'
    websrvmng: Unable to define virtual hosts parameters: Unknown column 'h.miva' in 'field list'

    Have anyone experienced this problem?

  2. jluerken

    jluerken Guest

    I am getting the same error message.

    SWSoft Support is currently very bad
  3. gorilych

    gorilych Guest

    It seems that upgrade failed for some reason.

    You current 'psa' database is not upgraded - this is the reason of "Unknown column 'h.miva' in 'field list'" message

    Check the following:

    1) Errors during upgrade in /tmp/autoinstaller3.log

    2) which psa is installed

    # rpm -q psa

    3) version file

    # cat /usr/local/psa/version

    4) psa db version

    # mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "select * from misc where param='version'"
  4. gorilych

    gorilych Guest

    after checking you might need to reinstall plesk.

    Preinstallation steps are:

    1) remove psa-8.1.1 rpm from rpmdb if it is installed:

    # rpm -e psa-8.1.1 --justdb --nodeps --force

    2) install psa-8.1.0 into rpmdb:

    # rpm -Uvh --justdb --nodeps --force /root/psa/PSA_8.1.0/dist../base/psa-8.1.0...rpm

    2) correct version file to have 8.1.0 version

    # echo 8.1.0 OSNAME OSVERSION 8100000 > /usr/local/psa/version

    3) correct psa db version

    # mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "update misc set val='0810' where param='version'"

    Installation (use tar.gz file for your distro, i placed here for rhel4 for example):

    # wget -c ftp://download1.swsoft.com/Plesk/Plesk8.1/RedHatEL4/psa-8.1.1-rhel4.build81070322.16.i586.rpm.tar.gz
    # tar zxf psa-8.1.1-rhel4.build81070322.16.i586.rpm.tar.gz -C swsoft/PSA_8.1.1/
    # mv /root/.my.cnf /root/.my.cnf.back
    # cd swsoft/PSA_8.1.1/dist-rpm-RedHat-el4-i386/opt/
    # rpm -Uvh ../base/* api/* backup/* migration/* updater/* --force
    # mv /root/.my.cnf.back /root/.my.cnf
  5. jluerken

    jluerken Guest


    These are the last entries

    No output after command

    | param | val |
    | version | 0810 |
  6. gorilych

    gorilych Guest

    it means that version file is empty, psa-8.1.1 rpm was registered, but psa db is still 0810

    So you will need to delete psa-8.1.1 from rpmdb and register psa-8.1.0, then fill version file and restart upgrade as described.
  7. jluerken

    jluerken Guest

    Ok I can access the 8.1.1 admin gui again, thanks.

    I am searching a way to install all installed packages again to be sure that all files are correct.

    I am getting an error message when I try to remove or add applications. I think not all .rpm files are there or correctly installed

    Do you have a command for this to force 8.1.1 to install again?
  8. jluerken

    jluerken Guest

    Ok I tested a little bit and I can install and uninstall all other applications.
    It seems that there is only a double entry for the one above.

    Is there a way to delete it manually from the db?
  9. gorilych

    gorilych Guest