[RESOLVED] MySql Error 1101

[Kyderoy]

I get this error message when I try to execute this query

This is the query

ALTER TABLE gtpeepsiz.phpizabi_users MODIFY COLUMN act_history LONGTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 0;

This is the error message
BLOB/TEXT column 'act_history' can't have a default value

Any ideas why this is happening? I tried to post this in the sql area but I can't

[NogDog]

As per http://dev.mysql.com/doc/refman/4.1/en/blob.html, "BLOB and TEXT columns cannot have DEFAULT values."

[Kyderoy]

Thank you

[bradgrafelman]

Don't forget to mark this thread resolved.