CiviCRM Community Forums (archive)

Great relief to see that civisurvey (apparently) allows for integration of survey data into civicrm. However, we can never quite get it to work properly. We set up a campaign, create the survey and then designate the groups to be interviewed - which apparently only works if they are part of the original campaign (?) however, once we go to reserve and interview, or after we reserve first and then attempt to click "interview" we keep getting array errors about not being able to create the table, makes no sense, should work, what the heck are we doing wrong?? Any asssistance greatly appreciated. H


   CREATE TEMPORARY TABLE civicrm_survey_respondent_temp_0ca871714adbf3327f838309fbb4a0a1 (
            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 'sitename.com_civicrm.civicrm_survey_respondent_temp_0ca871714adbf3327f838309fbb4a0a1' (errno: 150)]
    [type] => DB_Error
    [user_info] =>
     CREATE TEMPORARY TABLE civicrm_survey_respondent_temp_0ca871714adbf3327f838309fbb4a0a1 (
            id int unsigned NOT NULL AUTO_INCREMENT,
            survey_contact_id int unsigned NOT NULL,

Thank you Eileen. We will try it and report back the results.

IN Spite of the error we now see the msg :  Reservation has been added for 3 Contact(s). Reservation has been added for 3 Contact(s). Reservation has been added for 3 Contact(s). 
Respondent(s) has been added to Test group(s). Reservation has been added for 3 Contact(s).

But still cant conduct the survey....