C
CoderAZ
Guest
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!
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!