1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

proble update 8.1.1 to 8.2

Discussion in 'Plesk for Linux - 8.x and Older' started by stefano.coccia, Nov 7, 2007.

  1. stefano.coccia

    stefano.coccia Guest

    I have do a update from sh and is ok but when I open my control pannel i read upster 8.1.1 :confused: and the first page (Desktop) I have a error
    MySQL query failed
    Unknown column 'uid' in 'field list'

    0: /usr/local/psa/admin/plib/common_func.php3:216
    (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
    2: /usr/local/psa/admin/plib/class.cObject.php:443
    3: /usr/local/psa/admin/plib/class.Client.php3:74
    ->Client(integer '1')
    4: /usr/local/psa/admin/plib/common_func.php3:2867
    (string 'Client'integer '1')
    5: /usr/local/psa/admin/plib/ui/client.php:69
    6: /usr/local/psa/admin/plib/UIPointer.php:846
    ->getCaption(string 'description'NULL nullNULL nullobject of type UserAdminNULL nullstring '')
    7: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:515
    ->getDefaultCaption(string 'description'object of type UserAdminNULL null)
    8: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:508
    ->getCaption(string 'description'object of type UserAdminNULL null)
    9: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:1456
    ->renderHtml(object of type UserAdminNULL null)
    10: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:584
    ->renderHtml_shortcuts(array, object of type UserAdminNULL null)
    11: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:554
    ->renderHtml_common(array, object of type UserAdminNULL null)
    12: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:1097
    ->renderHtml_content(boolean trueobject of type UserAdminNULL null)
    13: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:1047
    ->renderHtml(object of type UserAdminNULL null)
    14: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:557
    ->renderHtml_common(array, object of type UserAdminNULL null)
    15: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:944
    ->renderHtml(object of type UserAdminNULL null)
    16: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:557
    ->renderHtml_common(array, object of type UserAdminNULL null)
    17: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:564
    ->renderHtml(object of type UserAdminNULL null)
    18: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:898
    ->renderHtml(object of type UserAdminNULL null)
    19: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:571
    ::renderHtml_columns(array, object of type UserAdminNULL null)
    20: /usr/local/psa/admin/plib/dashboard/Dashboard.php:197
    ::renderHtml(array, object of type UserAdmin)
    21: /usr/local/psa/admin/plib/dashboard/DashboardForm.php:95
    ->assign(array, object of type UserAdmin)
    22: /usr/local/psa/admin/plib/dashboard/DashboardLocation.php:55
    ->accessItem(string 'GET'NULL null)
    23: /usr/local/psa/admin/plib/UIPointer.php:520
    ->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?
  2. stefano.coccia

    stefano.coccia Guest

    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...
  3. Satoriya

    Satoriya Guest


    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:

    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.
  4. stefano.coccia

    stefano.coccia Guest

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