• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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