CiviCRM Community Forums (archive)

I'm attempting to "Reserve Respondents" and get the following error. I tried to execute the CREATE TEMPORARY TABLE query as root mysql user and got the same error.

Using CiviEngage for the first time, so not sure if I'm posting in the right forum section, or does this go into installation? It seems to have installed fine, with the provided xml file importing successfully. Thank you for any help!


Database Error Code: Can't create table 'example.civicrm_survey_respondent_temp_d8ee8e429cf2f9d814ac6379d08f8281' (errno: 150), 1005
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -15
    [message] => DB Error: can not create
    [mode] => 16
    [debug_info] =>
     CREATE TEMPORARY TABLE civicrm_survey_respondent_temp_d8ee8e429cf2f9d814ac6379d08f8281 (
            id int unsigned NOT NULL AUTO_INCREMENT,
            survey_contact_id int unsigned NOT NULL, 
PRIMARY KEY ( id ),
 CONSTRAINT FK_civicrm_survey_respondent FOREIGN KEY (survey_contact_id) REFERENCES civicrm_contact(id) ON DELETE CASCADE ) [nativecode=1005 ** Can't create table 'example.civicrm_survey_respondent_temp_d8ee8e429cf2f9d814ac6379d08f8281' (errno: 150)]
    [type] => DB_Error
    [user_info] =>
     CREATE TEMPORARY TABLE civicrm_survey_respondent_temp_d8ee8e429cf2f9d814ac6379d08f8281 (
            id int unsigned NOT NULL AUTO_INCREMENT,
            survey_contact_id int unsigned NOT NULL, 
PRIMARY KEY ( id ),
 CONSTRAINT FK_civicrm_survey_respondent FOREIGN KEY (survey_contact_id) REFERENCES civicrm_contact(id) ON DELETE CASCADE ) [nativecode=1005 ** Can't create table 'example.civicrm_survey_respondent_temp_d8ee8e429cf2f9d814ac6379d08f8281' (errno: 150)]
    [to_string] => [db_error: message="DB Error: can not create" code=-15 mode=callback callback=CRM_Core_Error::handle prefix="" info="
     CREATE TEMPORARY TABLE civicrm_survey_respondent_temp_d8ee8e429cf2f9d814ac6379d08f8281 (
            id int unsigned NOT NULL AUTO_INCREMENT,
            survey_contact_id int unsigned NOT NULL, 
PRIMARY KEY ( id ),
 CONSTRAINT FK_civicrm_survey_respondent FOREIGN KEY (survey_contact_id) REFERENCES civicrm_contact(id) ON DELETE CASCADE ) [nativecode=1005 ** Can't create table 'example.civicrm_survey_respondent_temp_d8ee8e429cf2f9d814ac6379d08f8281' (errno: 150)]"]
)


I forgot to mention that the mysql user does have CREATE TEMPORARY TABLE privilege.

I created another survey and it worked okay at first, then I get sporadic errors. I think I'm just doing something I'm not supposed to do, and rather than giving doing error checking I'm getting this DB error?

Well, because I really just wanted to do a phone bank, so I'm actually reading the CiviEngage chapter and it seems to help me do what I want