CiviCRM Community Forums (archive)

I've recently encountered a glitch in our system which is prohibiting people from donating to our organization and also prohibiting me as the administer from editing customer information in CiviCRM.  The message states: "DB error: no such table."  Can anyone tell me where to start looking to fix this?

CiviCRM 4.3.0
PHP 5.4.20
MySQL 5.5.34-log

We just upgraded to 4.4 and also are getting this "DB Error: No Such Field" when trying to run any of our Volunteer Reports (we created these). Worked before the upgrade, now getting the error. I hesitate to enable back trace (Security Alert: Debug should NOT be enabled for production sites as it can result in system configuration and authentication information being exposed to unauthorized visitors.). Note that we had added some custom fields to Contributions, but nothing that wasn't already allowed in basic CiviCRM. How else to figure out what table is being troublesome and how to fix it back to working? Thanks for any help here. Note that we are not programmers...

I'm working with Sandra on this issue - THANKS for the tip to look in ConfigAndLog - I found the following(it's really long)and I don't know how to go about fixing it!!  Thoughts?
________________________
Nov 19 12:01:39  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => CREATE TEMPORARY TABLE civireport_contribution_detail_temp2 AS SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_sort_name, contact_civireport.id as civicrm_contact_id, contacthonor.id as civicrm_contact_honor_id_honor, contribution_civireport.id as civicrm_contribution_contribution_id, contribution_civireport.financial_type_id as civicrm_contribution_financial_type_id, contribution_civireport.currency as civicrm_contribution_currency, contribution_civireport.receive_date as civicrm_contribution_receive_date, sum(contribution_soft_civireport.amount) as civicrm_contribution_total_amount_sum, note_civireport.note as civicrm_note_contribution_note, value_volunteer_hours_11_civireport.project_worked_on_24 as civicrm_value_volunteer_hours_11_custom_24 , contribution_civireport.contribution_status_id as civicrm_contribution_contribution_status_id
        FROM  civireport_contribution_detail_temp1 temp1_civireport
               INNER JOIN civicrm_contribution contribution_civireport
                       ON temp1_civireport.civicrm_contribution_contribution_id = contribution_civireport.id
               INNER JOIN civicrm_contribution_soft contribution_soft_civireport
                       ON contribution_soft_civireport.contribution_id = contribution_civireport.id
               INNER JOIN civicrm_contact      contact_civireport
                       ON contact_civireport.id = contribution_soft_civireport.contact_id
            LEFT JOIN civicrm_address address_civireport
                   ON contact_civireport.id = address_civireport.contact_id AND
                      address_civireport.is_primary = 1

            LEFT JOIN civicrm_email email_civireport
                   ON contact_civireport.id = email_civireport.contact_id AND
                      email_civireport.is_primary = 1

            LEFT JOIN civicrm_contact contacthonor
                      ON contacthonor.id = contribution_civireport.honor_contact_id
            LEFT JOIN civicrm_note note_civireport
                      ON ( note_civireport.entity_table = 'civicrm_contribution' AND
                           contribution_civireport.id = note_civireport.entity_id )  GROUP BY contact_civireport.id, contribution_civireport.id  [nativecode=1054 ** Unknown column 'value_volunteer_hours_11_civireport.project_worked_on_24' in 'field list']
    [type] => DB_Error
    [user_info] => CREATE TEMPORARY TABLE civireport_contribution_detail_temp2 AS SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_sort_name, contact_civireport.id as civicrm_contact_id, contacthonor.id as civicrm_contact_honor_id_honor, contribution_civireport.id as civicrm_contribution_contribution_id, contribution_civireport.financial_type_id as civicrm_contribution_financial_type_id, contribution_civireport.currency as civicrm_contribution_currency, contribution_civireport.receive_date as civicrm_contribution_receive_date, sum(contribution_soft_civireport.amount) as civicrm_contribution_total_amount_sum, note_civireport.note as civicrm_note_contribution_note, value_volunteer_hours_11_civireport.project_worked_on_24 as civicrm_value_volunteer_hours_11_custom_24 , contribution_civireport.contribution_status_id as civicrm_contribution_contribution_status_id
        FROM  civireport_contribution_detail_temp1 temp1_civireport
               INNER JOIN civicrm_contribution contribution_civireport
                       ON temp1_civireport.civicrm_contribution_contribution_id = contribution_civireport.id
               INNER JOIN civicrm_contribution_soft contribution_soft_civireport
                       ON contribution_soft_civireport.contribution_id = contribution_civireport.id
               INNER JOIN civicrm_contact      contact_civireport
                       ON contact_civireport.id = contribution_soft_civireport.contact_id
            LEFT JOIN civicrm_address address_civireport
                   ON contact_civireport.id = address_civireport.contact_id AND
                      address_civireport.is_primary = 1

            LEFT JOIN civicrm_email email_civireport
                   ON contact_civireport.id = email_civireport.contact_id AND
                      email_civireport.is_primary = 1

            LEFT JOIN civicrm_contact contacthonor
                      ON contacthonor.id = contribution_civireport.honor_contact_id
            LEFT JOIN civicrm_note note_civireport
                      ON ( note_civireport.entity_table = 'civicrm_contribution' AND
                           contribution_civireport.id = note_civireport.entity_id )  GROUP BY contact_civireport.id, contribution_civireport.id  [nativecode=1054 ** Unknown column 'value_volunteer_hours_11_civireport.project_worked_on_24' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TEMPORARY TABLE civireport_contribution_detail_temp2 AS SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_sort_name, contact_civireport.id as civicrm_contact_id, contacthonor.id as civicrm_contact_honor_id_honor, contribution_civireport.id as civicrm_contribution_contribution_id, contribution_civireport.financial_type_id as civicrm_contribution_financial_type_id, contribution_civireport.currency as civicrm_contribution_currency, contribution_civireport.receive_date as civicrm_contribution_receive_date, sum(contribution_soft_civireport.amount) as civicrm_contribution_total_amount_sum, note_civireport.note as civicrm_note_contribution_note, value_volunteer_hours_11_civireport.project_worked_on_24 as civicrm_value_volunteer_hours_11_custom_24 , contribution_civireport.contribution_status_id as civicrm_contribution_contribution_status_id
        FROM  civireport_contribution_detail_temp1 temp1_civireport
               INNER JOIN civicrm_contribution contribution_civireport
                       ON temp1_civireport.civicrm_contribution_contribution_id = contribution_civireport.id
               INNER JOIN civicrm_contribution_soft contribution_soft_civireport
                       ON contribution_soft_civireport.contribution_id = contribution_civireport.id
               INNER JOIN civicrm_contact      contact_civireport
                       ON contact_civireport.id = contribution_soft_civireport.contact_id
            LEFT JOIN civicrm_address address_civireport
                   ON contact_civireport.id = address_civireport.contact_id AND
                      address_civireport.is_primary = 1

            LEFT JOIN civicrm_email email_civireport
                   ON contact_civireport.id = email_civireport.contact_id AND
                      email_civireport.is_primary = 1

            LEFT JOIN civicrm_contact contacthonor
                      ON contacthonor.id = contribution_civireport.honor_contact_id
            LEFT JOIN civicrm_note note_civireport
                      ON ( note_civireport.entity_table = 'civicrm_contribution' AND
                           contribution_civireport.id = note_civireport.entity_id )  GROUP BY contact_civireport.id, contribution_civireport.id  [nativecode=1054 ** Unknown column 'value_volunteer_hours_11_civireport.project_worked_on_24' in 'field list']"]
)


