Did anyone find a roll back or fix for the 8.2 Upgrade MYSQL Crash

[jrecho]

I tried upgrading to 8.2 then the system kept saying installing updates after several hours I SSH and rebooted the box. I got an error when I tried clicking on domain management.

ERROR: PleskMainDBException
MySQL query failed: Unknown column 'uid' in 'field list'

--------------------------------------------------------------------------------

0: /usr/local/psa/admin/plib/common_func.php3:216
db_query(string 'select `id`,`cr_date`,`cname`,`pname`,`login`,`account_id`,`status`,`phone`,`fax`,`email`,`address`,`city`,`state`,`pcode`,`country`,`locale`,`limits_id`,`params_id`,`perm_id`,`pool_id`,`logo_id`,`tmpl_id`,`sapp_pool_id`,`uid`,`ownership` from clients where `id`=42')
1: /usr/local/psa/admin/plib/class.Table.php:180
Table->select()
2: /usr/local/psa/admin/plib/class.cObject.php:443
cObject->fetchAttrsFromTable_()
3: /usr/local/psa/admin/plib/class.Client.php3:74
Client->Client(string '42')
4: /usr/local/psa/admin/plib/common_func.php3:2867
objectMaker(string 'Client', string '42')
5: /usr/local/psa/admin/plib/class.DomainControlForm.php:268
DomainControlForm->assign(object of type BsDomain)
6: /usr/local/psa/admin/htdocs/domains/dom_ctrl.php3:152


--------------------------------------------------

I tied opening a ticket with SW-Soft but all they care about is getting paid even though this is a defunct update. They refused to take ownership for it.

I am using :
Operating system Linux 2.4.22-1.2115.nptlsmp
Plesk version psa v8.1.1_build81070423.15 os_FedoraCore 1

If anyone can give me the ssh commands to roll back or manually upgrade it I would really appreciate it.

I saw a post stating that there are fixes but could not find one that would work I tried :


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';

But in vain
Thank you guys

 

[Amin Taheri]

I was able to fix it by forcing a reinstall of the plesk 8.1.1 rpms and then re-upgrading php/mysql.