CiviCRM Community Forums (archive)

Hello, CiviCRM Forum,

We are getting some consistent errors that tend to change depending on the version we try to install.  Following is an example

Cannot execute CREATE TABLE civicrm_mapping_field ( id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Mapping Field ID', mapping_id int unsigned NOT NULL COMMENT 'Mapping to which this field belongs', name varchar(255) COMMENT 'Mapping field key', contact_type varchar(64) COMMENT 'Contact Type in mapping', column_number int unsigned NOT NULL COMMENT 'Column number for mapping set', location_type_id int unsigned COMMENT 'Location type of this mapping, if required', phone_type_id int unsigned COMMENT 'Which type of phone does this number belongs.', im_provider_id int unsigned COMMENT 'Which type of IM Provider does this name belong.', website_type_id int unsigned COMMENT 'Which type of website does this site belong', relationship_type_id int unsigned COMMENT 'Relationship type, if required', relationship_direction varchar(6) , grouping int unsigned DEFAULT 1 COMMENT 'Used to group mapping_field records into related sets (e.g. for criteria sets in search builder mappings).', operator enum('=', '!=', '>', '<', '>=', '<=', 'IN', 'NOT IN', 'LIKE', 'NOT LIKE', 'IS NULL', 'IS NOT NULL') COMMENT 'SQL WHERE operator for search-builder mapping fields (search criteria).', value varchar(255) COMMENT 'SQL WHERE value for search-builder mapping fields.' , PRIMARY KEY ( id ) , CONSTRAINT FK_civicrm_mapping_field_mapping_id FOREIGN KEY (mapping_id) REFERENCES civicrm_mapping(id) , CONSTRAINT FK_civicrm_mapping_field_location_type_id FOREIGN KEY (location_type_id) REFERENCES civicrm_location_type(id) , CONSTRAINT FK_civicrm_mapping_field_relationship_type_id FOREIGN KEY (relationship_type_id) REFERENCES civicrm_relationship_type(id) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci: DB Error: can not create

Any ideas of where to start the troubleshooting would be very helpful!

Thanks,
Jason

We were told that it was by our host.  We are using a VPS with plenty of juice.  Seems as though we are in the right place making the hosting company get INNODB working.  Thanks for the reply! 

Jason