• 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.

Lots of SQL errors

P

ponggr

Guest
I am getting a lot of errors in Plesk but also when I try to do a full system backup from the terminal. All seem to be SQL related. For example when I try to do a full system backup I get the following (it seems that tables are missing!):

DBD::mysql::st execute failed: Table 'psa.APSClientApplicationItems' doesn't exist at /usr/local/psa/PMM/agents/shared/Db/DbiBackend.pm line 66.
01:43:44 ERROR Unable to execute SQL (SELECT sap.name AS sapp_name, sap.version AS sapp_version, sap.release AS sapp_release, lt.license_type_hash AS license_type_id, ai.shared AS shared, cai.instances_limit AS instances_limit FROM APSClientApplicationItems AS cai INNER JOIN APSApplicationItems AS ai ON (ai.id = cai.app_item_id AND cai.client_id = '2') INNER JOIN SiteAppPackages AS sap ON (sap.id=ai.pkg_id)LEFT JOIN APSLicenseTypes AS lt ON (ai.license_type_id = lt.id) AND ai.shared = 'false'): Table 'psa.APSClientApplicationItems' doesn't exist
DBD::mysql::st execute failed: Table 'psa.APSClientApplicationItems' doesn't exist at /usr/local/psa/PMM/agents/shared/Db/DbiBackend.pm line 66.
.
.
.
01:43:50 ERROR Unable to execute SQL (SELECT id FROM SiteApps WHERE dom_type='domain' AND dom_id='63'): Table 'psa.SiteApps' doesn't exist
DBD::mysql::st execute failed: Table 'psa.SiteAppPackages' doesn't exist at /usr/local/psa/PMM/agents/shared/Db/DbiBackend.pm line 66.
01:43:50 ERROR Unable to execute SQL (SELECT `name`, `version`, `release` FROM SiteAppPackages): Table 'psa.SiteAppPackages' doesn't exist
DBD::mysql::st execute failed: Table 'psa.SiteAppPackages' doesn't exist at /usr/local/psa/PMM/agents/shared/Db/DbiBackend.pm line 66.
01:43:50 ERROR Unable to execute SQL (SELECT `name`, `version`, `release` FROM SiteAppPackages): Table 'psa.SiteAppPackages' doesn't exist
DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/psa/PMM/agents/shared/Db/DbiBackend.pm line 84.
DBD::mysql::st execute failed: Table 'psa.APSApplicationItems' doesn't exist at /usr/local/psa/PMM/agents/shared/Db/DbiBackend.pm line 66.
01:43:50 ERROR Unable to execute SQL (SELECT lt.license_type_hash AS license_type_id, sap.name AS sapp_name, sap.version AS sapp_version, sap.release AS sapp_release, ai.shared AS shared, ai.disabled AS disabled FROM APSApplicationItems AS ai INNER JOIN SiteAppPackages sap ON (sap.id = ai.pkg_id) INNER JOIN APSLicenseTypes AS lt ON (lt.id = ai.license_type_id)): Table 'psa.APSApplicationItems' doesn't exist
DBD::mysql::st execute failed: Table 'psa.APSApplicationItems' doesn't exist at /usr/local/psa/PMM/agents/shared/Db/DbiBackend.pm line 66.
01:43:50 ERROR Unable to execute SQL (SELECT lt.license_type_hash AS license_type_id, sap.name AS sapp_name, sap.version AS sapp_version, sap.release AS sapp_release, ai.shared AS shared, ai.disabled AS disabled FROM APSApplicationItems AS ai INNER JOIN SiteAppPackages sap ON (sap.id = ai.pkg_id) INNER JOIN APSLicenseTypes AS lt ON (lt.id = ai.license_type_id)): Table 'psa.APSApplicationItems' doesn't exist
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/psa/PMM/agents/shared/Db/DbiBackend.pm line 90.
DBD::mysql::st execute failed: Table 'psa.APSLicenses' doesn't exist at /usr/local/psa/PMM/agents/shared/Db/DbiBackend.pm line 66.
01:43:50 ERROR Unable to execute SQL (SELECT l.key_number, l.source, lt.license_type_hash FROM APSLicenses l, APSLicenseTypes lt WHERE l.license_type_id = lt.id): Table 'psa.APSLicenses' doesn't exist
DBD::mysql::st execute failed: Table 'psa.APSLicenses' doesn't exist at /usr/local/psa/PMM/agents/shared/Db/DbiBackend.pm line 66.
01:43:50 ERROR Unable to execute SQL (SELECT l.key_number, l.source, lt.license_type_hash FROM APSLicenses l, APSLicenseTypes lt WHERE l.license_type_id = lt.id): Table 'psa.APSLicenses' doesn't exist
DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/psa/PMM/agents/shared/Db/DbiBackend.pm line 84.
 
My server support are ace and fixed it.

The database was corrupted and they fixed it.
 
Your plesk database is corrupted. Looks like upgrade to 8.3 was failed.
Try to find out the reason from upgrade logs in /tmp folder.
also you can try to run upgrade subsytem upgrade script with /usr/local/psa/admin/bin/php /usr/local/psa/etc/db/aps-psa830-db-upgrade command
 
You must log in or register to reply here.

Similar threads

V
Resolved RoundCube error : Oops... something went wrong!
Replies
3
Views
6K
Peter Debik
P
M
Question Upgrade MariaDB 10.3 to 10.11 via Plesk 18.0.61 on Debian 10
Replies
1
Views
1K
Kaspar@Plesk
Kaspar@Plesk
A
Issue database error
Replies
0
Views
913
airodump
A
tkalfaoglu
Forwarded to devs Migration gives an SQL error
Replies
4
Views
2K
tkalfaoglu
tkalfaoglu
M
Issue Error after trying to update to obsidian
Replies
4
Views
2K
McCoy
M
Back
Top