proble update 8.1.1 to 8.2

[stefano.coccia]

I have do a update from sh and is ok but when I open my control pannel i read upster 8.1.1 and the first page (Desktop) I have a error

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`=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:74
    Client->Client(integer '1')
4: /usr/local/psa/admin/plib/common_func.php3:2867
    objectMaker(string 'Client', integer '1')
5: /usr/local/psa/admin/plib/ui/client.php:69
    plesk__client->getDisplayName()
6: /usr/local/psa/admin/plib/UIPointer.php:846
    UIPointer->getCaption(string 'description', NULL null, NULL null, object of type UserAdmin, NULL null, string '')
7: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:515
    DashboardElement->getDefaultCaption(string 'description', object of type UserAdmin, NULL null)
8: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:508
    DashboardElement->getCaption(string 'description', object of type UserAdmin, NULL null)
9: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:1456
    DashboardElement_shortcut->renderHtml(object of type UserAdmin, NULL null)
10: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:584
    DashboardElement->renderHtml_shortcuts(array, object of type UserAdmin, NULL null)
11: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:554
    DashboardElement->renderHtml_common(array, object of type UserAdmin, NULL null)
12: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:1097
    DashboardElement_tab->renderHtml_content(boolean true, object of type UserAdmin, NULL null)
13: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:1047
    DashboardElement_tabs->renderHtml(object of type UserAdmin, NULL null)
14: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:557
    DashboardElement->renderHtml_common(array, object of type UserAdmin, NULL null)
15: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:944
    DashboardElement_section->renderHtml(object of type UserAdmin, NULL null)
16: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:557
    DashboardElement->renderHtml_common(array, object of type UserAdmin, NULL null)
17: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:564
    DashboardElement->renderHtml(object of type UserAdmin, NULL null)
18: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:898
    DashboardElement_column->renderHtml(object of type UserAdmin, NULL null)
19: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:571
    DashboardElement::renderHtml_columns(array, object of type UserAdmin, NULL null)
20: /usr/local/psa/admin/plib/dashboard/Dashboard.php:197
    Dashboard::renderHtml(array, object of type UserAdmin)
21: /usr/local/psa/admin/plib/dashboard/DashboardForm.php:95
    DashboardForm->assign(array, object of type UserAdmin)
22: /usr/local/psa/admin/plib/dashboard/DashboardLocation.php:55
    DashboardLocation->accessItem(string 'GET', NULL null)
23: /usr/local/psa/admin/plib/UIPointer.php:520
    UIPointer->access(string 'GET')
24: /usr/local/psa/admin/htdocs/plesk.php:19

The site is ok, run it... If I go to update of control pannel i see that the 8.2 is update and i can update only 8.2.1 why?

 

[stefano.coccia]

I think that the problem is thata I work whit 8.2 but the table of mysql is 8.1.1
there new table to 8.2 that not are present in to 8.1.1 and go to crash... I have create the table and i see the desktop but I'dont know how much record/table there are...

 

[Satoriya]

Hi,

You can check whether Plesk was upgraded completely.
Check Plesk package:
# rpm -q psa

If you will 2 packages - it means that upgrade was failed for some rasons;

Check current Plesk version:
# cat $PRODUCT_ROOT_D/version

Also, take a look at this article:
http://kb.swsoft.com/en/951

Then you need to check "psa" database version. Most probably it was not upgradede too:
# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
mysql> select * from version;

Then I suggest you to check autoinstaller log and find out exact reason of failed upgrade:
# less autoinstaller3.log

Eleminate this issue and forcibly run Plesk upgrade manually.

 

[stefano.coccia]

I have do a upgrate to 8.2.1 and now work correctly tnx