Unable to change Plesk database provider name: Can't execute delete from `sysdiagrams`: MySql error 1146:Table 'psa.sysdiagrams' doesn't exist

Created:

2016-12-18 06:42:29 UTC

Modified:

2017-08-16 16:37:16 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to change Plesk database provider name: Can't execute delete from `sysdiagrams`: MySql error 1146:Table 'psa.sysdiagrams' doesn't exist

Applicable to:

  • Plesk 11.x for Windows

Symptoms

Unable to change Plesk database provider name from MSSQL to MySQL, the following error is shown:

Can't execute delete from `sysdiagrams`: MySql error 1146:Table 'psa.sysdiagrams' doesn't exist
at (MySQLDatabaseProvider::execute line 303)
at startElement(ContentHandlerWrapper::raw_startElement line 335)
at (ContentHandlerWrapper::parseURL line 32)
at VDatabaseSwitch::SwitchDb(VDatabaseSwitch::SwitchDb line 161)
at execute console command --switch-plesk-database(vconsoleapp::start line 97)

Cause

Table sysdiagrams exists in psa database on MSSQL server. There is no such table in Plesk database, thus, when performing the database switch, this table is not expected. This table does not contain any data, it could be created for example when trying to create database diagram in SQL Studio directly.

Resolution

  1. Create a backup of psa database in MSSQL Management Studio.

  2. Remove sysdiagrams table.

  3. Complete the database switch.

Have more questions? Submit a request
Please sign in to leave a comment.