Got errors when enabling flexinode

henry_lam - November 26, 2006 - 10:20
Project:Flexinode
Version:4.7.x-1.x-dev
Component:Update and installation script
Category:bug report
Priority:normal
Assigned:Unassigned
Status:postponed (maintainer needs more info)
Description

I got the following errors when enabling Flexinode in Drupal 4.7.4. I am using Windows XP Home, MySQL 5.0.27, Apache 2.0.59 and PHP 5.1.6 for my development environment. It seems that the system fails to create those tables because 'TEXT' field cannot have default value. So, can I just remove the default values of those 'TEXT' fields in order to bypass the problem? Will there be any negative effect on the functionality of the module if I do this.
Thank you very much!

ERRORS:

  • BLOB/TEXT column 'default_value' can't have a default value query: CREATE TABLE flexinode_field ( field_id int(10) unsigned NOT NULL default '0', ctype_id int(10) unsigned NOT NULL default '0', label varchar(255) NOT NULL default '', default_value mediumtext NOT NULL default '', weight int(10) NOT NULL default '0', required int(1) NOT NULL default '0', show_teaser int(1) NOT NULL default '0', show_table int(1) NOT NULL default '0', rows int(10) unsigned NOT NULL default '0', field_type varchar(255) NOT NULL default '', options text NOT NULL default '', description varchar(255) NOT NULL default '', PRIMARY KEY field_id (field_id), KEY ctype_id (ctype_id) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in C:\MyDocs\workspace\drupal_development\includes\database.mysql.inc on line 121.
  • BLOB/TEXT column 'help' can't have a default value query: CREATE TABLE flexinode_type ( ctype_id int(10) unsigned NOT NULL default '0', name varchar(255) NOT NULL default '', description varchar(255) NOT NULL default '', help text NOT NULL default '', PRIMARY KEY ctype_id (ctype_id) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in C:\MyDocs\workspace\drupal_development\includes\database.mysql.inc on line 121.
  • BLOB/TEXT column 'textual_data' can't have a default value query: CREATE TABLE flexinode_data ( nid int(10) unsigned NOT NULL default '0', field_id int(10) unsigned NOT NULL default '0', textual_data mediumtext NOT NULL default '', numeric_data int(10) unsigned NOT NULL default '0', serialized_data mediumtext NOT NULL default '', PRIMARY KEY id (nid,field_id) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in C:\MyDocs\workspace\drupal_development\includes\database.mysql.inc on line 121.

#1

Bèr Kessels - November 30, 2006 - 17:34

Please confirm that the versions you have all are correct. E.g. mixing up HEAD and 4.7 will break.

#2

Bèr Kessels - January 15, 2007 - 12:21
Status:active» postponed (maintainer needs more info)
 
 

Drupal is a registered trademark of Dries Buytaert.