During installation, the table headerimage is not installed because field: "condition" of type: "text" has a default value

Running Database MySQL 5.0.41 on windows
on Linux creating a default value for text fields works fine

Had same problem also with another module openresort (maintainer changed the code)
Its a know bug on windows but because of default settings in Linux is doesn't happen in Linux

Solution: don't give a default value for BLOB/TEXT fields

CommentFileSizeAuthor
#3 headerimage.280734_d5.patch1.15 KBsutharsan
#2 headerimage.200807151.patch743 bytesppblaauw
#1 headerimage.280734.patch1.51 KBsutharsan

Comments

sutharsan’s picture

sutharsan commented
Status: Active » Needs review
StatusFileSize
new headerimage.280734.patch1.51 KB

Thanks for reporting.
Also PostgreSQL should not have a default for text field types, but is less strict.
The attached patch solves it for both. Please test and let me know.

ppblaauw’s picture

ppblaauw commented
StatusFileSize
new headerimage.200807151.patch743 bytes

Thanks for the patch.

Your patch is for drupal version 5.
You don't have to delete NOT NULL, only default ''

The attached patch is for drupal 6

sutharsan’s picture

sutharsan commented
Status: Needs review » Fixed
StatusFileSize
new headerimage.280734_d5.patch1.15 KB

Thanks for your comments. Attached patches for 5.x-1.x-dev and HEAD have been committed.

Anonymous’s picture

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

Automatically closed -- issue fixed for two weeks with no activity.