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

    0
     
    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
    PHP:
    ERRORPleskMainDBException      
    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 nullNULL nullobject of type UserAdminNULL nullstring '')
    7: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:515
        DashboardElement
    ->getDefaultCaption(string 'description'object of type UserAdminNULL null)
    8: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:508
        DashboardElement
    ->getCaption(string 'description'object of type UserAdminNULL null)
    9: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:1456
        DashboardElement_shortcut
    ->renderHtml(object of type UserAdminNULL null)
    10: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:584
        DashboardElement
    ->renderHtml_shortcuts(array, object of type UserAdminNULL null)
    11: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:554
        DashboardElement
    ->renderHtml_common(array, object of type UserAdminNULL null)
    12: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:1097
        DashboardElement_tab
    ->renderHtml_content(boolean trueobject of type UserAdminNULL null)
    13: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:1047
        DashboardElement_tabs
    ->renderHtml(object of type UserAdminNULL null)
    14: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:557
        DashboardElement
    ->renderHtml_common(array, object of type UserAdminNULL null)
    15: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:944
        DashboardElement_section
    ->renderHtml(object of type UserAdminNULL null)
    16: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:557
        DashboardElement
    ->renderHtml_common(array, object of type UserAdminNULL null)
    17: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:564
        DashboardElement
    ->renderHtml(object of type UserAdminNULL null)
    18: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:898
        DashboardElement_column
    ->renderHtml(object of type UserAdminNULL null)
    19: /usr/local/psa/admin/plib/dashboard/DashboardElement.php:571
        DashboardElement
    ::renderHtml_columns(array, object of type UserAdminNULL 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?
     
  2. stefano.coccia

    stefano.coccia Guest

    0
     
    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

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

    stefano.coccia Guest

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