Article ID: 116581, created on Jul 30, 2013, last review on Apr 26, 2014

  • Applies to:
  • Plesk 11.0 for Windows


During Plesk upgrade Web Presence Builder is not updated and fails with error:

Initializing the Web Presence Builder's database...

Unable to create table(SQLSTATE: Syntax error or access violation: 1101 BLOB/TEXT column 'content' can't have a default value; Query: CREATE TABLE IF NOT EXISTS license_key (id int NOT NULL auto_increment , key_id varchar(255) NOT NULL default '', content text NOT NULL default '', update_password varchar(255) NOT NULL default '', import_date varchar(25) default '',UNIQUE KEY key_id (key_id), PRIMARY KEY (id)) ENGINE=MyISAM DEFAULT CHARSET=utf8)


Please make sure that there is no strict rules in D:\Parallels\Plesk\Databases\MySQL\Data\my.ini like this one:


In this case do the following actions:

  1. Comment this line

  2. Restart Mysql server

  3. Launch autoinstaller again


The reason of the issue is in restrict settings in my.ini:

# Set the SQL mode to strict

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 514af229ae32522202a910a2649c80fb 85a92ca67f2200d36506862eaa6ed6b8 bd7fc88cf1b01f097749ae6f87272128

Email subscription for changes to this article
Save as PDF