Closed (fixed)
Project:
Event Manager
Version:
5.x-1.x-dev
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Reporter:
Created:
11 Mar 2008 at 06:07 UTC
Updated:
2 Jan 2014 at 19:04 UTC
Jump to comment: Most recent
When attempting to install the module, I received the following errors:
* user warning: Too big column length for column 'email_confirm_from' (max = 255). Use BLOB instead query: CREATE TABLE event_registration_settings ( nid int(10) unsigned NOT NULL default '0', registration_type int(10), registration_start int(10) NOT NULL, registration_end int(10) NOT NULL, ts_len int(10), max_participants int(10), is_email_confirm int(2), email_confirm_from varchar(1024), email_confirm_subject varchar(1024), email_confirm_text TEXT, registration_success_url varchar(4096), email_cancel_from varchar(1024), email_cancel_subject varchar(1024), email_cancel_text TEXT, cancel_success_url varchar(4096), PRIMARY KEY (nid)) /*!40100 DEFAULT CHARACTER SET utf8 */; in /home/.../public_html/includes/database.mysql.inc on line 172.
* user warning: Too big column length for column 'rg_description' (max = 255). Use BLOB instead query: CREATE TABLE event_role_groups ( nid int(10) unsigned NOT NULL default '0', rgid int(10) unsigned NOT NULL auto_increment, rg_name varchar(128), rg_description varchar(1024), PRIMARY KEY (nid,rgid), KEY (rgid)) /*!40100 DEFAULT CHARACTER SET utf8 */; in /home/.../public_html/includes/database.mysql.inc on line 172.
* user warning: Too big column length for column 'role_description' (max = 255). Use BLOB instead query: CREATE TABLE event_roles ( nid int(10) unsigned NOT NULL default '0', rgid int(10) unsigned NOT NULL default '0', rid int(10) unsigned NOT NULL auto_increment, rid_seq int(10) unsigned NOT NULL, role_nslots int(10) unsigned NOT NULL default '0', role_name varchar(128), role_description varchar(1024), role_instructions TEXT, timestamp int(10), PRIMARY KEY (rid), KEY (nid, rgid, rid)) /*!40100 DEFAULT CHARACTER SET utf8 */; in /home/.../public_html/includes/database.mysql.inc on line 172.
* user warning: Too big column length for column 'conf_code' (max = 255). Use BLOB instead query: CREATE TABLE event_registration ( nid int(10) unsigned NOT NULL default '0', rid int(10) unsigned NOT NULL default '0', seq int(10) unsigned NOT NULL default '0', sid int(10) unsigned NOT NULL default '0', pid int(10) unsigned NOT NULL default '0', is_drupal_user int(1) unsigned default '0', conf_code varchar(256), notes TEXT, PRIMARY KEY (nid, rid, seq, sid)) /*!40100 DEFAULT CHARACTER SET utf8 */; in /home/.../public_html/includes/database.mysql.inc on line 172.
* user warning: Too big column length for column 'fname' (max = 255). Use BLOB instead query: CREATE TABLE event_participant ( pid int(10) unsigned NOT NULL auto_increment, fname varchar(256), lname varchar(256), email varchar(4096), phone varchar(24), confirmation_by_default int(2) default '1', PRIMARY KEY (pid)) /*!40100 DEFAULT CHARACTER SET utf8 */; in /home/.../public_html/includes/database.mysql.inc on line 172.
Comments
Comment #1
dhollender commentedmysql versions prior to 5.03 limit the length of a varchar database column to 255 characters. Therefore, only Drupal Installations that use prior versions will experience this issue. For information about this difference please visit:
http://dev.mysql.com/doc/refman/5.0/en/char.html
To address this issue immediately, update to the latest version of mysql. To do this, visit:
http://dev.mysql.com/downloads/mysql/5.0.html
Comment #2
dhollender commentedComment #3
dhollender commentedChanged installation function to create TEXT, rather than VARCHAR for long fields to allow support for MySQL versions 5.02 and prior.