Plesk autoupdate failure

[Thomas A.]

I really need help on this one. Some days ago I wanted to update Plesk from the graphic interface. So I went there and choose the latest version of Plesk 9 available (maybe it was 9.3.2 ... I can not remember well).

Anyway, I receive an email saying it was successful. But then I received another email about a failure in the process. I really have no idea on how to solve this problem. Now when I connect to Plesk I see the following error:

MySQL query failed: Table 'psa.GL_settings' doesn't exist

0: common_func.php3:168
db_query(string 'SELECT `value` FROM GL_settings WHERE param = 'enabled'')
1: common_func.php3:215
db_query_ex(string 'SELECT `value` FROM GL_settings WHERE param = '?(paramName)'', array)
2: GreyListManager.php:1079
GreyListManager->_getSetting(string 'enabled', string 'false')
3: GreyListManager.php:113
GreyListManager->isCheckingEnabled()
4: SpamFilter.php:1313
SpamFilter::getGreyListingStatus()
5: SpamFilterUIPointer.php:43
SpamFilterUIPointer->checkGreyListing()
6: SpamFilterUIPointer.php:16
SpamFilterUIPointer->validateItem(object of type UserAdmin)
7: UIPointer.php:1123
UIPointer->validate()
8: elements.php3:174
uipointer_button_desc(object of type plesk__server__spam_filter, object of type UserAdmin, NULL null, string '', array)
9: elements.php3:283
uipointer_link_href(object of type plesk__server__spam_filter, object of type UserAdmin, NULL null, string '', array)
10: DashboardElement.php:1137
DashboardElement_footer->renderHtml(object of type UserAdmin, NULL null)
11: DashboardElement.php:1052
DashboardElement_section->renderHtml(object of type UserAdmin, NULL null)
12: DashboardElement.php:640
DashboardElement->renderHtml_common(array, object of type UserAdmin, NULL null)
13: DashboardElement.php:647
DashboardElement->renderHtml(object of type UserAdmin, NULL null)
14: DashboardElement.php:1013
DashboardElement_column->renderHtml(object of type UserAdmin, NULL null)
15: DashboardElement.php:654
DashboardElement::renderHtml_columns(array, object of type UserAdmin, NULL null)
16: Dashboard.php:251
Dashboard::renderHtml(object of type DashboardPreset, object of type UserAdmin)
17: DashboardForm.php:164
DashboardForm->assign(object of type DashboardPreset, object of type UserAdmin)
18: DashboardLocation.php:39
DashboardLocation->accessItem(string 'GET', NULL null)
19: UIPointer.php:596
UIPointer->access(string 'GET')
20: plesk.php:38

Here is the content of the log report I received by email:

Plesk autoupdate failure report

Parallels Products Installer 3.5.0 (build at 2009-08-17 16:48 svn rev. 0) started at (timezone CET) Tue Mar 13 00:14:49 2012
Command line args: /usr/local/psa/admin/bin/autoinstaller --enable-xml-output --source-type=plesk --target=/root/psa --select-release-id=PLESK_9_3_0 [email protected] --install-component=base --install-component=api --install-component=backup-ded --install-component=pmm-ded --install-component=java --install-component=psa-firewall --install-component=psa-vpn --install-component=psa-fileserver --install-component=watchdog --install-component=cs-gs --install-component=battlefield --install-component=bf2 --install-component=spamassassin --install-component=kav --install-component=atis

Try to find rcfile...
Autoinstaller rcfile not found.
Opsys detected as: os_vendor=CentOS os_name=Linux version=5.7 arch=i686 environment=~empty
Final opsys (with overriding) is: os_vendor=CentOS os_name=Linux version=5.7 arch=i686 environment=~empty
Checking hostname is sucessfull.
Downloading the file products.inf3: 100% done.
Downloading the file plesk.inf3: 10%..20%..30%..40%..50%..60%..70%..80%..90%..100% done.
Downloading the file ppsmbe.inf3: 18%..28%..39%..49%..59%..70%..80%..90%..100% done.

...

Trying to got legacy variables... done
config updated
===> Updated /etc/psa/psa.conf
Trying to save legacy variables... done
Trying to generate default Plesk SSL Certificate... default certificate already exists
done
Installing the package psa-logrotate-3.7-cos5.build93091230.07.i586
Installing the package psa-php5-configurator-1.5.2-cos5.build93100518.16.noarch
===> configuring php5 using /etc/php.ini file
Trying to set memory limit to 32M... done
Trying to add '.' to 'include_path'... nothing to be done
done
Trying to set 'short_open_tag' to On... done
Trying to set 'file_uploads' to On... done
Trying to set 'safe_mode' to On... done
Installing the package psa-selinux-9.3.0-cos5.build93091230.07.noarch
Trying to install Plesk specific permissions... ***** upgrade problem report *****
set ftp_home_dir flag

