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

Missing Columns in the MySQL DB After Upgrade from 8.2 to 8.6

Discussion in 'Plesk for Windows - 8.x and Older' started by datThomas, Oct 5, 2008.

  1. datThomas

    datThomas Guest

    0
     
    I upgraded to 8.6 from 8.2 this weekend. (I installed the .4 patch as well)

    I now get missing column errors all over the place.

    When running the Backup Utility I get the following error:

    Can't query SELECT `last_error`,`id`,`admin_password`,`type`,`admin_login`,`parameters_id`,`port`,`host` FROM `DatabaseServers`: MySQLDatabaseProvider error 1054:Unknown column 'parameters_id' in 'field list'



    When clicking on an email account the following error:
    DB query failed: Unknown column 'disk_usage' in 'field list'
    ---------------------- Debug Info -------------------------------
    0: plib\common_func.php3:243
    db_query(string 'select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `mbox_quota`, `disk_usage`, `dom_id` from `mail` where `id`=20')
    1: plib\class.Table.php:189
    Table->select()
    2: plib\class.cObject.php:458
    cObject->fetchAttrsFromTable_()
    3: plib\mail\MailName.php:103
    Mailname->Mailname(integer '20')
    4: plib\common_func.php3:2929
    objectMaker(string 'Mailname', integer '20')
    5: htdocs\domains\mail\mail_name_edit.php:23


    After clicking on a domains databases icon I get:
    DB query failed: Unknown column 'server_version' in 'field list'
    ---------------------- Debug Info -------------------------------
    0: plib\common_func.php3:243
    db_query(string 'select `id`, `host`, `port`, `type`, `admin_login`, `admin_password`, `last_error`, `server_version`, `parameters_id` from `DatabaseServers` where `id`=1')
    1: plib\class.Table.php:189
    Table->select()
    2: plib\class.cObject.php:458
    cObject->fetchAttrsFromTable_()
    3: plib\DatabaseServer.php:40
    DatabaseServer->__construct(string '1')
    4: plib\DatabaseServerManager.php:99
    DatabaseServerManager->getServer(string '1')
    5: plib\class.DataBasesList.php:74
    DataBasesList->fetchDataBasesList()
    6: plib\class.cList.php3:96
    cList->fetchList()
    7: plib\class.cList.php3:115
    cList->init()
    8: htdocs\domains\databases\db.php3:33


    I have reinstalled 8.6 but the errors persist. Any chance this can be fixed?
     
  2. JTRipper

    JTRipper Regular Pleskian

    27
     
    Joined:
    Mar 22, 2006
    Messages:
    106
    Likes Received:
    3
    Location:
    Italy
    same problem here mate...
     
  3. datThomas

    datThomas Guest

    0
     
    I ended up doing a clean install and starting from backup.
     
Loading...