• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Yet another person complaining about the 8.2 upgrade

B

Blacksimon

Guest
EDIT: I ran the fix for manual update to 8.2, but it was for fedoracore 2 and we are running 1.

I get the same error



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


I know nothing about linux, so now im stuck.

I get this error upon clicking on almost anything:

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`=37')
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 '37')
4: /usr/local/psa/admin/plib/common_func.php3:2867
objectMaker(string 'Client', string '37')
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 dont care about fixing the problem, i just want to go back to what I had before. Is there anything that can reverse the upgrade?

I logged into plesk finding that there were 2 updates, 8.1 and 8.2
I did 8.1 and when i went to 8.2 It said updating, after a day of waiting, I rebooted the server and now im getting the above errors.

Any help would be great, thanks in advance.
 
There are already several fixes posted arround the forum for just about all 8.2 upgrade issues - either to fix 8.2 or to revert back to 8.1

Use the search button and find them.

Also, if you know nothing about linux, then you have no business being a sysadmin and I would recomend finding some one who does know linux to run your business.
 
Im not the sysadmin, im only here to find a fix for him.

I searched and found a fix for suse but couldnt find anything for FedoraCore 1, does it really matter?



I seem to have found this:
Apparently its for Fd core 2, ill pass it along to our linux guy, hopefully it will work

Hello,


As for the first question regarding Plesk upgrade through Plesk updater actually there is some issue to update Plesk via autoinstaller, our developers are working on it. So it would be better to upgrade Plesk manually. I advise you to do the following in order to upgrade Plesk from 8.1 to 8.2:

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

As for second question I'm going to pass it to our second line Team, they will help you.
 
Back
Top