Error Creating Tables

[Danym]

I followed all instructions from the manual, and After I click on "Start Auto Setup" I get the following errors:

Module: core (Page 1 of 1)
Creating table registry: FAILED
Reason: BLOB/TEXT column 'data' can't have a default value
Creating table settings: FAILED
Creating table settingsgroups: FAILED
Creating table settingsfields: FAILED
Creating table sessions: FAILED
Creating table signatures: FAILED
Creating table staff: FAILED
Creating table staffgroup: FAILED
Creating table staffgroupsettings: FAILED
Creating table staffschedules: FAILED
Creating table departments: FAILED
Creating table staffassigns: FAILED
Creating table groupassigns: FAILED
Creating table templategroup: FAILED
Creating table templatecategories: FAILED
Creating table template: FAILED
Creating table templatedata: FAILED
Creating table cron: FAILED
Creating table cronlog: FAILED
Creating table languages: FAILED
Creating table languagewords: FAILED
Creating table useremails: FAILED
Creating table users: FAILED
Creating table userverifyhash: FAILED
Creating table usergroups: FAILED
Creating table usergroupsettings: FAILED
Creating table tgroupassigns: FAILED
Creating table mailqueuedata: FAILED
Creating table customfields: FAILED
Creating table customfieldgroups: FAILED
Creating table customfieldvalues: FAILED
Creating table customfieldoptions: FAILED
Creating table customfieldlinks: FAILED
Creating table customfielddeplinks: FAILED
Creating table comments: FAILED
Creating table commentdata: FAILED
Creating table privatemessages: FAILED
Creating table privatemessagedata: FAILED
Creating table tempfiles: FAILED
Altering table session: (# Of Queries: 1) FAILED
Inserting data into staff: (# Of Queries: 1) FAILED
Inserting data into staffschedules: (# Of Queries: 1) FAILED
Inserting data into signatures: (# Of Queries: 1) FAILED
Inserting data into staffgroup: (# Of Queries: 2) FAILED
Inserting data into groupassigns: (# Of Queries: 2) FAILED
Inserting data into staffassigns: (# Of Queries: 1) FAILED
Inserting data into tgroupassigns: (# Of Queries: 1) FAILED
Inserting data into departments: (# Of Queries: 1) FAILED
Inserting data into settings: (# Of Queries: 5) FAILED
Inserting data into usergroups: (# Of Queries: 2) FAILED
Inserting data into templategroups: (# Of Queries: 1) FAILED
Inserting data into cron: (# Of Queries: 2) FAILED

Can anyone tell me what is wrong?

Thanks for your help

I am using the following:
windows 2003/IIs 6.0
php5.0
mysql latest
phpmyadmin
Live response v3 stable

[Mohit Sharma]

This is a some kind of bug with the MySQL 5. This problem can be resolved by making the following changes.

For windows

You need to change your MySQL ini and set:
sql-mode = ""

For linux

in /etc/my.cnf
[mysqld]
sql_mode = ''

Once set restart your MySQL server and it shall fix the issue.