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

[AS-N]

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é

 

[nb__]

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.

 

[akamaka]

Same problem at mine. Have you a fix for this?

Thanks

 

[w0ei]

I also have the same problem, see: http://forum.sw-soft.com/showthread.php?s=&threadid=38336 ...

 

[AS-N]

Hello,

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



Ciao
André

 

[w0ei]

Originally posted by AS-N
Hello,

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



Ciao
André

Which missing fields? And table 'hosts' doesn't exist in my PSA database...

So what exactly did you do to fix it?

 

[AS-N]

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.

 

[w0ei]

Originally posted by AS-N
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.

Sounds like the same problem I'm having: everything is upgraded to 8.1 except the PSA database...

 

[AS-N]

Maybe it is possible to get the database structure of a working psa db?
So we can check it with our versions.

Ciao
André

 

[dominiosenlinea]

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?