Trouble Interviewing Respondents for CiviSurvey

[Hardwick]

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,

[Eileen]

one possibility is a data integrity problem - ie, some records in the civicrm_activity_contact table (assuming 4.4) where the contact id refers to contacts that no longer exist.

If

SELECT * FROM civicrm_activity_contact ac LEFT JOIN civicrm_contact c ON c.id = ac.contact_id WHERE c.id IS NULL

returns some lines then it is a data integrity problem

[Hardwick]

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

[Hardwick]

We're using 4.0.5. The whole flow makes sense, create campaign, select the groups available for that campaign (in campaign), conduct the survey then click reserve respondents or reserve and interview and get the same error. Can't for the life of it figure out what's incorrect here. The contacts definitely exist so  not quite sure what we need to be assessing in the error message which gives same as below aka "CONSTRAINT FK_civicrm_survey_respondent FOREIGN KEY (survey_contact_id) REFERENCES civicrm_contact(id) ON DELETE CASCADE ) [nativecode=1005 ** Can't create table 'sitename_civicrm.civicrm_survey_respondent_temp_dd6b61c2170f530165ac9e6df2b4b582' (errno: 150)]
    [type] => DB_Error
    [user_info] =>
     CREATE TEMPORARY TABLE civicrm_survey_respondent_temp_dd6b61c2170f530165ac9e6df2b4b582 (
            id int unsigned NOT NULL AUTO_INCREMENT,
            survey_contact_id int unsigned NOT NULL,

Please let us know if more of the error would help. TOtally stumped. Valuable functionality but we're clearly not configuring it right. H

[Hardwick]

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....

[Hardwick]

Any one have any more thoughts on this? The one ray of hope was we noticed that some of the campaign permissions for admin were off, but logged in and corrected these, still nothing. We generate the error with each new survey we try to create. Is there some compatibility issue with the civi version we are using 4.0.5. Wouldnt think so since all other functions work. If still no response we will just set about to debugging it. any feedback appreciated. H