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

Created:

2016-11-16 13:13:20 UTC

Modified:

2017-08-08 13:28:54 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

Applicable to:

  • Plesk 12.5 for Windows

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 out  sql-mode directive if it is specified in %plesk_dir%\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 a particular installation.

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