CiviCRM Community Forums (archive)

Hi all,

i tried to create Custom Data groups yesterday and I got an error message (which I reproduced today):

    Sorry. A non-recoverable error has occurred.

    DB Error: can not create

    Database Error Code: Can't create table './connectc_joomlanew/civicrm_value_neue_gruppe_3.frm' (errno: 150), 1005

    Return to home page.

Error Details:

 

Code: [Select]

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_neue_gruppe_3 (
        `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_neue_gruppe_3_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 './connectc_joomlanew/civicrm_value_neue_gruppe_3.frm' (errno: 150)]
    [type] => DB_Error
    [user_info] => CREATE TABLE civicrm_value_neue_gruppe_3 (
        `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_neue_gruppe_3_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 './connectc_joomlanew/civicrm_value_neue_gruppe_3.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_neue_gruppe_3 (
        `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_neue_gruppe_3_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 './connectc_joomlanew/civicrm_value_neue_gruppe_3.frm' (errno: 150)]"]
)


I figured it went all wrong and was surprised to see the group listet under Administer - Custom Data. So i created a field in it, which now is listed in "view and Edit fields" as well.
The problem is:
I can not view any contact any more, cause it tries to show this custom group and aparantly there is now table for it, just gives me this:

    Sorry. A non-recoverable error has occurred.

    DB Error: no such table

    Database Error Code: Table 'connectc_joomlanew.civicrm_value_zusatzinfos_2' doesn't exist, 1146

    Return to home page.

Error Details:

 

Code: [Select]

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

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
SELECT id
FROM   civicrm_value_zusatzinfos_2
WHERE  entity_id = 1
 [nativecode=1146 ** Table 'connectc_joomlanew.civicrm_value_zusatzinfos_2' doesn't exist]
    [type] => DB_Error
    [user_info] =>
SELECT id
FROM   civicrm_value_zusatzinfos_2
WHERE  entity_id = 1
 [nativecode=1146 ** Table 'connectc_joomlanew.civicrm_value_zusatzinfos_2' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT id
FROM   civicrm_value_zusatzinfos_2
WHERE  entity_id = 1
 [nativecode=1146 ** Table 'connectc_joomlanew.civicrm_value_zusatzinfos_2' doesn't exist]"]
)


Also deleting either the one field or the group only results in error messages. So somewhere there is the problem tha civi thinks the table is there, but it was obviously not able to create it (which I would also like to now why...).

Does anybody have any ideas on

a. how to get rid of these groups so I can view my contacts again
b. what the problem might be in the first place?

Thanks for your help![/code][/code]

Thanks for your reply!
I think that will make it possible to clean it up again.

It sounds to me like your website database user doesn't have sufficient permissions to create tables in your db. Civi is inserting the custom data set record, but is unable to create the actual table.

Custom data sets consists of a record in civicrm_custom_group and a corresponding table. Fields are defined in civicrm_custom_field but actually created in the corresponding table. So it looks like the records inserted, but the user can't create the table.

I just checked the user in the joomla settings and then via php my Admin which privileges it has: all. I will check with my website provider.

Any other ideas?

greetings!