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) |
Jump to:
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
Please confirm that the versions you have all are correct. E.g. mixing up HEAD and 4.7 will break.
#2