Failure to update MySQL database from 0.7 - text column can't have default value
|Reported by:||Jack!||Owned by:|
MySQL (version 5.5.19) on Windows is throwing an error if I'm trying to upgrade from RC 0.7 to RC 0.7.1 using appropriate part in file mysql.update.sql.
Command that throws an error:
ALTER TABLE `contacts` MODIFY `email` text NOT NULL DEFAULT '';
ERROR 1101 (42000): BLOB/TEXT column 'email' can't have a default value
MySQL 5.5 manual (see http://dev.mysql.com/doc/refman/5.5/en/blob.html) says "BLOB and TEXT columns cannot have DEFAULT values."
Next command works though:
ALTER TABLE `contacts` MODIFY `email` text NOT NULL;
but I'm not sure if this meets the RC requirements for the database.
Change History (3)
comment:2 Changed 17 months ago by alec
- Milestone changed from later to 0.8-beta
- Resolution set to fixed
- Status changed from new to closed