How to fix a Broken Plesk upgrade from 8.1.1 -> 8.2.0

[speedy]

If your one of those unfortunate people who used the Plesk Updater from the UI and it didnt work - resulting in you now having a semi working install, this thread is for you.

How to fix the install and continue the upgrade manually
1) remove 'caching-nameserver' package if it is installed:
# rpm -e caching-nameserver
2) alter the database of Plesk adding the field if it is missing:
# mysql -uadmin -p`cat /etc/psa/.psa.shadow`
mysql> ALTER TABLE psa.subdomains ADD INDEX dom_id_2 (`dom_id`);
3) rename 'root' MySQL user if it exists to other name before upgrade
and rename it back to 'root' after:
mysql> UPDATE mysql.user SET user='ROOT' WHERE user='root';

then perform the following command (please correct the path if needed)
cd /root/psa/PSA_8.2.0/dist-rpm-FedoraCore-2-i386/base/
rpm -Uvh *

and then rename ROOT back to root:
mysql> UPDATE mysql.user SET user='root' WHERE user='ROOT';


How to ROLL BACK to 8.1.1

(please correct the path if needed)
cd /root/swsoft/PSA_8.1.1/dist-rpm-RedHat-el4-i386/base/
rpm -U --force *.rpm

[ingexthinee]

Now all is clear, thanks for the help in this question.