Web Presence Builder is not upgraded

Created:

2016-11-16 13:20:09 UTC

Modified:

2017-08-16 18:30:17 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Web Presence Builder is not upgraded

Applicable to:

  • Plesk 11.x for Windows

Symptoms

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)

Resolution

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

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

In this case do the following actions:

  1. Comment this line

    # sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  2. Restart Mysql server

  3. Launch autoinstaller again

Cause

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

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Have more questions? Submit a request
Please sign in to leave a comment.