• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

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

D

datThomas

Guest
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?
 
Back
Top