Hi,

following error occur during install (in MySQL version 5.0.27, Drupal 5.1):

user warning: BLOB/TEXT column 'settings' can't have a default value query: CREATE TABLE mss_textimage_preset ( pid INT UNSIGNED NOT NULL PRIMARY KEY, name VARCHAR(255) NOT NULL DEFAULT '', settings TEXT NOT NULL DEFAULT '' ) /*!40100 DEFAULT CHARACTER SET utf8 */ in ...\includes\database.mysql.inc on line 167.

create table statement for mysql should be changed to:

      db_query('CREATE TABLE {textimage_preset} (
        pid INT UNSIGNED NOT NULL PRIMARY KEY,
        name VARCHAR(255) NOT NULL DEFAULT \'\',
        settings TEXT NOT NULL)
        /*!40100 DEFAULT CHARACTER SET utf8 */'
      ); 
CommentFileSizeAuthor
#1 textimage_148217.patch821 bytesdrewish

Comments

drewish’s picture

Status: Active » Reviewed & tested by the community
StatusFileSize
new821 bytes

it's true. here's a patch.

wundo’s picture

Assigned: Unassigned » wundo
Status: Reviewed & tested by the community » Fixed

committed,
thanks

Anonymous’s picture

Status: Fixed » Closed (fixed)