After Update Problems ..

[Silent.aT]

Hi, a friend of mine did some plesk updates, and after he did that, he wasnt able to view the domains anymore ...

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

Additionally, an exception has occurred while trying to report this error: PleskMainDBException
MySQL query failed: Unknown column 'guid' in 'field list'

0: /usr/local/psa/admin/plib/common_func.php3:218
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`,`guid` from clients where `id`=1')
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:69
Client->Client(integer '1')
4: /usr/local/psa/admin/plib/common_func.php3:2875
objectMaker(string 'Client', integer '1')
5: /usr/local/psa/admin/plib/class.Manager.php:679
Manager->createMainObject(integer '2')
6: /usr/local/psa/admin/plib/class.Manager.php:126
Manager->Manager(integer '3', integer '1')
7: /usr/local/psa/admin/htdocs/domains/domains.php3:68


i tried to insert manuelly the DB Update for plesk 8.3.0 but it isn't working .. i hope u can help me ..

cYa Silent.aT

 

[Hedgren]

Hi, it indicates of the broken Plesk upgrade.
Check how many psa-8.2.0* packages are installed:
> rpm -qa | grep psa-8.2.0- | grep -v locale
Your current Plesk version:
> cat /usr/local/psa/version

Try downloading Plesk 8.3 autoinstaller for your OS from :
http://www.parallels.com/en/download/plesk83/
and run it like described in the Release Notes (found on the same page, as well as here: ftp://download1.parallels.com/Plesk/Plesk8.3/
and let it install base packages of Plesk.
If it does not sort it out, then I guess, there is no easy solution, and it should be looked into. Otherwise, if you have Plesk backup, I suppose making a clean 8.3 install and then restoring the data is good idea.