Backup fails with error: mailname "info" Unable to execute SQL

Created:

2016-11-16 12:44:54 UTC

Modified:

2017-08-16 16:05:55 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Backup fails with error: mailname "info" Unable to execute SQL

Applicable to:

  • Plesk 11.x for Linux
  • Plesk 12.0 for Linux

Symptoms

Backup fails with following error:

Unable to execute SQL: Table 'psa.domainaliases' doesn't exist
Error: mailname "info"
Unable to execute SQL: Table 'psa.ServiceNodeProperties' doesn't exist

Cause

Incorrect version of Plesk is specified in the 'version' file.

Resolution

Make sure the valid version is set in '/usr/local/psa/version':

# cat /usr/local/psa/version
12.0.18 CentOS 6 1200150126.15
# rpm -qa psa
psa-12.0.18-cos6.build1200150126.15.x86_64

If not, replace it with valid information and rerun backup task:

# cp /usr/local/psa/version{,_backup} && rpm -qa psa | sed -e 's/psa-//; s/-/ /; s/.build*/ /' > /usr/local/psa/version
Have more questions? Submit a request
Please sign in to leave a comment.