Error while creating a subdomain: Specified column "managedPipelineMode" is not in the row

Refers to:

  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

Created:

2016-11-16 13:05:37 UTC

Modified:

2016-12-21 19:56:20 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Error while creating a subdomain: Specified column "managedPipelineMode" is not in the row

Symptoms

Unable to create a domain or subdomain. The following error is shown:

Specified column "managedPipelineMode" is not in the row

Cause

Plesk database inconsistency.

Resolution

  1. Back up Plesk database:

    %plesk_dir%\\MySQL\\bin\\mysqldump.exe -P8306 -uadmin -p<admin_password> psa domain > C:\\Temp\\psa.dump.sql
  2. Log in to Plesk database:

    %plesk_dir%\\MySQL\\bin\\%mysql -uadmin -p<admin_password> -P8306 -Dpsa
  3. Add the missing entry into iisapppools table and check the result:

    mysql> alter table iisapppools add `managedPipelineMode` enum('Classic','Integrated') NOT NULL DEFAULT 'Integrated';

For Plesk 12.5 and newer, execute plesk repair db in CMD to verify psa database.

Note: Do not accept blindly all the changes suggested by repair utility.

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