SymptomsI 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!
Errors: SQLSTATE: Syntax error or access violation: 1101 BLOB/TEXT column 'description' can't have a default value
CauseThe 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.
ResolutionFind 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.