CiviCRM Community Forums (archive)

As the title indicates, I cannot interview respondents.  I am able to reserve no problem, but when i goto interview, I get the errors below.  Please advise, thanks!

Drupal 7
Civi 4.1.0

backTrace

/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 159
, handle,
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 968
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2428
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1614
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 166
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 897
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/CRM/Campaign/BAO/Query.php, executeQuery, 488
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/CRM/Campaign/Form/Search.php, voterClause, 557
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/CRM/Campaign/Form/Search.php, voterClause, 205
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/CRM/Core/Form.php, preProcess, 329
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Refresh.php, buildForm, 65
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 284
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 227
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 454
, civicrm_invoke,
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/includes/menu.inc, call_user_func_array, 516
/srv/bindings/3d985b384585492987d32c8c8038a65b/code/index.php, menu_execute_active_handler, 21
Database Error Code: Can't create table 'pantheon.civicrm_survey_respondent_temp_7854cc7f06708bca2d025468690a9301' (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_7854cc7f06708bca2d025468690a9301 (
            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 'pantheon.civicrm_survey_respondent_temp_7854cc7f06708bca2d025468690a9301' (errno: 150)]
    [type] => DB_Error
    [user_info] =>
     CREATE TEMPORARY TABLE civicrm_survey_respondent_temp_7854cc7f06708bca2d025468690a9301 (
            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 'pantheon.civicrm_survey_respondent_temp_7854cc7f06708bca2d025468690a9301' (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_7854cc7f06708bca2d025468690a9301 (
            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 'pantheon.civicrm_survey_respondent_temp_7854cc7f06708bca2d025468690a9301' (errno: 150)]"]
)

Thank Eileen, wee are using 4.1.0 and have had other issues (profiles& subcontact types which are reportedly fixed in 4.1.5.  I will go ahead and upgrade and see if this solves the problem.

Another question in lieu of starting a new post...Ive read the civibook portion on surveys, and unless Ive missed something I cant seem to find how to administer the surveys online?  In other words contacts can access a survey form to record their responses (each of the book's examples seem to focus on an interviewer recording the responses).  Perhaps this is where the standalone profile comes into play? 

When viewing the output of the standalone form in html, I receive the error "Profile search, view and edit are not supported for Profiles which include fields for more than one record type."  Do you think this might be solved by upgrade?

Thanks!!