CiviCRM Community Forums (archive)

Hi,

I'm trying to create a custom field set and I'm getting what appear to be permission errors. I've double checked civicrm_settings.php and datbase access with the host and I'm assured the permissions set are correct.  The host, who have civi experience indicate the problem is civicrm specific

Appreciate any pointers to a resolution, bearing in mind I'm not a programmer.

I'm using:

Drupal 6.19
CiviCRM 3.2.3.


Additional Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -15
    [message] => DB Error: can not create
    [mode] => 16
    [debug_info] => CREATE TABLE civicrm_value_custom_fields_test_14 (
        `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Default MySQL primary key',
        `entity_id` int unsigned NOT NULL COMMENT 'Table that this extends',
        PRIMARY KEY ( id ),
        UNIQUE INDEX unique_entity_id (  entity_id ),
        CONSTRAINT FK_civicrm_value_custom_fields_test_14_entity_id FOREIGN KEY ( `entity_id` ) REFERENCES civicrm_contact ( id ) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; [nativecode=1005 ** Can't create table './ictrie_drupal/civicrm_value_custom_fields_test_14.frm' (errno: 150)]
    [type] => DB_Error
    [user_info] => CREATE TABLE civicrm_value_custom_fields_test_14 (
        `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Default MySQL primary key',
        `entity_id` int unsigned NOT NULL COMMENT 'Table that this extends',
        PRIMARY KEY ( id ),
        UNIQUE INDEX unique_entity_id (  entity_id ),
        CONSTRAINT FK_civicrm_value_custom_fields_test_14_entity_id FOREIGN KEY ( `entity_id` ) REFERENCES civicrm_contact ( id ) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; [nativecode=1005 ** Can't create table './ictrie_drupal/civicrm_value_custom_fields_test_14.frm' (errno: 150)]
    [to_string] => [db_error: message="DB Error: can not create" code=-15 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TABLE civicrm_value_custom_fields_test_14 (
        `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Default MySQL primary key',
        `entity_id` int unsigned NOT NULL COMMENT 'Table that this extends',
        PRIMARY KEY ( id ),
        UNIQUE INDEX unique_entity_id (  entity_id ),
        CONSTRAINT FK_civicrm_value_custom_fields_test_14_entity_id FOREIGN KEY ( `entity_id` ) REFERENCES civicrm_contact ( id ) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; [nativecode=1005 ** Can't create table './ictrie_drupal/civicrm_value_custom_fields_test_14.frm' (errno: 150)]"]
)