Unable to recreate SiteBuilder5 database

[CoderAZ]

Hello All,

I am trying to rebuild my SiteBuilder5 database from scratch using the following cmd line:
"C:\Program Files (x86)\Parallels\Plesk\admin\bin\php.exe" -c "C:\Program Files (x86)\Parallels\Plesk\admin\php.ini" -dauto_prepend_file="" "C:\Program Files (x86)\Parallels\Plesk\sb\utils\configure.php" --db_admin_name root --db_admin_passwd ######### --sb_db_user_name=sitebuilder_db --sb_db_user_passwd=######### --init_db

The results I am getting are as follows:


[INFO]Initializing the Web Presence Builder's database...
[INFO]Creating database...
[INFO]Updating the database user credentials...
[ERROR]Unable to create table(SQLSTATE[42000]: 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` varcha
r(255) NOT NULL default '', `content` text NOT NULL default '', `update_passwo
rd` varchar(255) NOT NULL default '', `import_date` varchar(25) default '',UN
IQUE KEY `key_id` (`key_id`), PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=
utf8)


Has anyone else run across this or tried to just rebuild the DB? Any help would be appreciated!

 

[DmitriyR]

Current version sitebuilder don't support sql strict mode in mysql.
This behavior usually occurs when you turn sql-mode in strict mode.
If it is true?
You can reconfigure mysql server, change or add line in file my.cnf:
sql-mode = ""

see also
http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html