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

websrvmng: Unable to define virtual hosts parameters: Unknown column 'h.fastcgi' in '

Discussion in 'Plesk for Linux - 8.x and Older' started by AS-N, Dec 1, 2006.

  1. AS-N

    AS-N New Pleskian

    22
    57%
    Joined:
    Dec 1, 2006
    Messages:
    12
    Likes Received:
    0
    Hello,

    during an autoupdate from 8.0.1 to 8.1.0 my mysql server was crashing down, so I had to install the Plesk update by hand.
    But it seems that some db tables or some files are missing.
    The db I have checked with an other installation, and it should work now.
    But if I try to run

    /usr/local/psa/admin/bin/websrvmng -a -v

    I always get this message:

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

    What is missing or what is wrong and where can I find it?

    Thanks for you help.

    Ciao
    André
     
  2. nb__

    nb__ Guest

    0
     
    It's bad idea to use manual installation after failed upgrade. Your psa database was not upgraded correctly. Probably you should install psa on clean server and compare structure of both DBs on servers.
     
  3. akamaka

    akamaka New Pleskian

    23
    40%
    Joined:
    Jan 19, 2004
    Messages:
    21
    Likes Received:
    0
    Same problem at mine. Have you a fix for this?

    Thanks
     
  4. w0ei

    w0ei New Pleskian

    22
    23%
    Joined:
    Dec 3, 2006
    Messages:
    8
    Likes Received:
    0
  5. AS-N

    AS-N New Pleskian

    22
    57%
    Joined:
    Dec 1, 2006
    Messages:
    12
    Likes Received:
    0
    Hello,

    problem solved, I have checked the database another time and I've found two missing fields in the tables hosts and subdomains.

    :D

    Ciao
    André
     
  6. w0ei

    w0ei New Pleskian

    22
    23%
    Joined:
    Dec 3, 2006
    Messages:
    8
    Likes Received:
    0
    Which missing fields? And table 'hosts' doesn't exist in my PSA database...

    So what exactly did you do to fix it?
     
  7. AS-N

    AS-N New Pleskian

    22
    57%
    Joined:
    Dec 1, 2006
    Messages:
    12
    Likes Received:
    0
    Hello,

    sorry, it was the table `hosting` and it was the fiel `fastcgi` missing there.
    But the problems are still here, now the statistics doesn't work, on no one machine I have.

    :(
     
  8. w0ei

    w0ei New Pleskian

    22
    23%
    Joined:
    Dec 3, 2006
    Messages:
    8
    Likes Received:
    0
    Sounds like the same problem I'm having: everything is upgraded to 8.1 except the PSA database...
     
  9. AS-N

    AS-N New Pleskian

    22
    57%
    Joined:
    Dec 1, 2006
    Messages:
    12
    Likes Received:
    0
    Maybe it is possible to get the database structure of a working psa db?
    So we can check it with our versions.

    Ciao
    André
     
  10. dominiosenlinea

    dominiosenlinea Guest

    0
     
    I am getting the following on a linux box:

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

    Did anyone find a solution?
     
Loading...