Hi, I'm trying to install beta 2 on my WAMP system, and during the regular install I'm getting all kind of "Table create" error like :

Error while executing: CREATE TABLE `sys_admin_dashboard` (`id` int(11) unsigned NOT NULL auto_increment,`name` varchar(32) NOT NULL default '',`content` text NOT NULL default '',`column` tinyint(4) unsigned NOT NULL default '0',`order` tinyint(4) unsigned NOT NULL default '0',PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
BLOB/TEXT column 'content' can't have a default value

or

Error while executing: CREATE TABLE `sys_menu_admin` (`id` int(11) unsigned NOT NULL auto_increment,`parent_id` int(11) NOT NULL default '0',`name` varchar(32) NOT NULL default '',`title` varchar(64) NOT NULL default '',`url` varchar(255) NOT NULL default '',`description` text NOT NULL default '',`icon` varchar(128) NOT NULL default '',`icon_large` varchar(128) NOT NULL default '',`check` varchar(255) NOT NULL default '',`order` tinyint(4) unsigned NOT NULL default '0',PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
BLOB/TEXT column 'description' can't have a default value

etc... there is a way to go to the sql file however I think it should be deal through the original code.

Based on other feedback, people managed to install it on other system.

You need to comment out the sql-mode line to turn off STRICT mode

# Set the SQL mode to strict
#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Add the # to comment out the line in MY.INI in MySql

abailey, thanks! worked for me. I'm sharing the same mysql ini and php for 6.1.4 and didn't have problem before. I guess it has to be documented for other users.

Glad it works. Seems to be necessary for the Windows MySql

Ticket #784