RC3 - Driver Error on Install

[SkipFitz]

Server OS: Windows 2003 (SP1)
Web Server: IIS 6
mySQL: 5.026
PHP: 5.14
Browser Used For Install: Firefox 1.5.0.7 (But I get the same error in Opera 9.02)

This is a clean install, and I'm getting an IPS Driver Error as soon as I click on "Start Installation" (which is to say that I can fill out the necessary account and database info, but that's as far as I get). The returned error is below:

mySQL query error: CREATE TABLE crm_admin_login_logs (
admin_id INT(10) NOT NULL auto_increment,
admin_ip_address VARCHAR(16) NOT NULL default '0.0.0.0',
admin_username VARCHAR(40) NOT NULL default '',
admin_time INT(10) UNSIGNED NOT NULL default '0',
admin_success INT(1) UNSIGNED NOT NULL default '0',
admin_post_details TEXT NOT NULL default '',
PRIMARY KEY (admin_id),
KEY admin_ip_address (admin_ip_address),
KEY admin_time (admin_time)
) TYPE=MyISAM;

SQL error: BLOB/TEXT column 'admin_post_details' can't have a default value
SQL error code: 1101
Date: Wednesday 08th of November 2006 09:07:15 AM

I've wiped the database and tried again, but I get the same message. Any suggestions?

[Grant]

Hi,

I remember reading somewhere that this has to do with a setting in MySQL. Give me a few minutes and I will find it.

[SkipFitz]

Oh, good, thanks for searching. I searched this morning before I posted, but I didn't find anything that applied; however, a new pair of eyes (plus, you having possibly seen this before) will be helpful--especially if I missed a previous thread.

[bfarber]

MySQL 5 related bug due to strict mode, already fixed in my local copy

[SkipFitz]

Excellent. I'll wait for the next RC or Final version, then.

Thanks.