Posted by qube on May 31, 2007 at 8:56am
| Project: | Textimage |
| Version: | 5.x-1.2 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | wundo |
| Status: | closed (fixed) |
Issue Summary
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 */'
);
Comments
#1
it's true. here's a patch.
#2
committed,
thanks
#3