upgrade to 8.1 - websites down

[summershosting]

I have upgraded from 8.0.1 to 8.1 and now it seems the document roots are wrong - or are not working - i get redhat test pages for all my sites

www.monkeydesignhouse.com for example.

Any others with same problem?

 

[summershosting]

more info:

It seems that the upgrade caused a field to be missing...

RROR: PleskMainDBException
Add To Favorites

Up Level
MySQL query failed: Unknown column 'fastcgi' in 'field list'
0: /usr/local/psa/admin/plib/common_func.php3:218
db_query(string 'select `dom_id`,`sys_user_id`,`ip_address_id`,`ssl`,`same_ssl`,`fp`,`fp_ssl`,`fp_enable`,`fp_adm`,`fp_pass`,`ssi`,`php`,`php_safe_mode`,`cgi`,`perl`,`python`,`fastcgi`,`coldfusion`,`asp`,`asp_dot_net`,`webstat`,`at_domains` from hosting where `dom_id`=10')
1: /usr/local/psa/admin/plib/class.Table.php:179
Table->select()
2: /usr/local/psa/admin/plib/class.cObject.php:447
cObject->fetchAttrsFromTable_()
3: /usr/local/psa/admin/plib/class.PHosting.php:69
PHosting->PHosting(string '10')
4: /usr/local/psa/admin/plib/common_func.php3:2828
objectMaker(string 'PHosting', string '10')
5: /usr/local/psa/admin/plib/class.DomainControlForm.php:146
DomainControlForm->assign(object of type BsDomain)
6: /usr/local/psa/admin/htdocs/domains/dom_ctrl.php3:147

Waiting on plesk support to respond to my support request.

 

[summershosting]

PLESK SUPPORT FIXED IT.....



Hello,

I found that upgrade failed:
[root@www ~]# rpm -q psa
psa-8.0.1-rhel4.build80060613.20
psa-8.1.0-rhel4.build81061129.22

I upgraded Plesk manually:
[root@www base]# rpm -Uvh --force psa-8.1.0-rhel4.build81061129.22.i586.rpm
Preparing... ########################################### [100%]
Trying to define super-server internet daemon type... xinetd
Trying to check if xinetd daemon is running... done


Congratulations!
All stages of the upgrade were successful.
Plesk is now running on your system.
To complete the system configuration process, please proceed to URL:
https://monkeydesignhouse.com:8443/ or
https://88.208.210.152:8443/
Use 'admin' and '<YOUR ADMIN PASSWORD>' as login name and password.

After that I've got it worked.
I rebuilt apache configuration:
[root@www base]# /usr/local/psa/admin/sbin/websrvmng -a -v
[root@www base]# /etc/init.d/httpd restart
Stopping httpd: [ OK ]
Starting httpd: [ OK ]

Now all should work fine.

 

[budweezy]

I found another solution to the problem. I have special databases running and wasn't able to use the manual plesk upgrade as it would kill the databases I have running.

So all you have to do to fix that error is go into your database and create the fields it's looking for.

For example if you get "MySQL query failed: Unknown column 'fastcgi' in 'field list'" when trying to click on the hosting tab in plesk. You just add "fastcgi" under the hosting table in the database. Then it works.

Those errors are actually pretty commom with Plesk upgrades. It has to do with the installer changing the database schema/tabels/fields and omitting the required info. So you get those errors.