Nov 19 12:01:39  [info] $backTrace = #0 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(197): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "CREATE TEMPORARY TABLE civireport_contribution_detail_temp2 AS SELECT SQL_CAL...")
#4 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "CREATE TEMPORARY TABLE civireport_contribution_detail_temp2 AS SELECT SQL_CAL...")
#5 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "CREATE TEMPORARY TABLE civireport_contribution_detail_temp2 AS SELECT SQL_CAL...", "DB_Error", TRUE)
#6 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'value_volunteer_hours_11_civireport.project_worked_on...")
#7 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("CREATE TEMPORARY TABLE civireport_contribution_detail_temp2 AS SELECT SQL_CAL...")
#9 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2421): DB_common->query("CREATE TEMPORARY TABLE civireport_contribution_detail_temp2 AS SELECT SQL_CAL...")
#10 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("CREATE TEMPORARY TABLE civireport_contribution_detail_temp2 AS SELECT SQL_CAL...")
#11 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(158): DB_DataObject->query("CREATE TEMPORARY TABLE civireport_contribution_detail_temp2 AS SELECT SQL_CAL...")
#12 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(905): CRM_Core_DAO->query("CREATE TEMPORARY TABLE civireport_contribution_detail_temp2 AS SELECT SQL_CAL...", TRUE)
#13 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/CRM/Report/Form/Contribute/Detail.php(599): CRM_Core_DAO::executeQuery("CREATE TEMPORARY TABLE civireport_contribution_detail_temp2 AS SELECT SQL_CAL...")
#14 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(261): CRM_Report_Form_Contribute_Detail->postProcess()
#15 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Submit.php(73): CRM_Core_Form->mainProcess()
#16 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Submit->perform(Object(CRM_Report_Form_Contribute_Detail), "submit")
#17 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Report_Form_Contribute_Detail), "submit")
#18 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(345): HTML_QuickForm_Page->handle("submit")
#19 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(117): CRM_Core_Controller->run()
#20 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/CRM/Report/Page/Instance.php(103): CRM_Utils_Wrapper->run("CRM_Report_Form_Contribute_Detail", NULL, NULL)
#21 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(323): CRM_Report_Page_Instance->run((Array:4), NULL)
#22 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:14))
#23 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#24 /home/hornfarm/www/www/wp-content/plugins/civicrm/civicrm.php(463): CRM_Core_Invoke::invoke