1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Unable to recreate SiteBuilder5 database

Discussion in 'Web Presence Builder' started by CoderAZ, Jul 31, 2012.

  1. CoderAZ

    CoderAZ Guest

    0
     
    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!
     
  2. DmitriyR

    DmitriyR New Pleskian Plesk Team

    10
    30%
    Joined:
    Aug 15, 2012
    Messages:
    7
    Likes Received:
    0
    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
     
Loading...