Default text/blob value errors on Windows
brenda003 - August 20, 2009 - 18:38
| Project: | Entrez Database Import |
| Version: | 6.x-1.0-beta1 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Stefan Freudenberg |
| Status: | closed |
Jump to:
Description
On Windows, mySQL does not like blob/text fields to have a default set, causing this error when enabling the module.
user warning: BLOB/TEXT column 'query' can't have a default value query: CREATE TABLE entrez_query ( `qdate` INT NOT NULL DEFAULT 0, `query` TEXT NOT NULL DEFAULT '', `min_date` DATETIME NOT NULL, `max_date` DATETIME NOT NULL, PRIMARY KEY (qdate) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in xxx\includes\database.inc on line 517.This patch resolves the issue.
| Attachment | Size |
|---|---|
| entrez_default.patch | 955 bytes |
#1
Applied patch.
#2
Automatically closed -- issue fixed for 2 weeks with no activity.