Unable to create a domain: Incorrect integer value: 'false' for column 'icpStatus' at row 1

Refers to:

  • Plesk 12.5 for Windows

Created:

2016-11-16 13:13:20 UTC

Modified:

2016-12-21 20:13:31 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to create a domain: Incorrect integer value: 'false' for column 'icpStatus' at row 1

Symptoms

Unable create a domain or subdomain:

Error: Failed domain creation: Unable to update domain data: DB query failed: Incorrect integer value: 'false' for column 'icpStatus' at row 1

Cause

MySQL restrictions specified in my.ini .

Resolution

  1. Comment sql-mode if it's specified in C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data\\my.ini .

    # sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  2. Restart Plesk SQL Server service.

Note: location of my.ini can be different on your server.

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