An error when accessing Customers or Subscriptions: Unknown column s.custom in where clause

Refers to:

  • Plesk 10.4 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux

Created:

2016-11-16 12:42:40 UTC

Modified:

2016-12-21 19:01:54 UTC

0

Was this article helpful?


Have more questions?

Submit a request

An error when accessing Customers or Subscriptions: Unknown column s.custom in where clause

Symptoms

After Plesk upgrade, there is the followng error in Plesk Control Panel when accessing Customers or Subscriptions section:

Column not found: 1054 Unknown column 's.custom' in 'where clause'

Cause

Wrong phpmyadmin database user with incorrect password type was added to mysql database.

Resolution

The possible ways are:

  1. To use bootstrapper utility:

    # sh -x /usr/local/psa/bootstrapper/pp11.5.30-bootstrapper/bootstrapper.sh prep-install
  2. To remove old phpmyadmin database user or change its password type in 'mysql' database like:

    mysql> set password for 'pma_Bb9yJsEDU01F'@'localhost' = PASSWORD('****');
Have more questions? Submit a request
Please sign in to leave a comment.