Error creating table fields_meta_data with MySQL 5

[clint]

This is issue came up today. --Clint

Hello,

there is a problem with installing the version: SugarSuite-4.5.0d.zip

My Setup:
Win XP pro, Apache 2.2, php 5.1, mySQL 5.0

And I get the following error during install:
=============================================

Step 7: Perform Setup Creating Sugar configuration file (config.php)

Creating Sugar application tables, audit tables, and relationship metadata...

Creating the database sugarcrm on localhost...done Creating the Database username and password...Creating the Database username and password for localhost...done
relationships... creating / relationship meta ... done
acl_roles... creating / relationship meta ... done
acl_actions... creating / relationship meta ... done
leads... creating / audit table / relationship meta ... done
contacts... creating / audit table / relationship meta ... done
accounts... creating / audit table / relationship meta ... done
opportunities... creating / audit table / relationship meta ... done
cases... creating / audit table / relationship meta ... done
notes... creating / relationship meta ... done
email_templates... creating / relationship meta ... done
emailman... creating / relationship meta ... done
calls... creating / relationship meta ... done
emails... creating / relationship meta ... done
meetings... creating / relationship meta ... done
iframes... creating / relationship meta ... done
tasks... creating / relationship meta ... done
users... creating / relationship meta ... done
currencies... creating / relationship meta ... done
tracker... creating / relationship meta ... done
import_maps... creating / relationship meta ... done
files... creating / relationship meta ... done
users_last_import... creating / relationship meta ... done
config... creating / relationship meta ... done
upgrade_history... creating / relationship meta ... done
vcals... creating / relationship meta ... done
bugs... creating / audit table / relationship meta ... done
versions... creating / relationship meta ... done
releases... creating / relationship meta ... done
feeds... creating / relationship meta ... done
project... creating / relationship meta ... done
project_task... creating / audit table / relationship meta ... done
roles... creating / relationship meta ... done
email_marketing... creating / relationship meta ... done
campaigns... creating / audit table / relationship meta ... done
prospect_lists... creating / relationship meta ... done
prospects... creating / relationship meta ... done
documents... creating / relationship meta ... done
document_revisions... creating / relationship meta ... done
fields_meta_data... Error creating table: fields_meta_data: Query Failed:CREATE TABLE fields_meta_data (id varchar(255) NOT NULL ,name varchar(255) NULL ,label varchar(255) NULL ,help varchar(255) NULL ,custom_module varchar(255) NULL ,data_type varchar(255) NULL ,max_size int(11) NULL ,required_option varchar(255) NULL ,default_value varchar(255) NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,audited bool DEFAULT '0' NULL ,mass_update bool DEFAULT '0' NULL ,duplicate_merge smallint DEFAULT '0' NULL ,ext1 varchar(255) DEFAULT '' NULL ,ext2 varchar(255) DEFAULT '' NULL ,ext3 varchar(255) DEFAULT '' NULL ,ext4 text DEFAULT '' NULL , PRIMARY KEY (id), KEY idx_meta_id_del (id, deleted))::MySQL error 1101: BLOB/TEXT column 'ext4' can't have a default value

[clint]

The workaround is to edit the following file and rerun the installation.

In modules/EditCustomFields/vardefs.php

change
'ext4'=>array('name' =>'ext4', 'type' =>'text', 'default'=>''),

to

'ext4'=>array('name' =>'ext4', 'type' =>'text'),


This is being tracked as bug 9484 and is unique to MySQL 5. It will be fixed in the next 4.5.0 patch.

Regards,
Clint