Article ID: 114359, created on Jul 13, 2012, last review on May 6, 2014

  • Applies to:
  • Plesk 11.x for Windows
  • Plesk 10.x for Windows


I just upgraded the Parallels Plesk Panel (PP) from 10.x to 11.x.
The upgrade went fine.
Then when I tried to get in the Customer and Business Manager (CBM) it attempted to upgrade that part, but failed with this error:
Error: Failed to upgrade Business Manager to version 11.0.9-1. See the log below for details and fix the problems if possible. Business Manager will restart the upgrade procedure next time you log in to it.
In the log I saw:

Start upgrading process:Updating database schema: Upgrading database to 11.0.0-1....................................[ OK ]
Upgrading database to 11.0.1-1....................................
Error:Error: - Upgrade Error!
Install Version:
Fileset Version:
Errors: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB/TEXT column 'description' can't have a default value


The issue may occur if strict mode is enabled for MySQL server. It is important to know that in PP for Windows uses two MySQL instances - one for internal operations and one for customer's databases. CBM database is hosted by customer's database which runs on port 3306.


Find the configuration file for the needed MySQL instance in the properties of the CBM service. Let us assume it is located at 'C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\data\my.ini'. Open that file and check if there the sql-mode value contains STRICT_TRANS_TABLES, for example:

If it does, you need to remove that parameter, in the above example we get this result:

Restart the Plesk Control Panel service.
The upgrade procedure should finish successfully now.

bd7fc88cf1b01f097749ae6f87272128 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 c796c01d6951fa24ed54c7f1111667c6

Email subscription for changes to this article
Save as PDF