CiviCRM Community Forums (archive)

Previously I posted about a civicampaign reserve respondents error "can't create temporary table."

Now I have a colleague on a different web site also running civi 3.4.8 who is getting an somewhat similar, but different, error when trying to reserve respondents.  It seems also to be related to a problem with the temporary table created but this time the error is number 1054 "unknown column in 'where clause'> 

Database Error Code: Unknown column 'civicrm_survey_respondent_temp_a3afab476ea10ffa610ce1b38526a9a9.' in 'where clause', 1054

Can anyone help with this?


Database Error Code: Unknown column 'civicrm_survey_respondent_temp_a3afab476ea10ffa610ce1b38526a9a9.' in 'where clause', 1054
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )
    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT DISTINCT(contact_a.id) as id  FROM civicrm_contact contact_a  LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_111` ON contact_a.id = `civicrm_group_contact_cache_111`.contact_id   WHERE  ( `civicrm_group_contact_cache_111`.group_id = 111 )  AND (contact_a.is_deleted = 0) AND ( civicrm_survey_respondent_temp_a3afab476ea10ffa610ce1b38526a9a9.survey_contact_id IS NULL )   LIMIT 0, 50  [nativecode=1054 ** Unknown column 'civicrm_survey_respondent_temp_a3afab476ea10ffa610ce1b38526a9a9.' in 'where clause']
    [type] => DB_Error
    [user_info] => SELECT DISTINCT(contact_a.id) as id  FROM civicrm_contact contact_a  LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_111` ON contact_a.id = `civicrm_group_contact_cache_111`.contact_id   WHERE  ( `civicrm_group_contact_cache_111`.group_id = 111 )  AND (contact_a.is_deleted = 0) AND ( civicrm_survey_respondent_temp_a3afab476ea10ffa610ce1b38526a9a9.survey_contact_id IS NULL )   LIMIT 0, 50  [nativecode=1054 ** Unknown column 'civicrm_survey_respondent_temp_a3afab476ea10ffa610ce1b38526a9a9.' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT DISTINCT(contact_a.id) as id  FROM civicrm_contact contact_a  LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_111` ON contact_a.id = `civicrm_group_contact_cache_111`.contact_id   WHERE  ( `civicrm_group_contact_cache_111`.group_id = 111 )  AND (contact_a.is_deleted = 0) AND ( civicrm_survey_respondent_temp_a3afab476ea10ffa610ce1b38526a9a9.survey_contact_id IS NULL )   LIMIT 0, 50  [nativecode=1054 ** Unknown column 'civicrm_survey_respondent_temp_a3afab476ea10ffa610ce1b38526a9a9.' in 'where clause']"]
)


I can't seem to reproduce the error on the demo site.  But the demo is 4.1.  We are using version 3.4.8.  Is there a demo anymore for 3.4?  Could there be a code difference between this versions? 

We could upgrade, but we aren't ready to upgrade to drupal 7, and I think civi 4.1 requires drupal 7?  Yes?