getsebool: SELinux is disabled
done
Trying to reload service syslog... syslogd (pid 4228) is running...
klogd (pid 4231) is running...
Reloading syslogd...[ OK ]
Reloading klogd...[ OK ]
done
Plesk 9.3.0 rules already installed
Plesk 9.3.0 rules already installed
Plesk 9.3.0 rules already installed
Installing the package psa-manual-custom-skin-guide-9.0.1-0.279670.noarch
Installing the package psa-mail-driver-common-9.3.0-cos5.build93110721.15.i586
mv: cannot stat `/var/qmail/control/spf*': No such file or directory
Trying to executing mail_restore to synchronize mail server settings and Plesk Database... Number of arguments is invalid.
Number of arguments is invalid.
Unable to dump server-wide black/white lists into GreyListing database
done
Installing the package psa-pylibplesk-9.3.0-cos5.build93091230.07.i586
Installing the package psa-proftpd-1.3.1-cos5.build93091230.07.i586
Checking for the system groups and users necessary for ftp server...
Checking for the group 'psaftp'...
Group 'psaftp' already exists

Checking for the user 'psaftp'...
User 'psaftp' already exists

Installing the package psa-proftpd-xinetd-1.3.1-cos5.build93091230.07.i586
4425
Reloading configuration: [ OK ]
Installing the package psa-hotfix2-9.3.0-9.3.0-cos5.build93110721.15.i586, psa-9.3.0-cos5.build93091230.07.i586, psa-libpam-plesk-9.3.0-cos5.build93091230.07.i586, psa-locale-base-en-US-9.3.0-2009121411.noarch, psa-api-9.3.0-cos5.build93091230.07.noarch, plesk-skins-9.3.0-0.287499.noarch, psa-migration-manager-9.3.0-cos5.build93091230.07.i586, psa-backup-manager-9.3.0-cos5.build93091230.07.i586, psa-updates-9.3.0-cos5.build93110721.15.noarch, psa-appvault-updates-9.3.0-cos5.build93091230.07.noarch, psa-api-rpc-9.3.0-cos5.build93091230.07.noarch, plesk-billing-6.0.4-20090625.11.noarch

...

Checking for the system groups and users necessary for Apache...
Checking for the group 'apache'...
Group 'apache' already exists

Checking for the user 'apache'...
User 'apache' already exists

Trying to start service mysqld... done
Trying to establish test connection... connected
done
===> Preparing upgrade
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.dump.gz
Stopping Plesk... done
Checking that /usr/local/psa/bin/chrootsh registered as login shell...
/usr/local/psa/bin/chrootsh already registered as a login shell

Stopping Plesk... done
Trying to register service xinetd... using /sbin/chkconfig
done
Setting the default locale
The default locale is set to en-US (ENGLISH, UNITED STATES)


===> Installing rbash
Checking that /bin/rbash registered as login shell...
/bin/rbash is already registered as login shell

===> Installing psa database
Trying to start service mysqld... done
Trying to define valid mysql credentials... Trying to establish test connection... connected
done
Trying to start service mysqld... done
Trying to establish test connection... connected
done
Trying to check psa database... Trying to find psa database... version is 0900

ERROR while trying to execute SQL query, the query was: DELETE FROM mysql.user WHERE user = ''; FLUSH PRIVILEGES;
Check the error reason(see log file: /tmp/psa_9.3.0_cos5.build93091230.07_upgrade.120313.00.17.log), fix and try again

Aborting...

error: %post(psa-9.3.0-cos5.build93091230.07.i586) scriptlet failed, exit status 1
Trying to install PAM module... done

The installed Plesk release (90081222.11) does not require this hotfix release (9.3.0).
Thank you for choosing our products!

Trying to start service mysqld... done
Trying to establish test connection... connected
done
Trying to establish test connection... connected
Trying to upgrade persistent database storage... done
Trying to start service mysqld... done
Trying to establish test connection... connected
done
Trying to establish test connection... connected
Trying to create temporary database storage... done
Trying to upgrade persistent database storage... done
Trying to start service mysqld... done
Trying to establish test connection... connected
done
Trying to establish test connection... connected
Trying to create temporary database storage... done
Trying to upgrade persistent database storage... done
Restarting SWsoft control panels server... not running. [ OK ]
ERROR: An error occurred during installation of packages.
Attention! Your software might be inoperable.
Please, contact product technical support.

Please help me solve this, I have no idea and my websites are down during that time. Thank you in advance!!