• Debian 11 is approaching its end-of-life (vendor EOL date - August 31, 2026). Plesk Obsidian 18.0.80 will be the last release to support it.
    If you are running Plesk Obsidian on Debian 11, we recommend you upgrade those servers to Debian 12 using our dist-upgrade tool.
  • We plan to deprecate and remove the support for XML RPC protocol versions earlier than 1.6.9.1 in Plesk Obsidian 18.0.82. We strongly recommend that you update all existing integrations using earlier versions of the XML RPC protocol to comply with the version 1.6.9.1 specification.

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