Closed (fixed)
Project:
Abuse
Version:
5.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
5 Nov 2007 at 19:54 UTC
Updated:
29 Mar 2008 at 15:42 UTC
Filename: abuse.install ------------
Problem: default values not allowed for TEXT field types
Solution: remove [DEFAULT ''] from table create function for TEXT field types.
MySQL Version: 5.0.45
//Create the reasons table
$result1 = db_query("
CREATE TABLE {abuse_reasons} (
arid int(11) unsigned NOT NULL,
reason varchar(72) NOT NULL DEFAULT '',
---Theses (2) Lines : Start ----
- description text NOT NULL DEFAULT '',
- argumentation text NOT NULL DEFAULT '',
---Theses (2) Lines : End ----
+ description text NOT NULL,
+ argumentation text NOT NULL,
PRIMARY KEY (arid)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;
");
| Comment | File | Size | Author |
|---|---|---|---|
| abuse .install.txt | 5.92 KB | coologic |
Comments
Comment #1
jaydub commentedThis is now fixed in CVS. A patch for this issue and for PostgreSQL issues is here:
http://drupal.org/node/193370
Comment #2
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.