CiviCRM Community Forums (archive)

Hi,

I'm running CiviCRM 3.2.3 on drupal.  I have multilang enabled to support both dutch and french. I've created a subtype, Student, based on contact type Individual, to capture additional information of students doing their internship. So far, so good. Now I want to use a custom contact reference field to relate the student to the internship mentor. I get DB error 1005 (errno 105) (http://dev.mysql.com/doc/refman/5.0/en/innodb-error-codes.html)

Additional info:

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

    [code_] => -15
    [message] => DB Error: can not create
    [mode] => 16
    [debug_info] =>         ALTER TABLE civicrm_value_student_info_2
        ADD COLUMN `gp_in_training_mentor_9` int unsigned,
        ADD INDEX INDEX_gp_in_training_mentor_9 ( gp_in_training_mentor_9 ),
        ADD CONSTRAINT FK_civicrm_value_student_info_2_gp__c12fa2c18aeb243c FOREIGN KEY ( `gp_in_training_mentor_9` ) REFERENCES civicrm_contact_nl_NL ( id ) ON DELETE SET NULL [nativecode=1005 ** Can't create table './civicrm/#sql-12e7_2bc00.frm' (errno: 150)]
    [type] => DB_Error
    [user_info] =>         ALTER TABLE civicrm_value_student_info_2
        ADD COLUMN `gp_in_training_mentor_9` int unsigned,
        ADD INDEX INDEX_gp_in_training_mentor_9 ( gp_in_training_mentor_9 ),
        ADD CONSTRAINT FK_civicrm_value_student_info_2_gp__c12fa2c18aeb243c FOREIGN KEY ( `gp_in_training_mentor_9` ) REFERENCES civicrm_contact_nl_NL ( id ) ON DELETE SET NULL [nativecode=1005 ** Can't create table './civicrm/#sql-12e7_2bc00.frm' (errno: 150)]
    [to_string] => [db_error: message="DB Error: can not create" code=-15 mode=callback callback=CRM_Core_Error::handle prefix="" info="        ALTER TABLE civicrm_value_student_info_2
        ADD COLUMN `gp_in_training_mentor_9` int unsigned,
        ADD INDEX INDEX_gp_in_training_mentor_9 ( gp_in_training_mentor_9 ),
        ADD CONSTRAINT FK_civicrm_value_student_info_2_gp__c12fa2c18aeb243c FOREIGN KEY ( `gp_in_training_mentor_9` ) REFERENCES civicrm_contact_nl_NL ( id ) ON DELETE SET NULL [nativecode=1005 ** Can't create table './civicrm/#sql-12e7_2bc00.frm' (errno: 150)]"]
)

There goes something wrong when the foreign key is added. It probably has something to do with the multilang install since the foreign key references a view that is specific to multilang. Any idea on how this problem can be solved?

Thanks,

c.

Thanks a lot for reporting this; the issue should be fixed by r30489, which will be a part of CiviCRM 3.2.5.