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 */;
  ");
CommentFileSizeAuthor
abuse .install.txt5.92 KBcoologic

Comments

jaydub’s picture

Status: Needs review » Fixed

This is now fixed in CVS. A patch for this issue and for PostgreSQL issues is here:

http://drupal.org/node/193370

Anonymous’s picture

Status: Fixed » Closed (fixed)

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