see http://dev.mysql.com/doc/refman/4.1/en/blob.html

CommentFileSizeAuthor
#5 mysql_text_nodef_corr.patch.txt2.35 KBheine
#4 mysql_text_nodefault.patch.txt2.35 KBheine
#3 mysql_text_defaults.patch3.91 KBZen
mysql_no_text_defaults.patch1.94 KBkilles@www.drop.org

Comments

Zen’s picture

Zen commented

Missed a couple:

castor:/home/karthik/public_html/projects/cvs/drupal # grep -in text database/database.mysql | grep -i default
136:  pages text DEFAULT '' NOT NULL
500:  explanation TEXT default NULL,

Cheers,
-K

Zen’s picture

Zen commented
Status: Needs review » Needs work
Zen’s picture

Zen commented
Version: x.y.z » 4.7.4
Status: Needs work » Needs review
StatusFileSize
new mysql_text_defaults.patch3.91 KB

Updated against 4-7-4.

-K

heine’s picture

heine commented
Version: 4.7.4 » 5.x-dev
StatusFileSize
new mysql_text_nodefault.patch.txt2.35 KB

Against 5-dev

heine’s picture

heine commented
StatusFileSize
new mysql_text_nodef_corr.patch.txt2.35 KB

Ahum, uploaded correct file.

heine’s picture

heine commented

This is not an 'academic' issue: on certain MySQL 5 installations (strict mode), it will cause installation to fail.

heine’s picture

heine commented
Title: MySQL does not support default values on text and blob fields » Failed installation: MySQL does not support default values on text and blob fields

For an example of failure see http://drupal.org/node/98981

dries’s picture

dries commented
Status: Needs review » Fixed

Committed to CVS HEAD. Thanks.

Zen’s picture

Zen commented
Version: 5.x-dev » 4.7.x-dev
Assigned: Unassigned » Zen
Status: Fixed » Patch (to be ported)
killes@www.drop.org’s picture

killes@www.drop.org commented
Status: Patch (to be ported) » Fixed

applied

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)