1

When trying to have a volunteer report there is this error in WP+CiviCRM The error logs are:

From logviewer

[debug] $backTrace = #0 /home/xxxx/xxxx/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(441): CRM_Core_Error::backtrace("backTrace", TRUE)
[error]
[debug] $backTrace = #0 /home/xxxx/xxxx/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(954): CRM_Core_Error::backtrace("backTrace", TRUE)
[error] $Fatal Error Details = Array 

From CiviCRM Report Error by email extension

***ERROR***
message:            DB Error: unknown error
code:               
exception:          PEAR_Exception Object
(
    [cause:protected] => DB_Error Object
        (
            [error_message_prefix] =>
            [mode] => 16
            [level] => 1024
            [code] => -1
            [message] => DB Error: unknown error
            [userinfo] => SELECT SQL_CALC_FOUND_ROWS project_civireport.title as project_project, civicrm_contact_assignee_civireport.sort_name as civicrm_contact_contact_assignee, activity_civireport.id as civicrm_activity_id, activity_civireport.source_record_id as civicrm_activity_source_record_id, activity_civireport.activity_type_id as civicrm_activity_activity_type_id, activity_civireport.subject as civicrm_activity_activity_subject, activity_civireport.activity_date_time as civicrm_activity_activity_date_time, activity_civireport.status_id as civicrm_activity_status_id, activity_assignment_civireport.contact_id as civicrm_activity_assignment_contact_id, activity_target_civireport.contact_id as civicrm_activity_target_contact_id,
activity_source_civireport.contact_id as civicrm_activity_source_contact_id, cg.volunteer_role_id_1 as role_role, cg.time_scheduled_in_minutes_2 as time_scheduled_time_scheduled, cg.time_completed_in_minutes_3 as time_completed_time_completed, case_activity_civireport.case_id as civicrm_case_activity_case_id , civicrm_contact_assignee_civireport.sort_name as civicrm_contact_sort_name 
        FROM civicrm_activity activity_civireport
             LEFT JOIN civicrm_activity_contact  activity_target_civireport
                    ON activity_civireport.id = activity_target_civireport.activity_id AND
                       activity_target_civireport.record_type_id = 3
             LEFT JOIN civicrm_value_civivolunteer_ cg
                    ON activity_civireport.id = cg.entity_id
             LEFT JOIN civicrm_volunteer_need n
                    ON n.id = cg.volunteer_need_id_
             LEFT JOIN civicrm_option_value ov_civireport ON ( ov_civireport.value = cg.volunteer_role_id_1 AND ov_civirep...

***LAST ERROR***
Array
(
    [type] => 16384
    [message] => Calling the "Symfony\Component\EventDispatcher\EventDispatcherInterface::dispatch()" method with the event name as the first argument is deprecated since Symfony 4.3, pass it as the second argument and provide the event object as the first argument instead.
    [file] => /home/adraitalia/public_html/wp-content/plugins/civicrm/civicrm/vendor/symfony/event-dispatcher/EventDispatcher.php
    [line] => 58
)

And this 

***BACKTRACE***
#0 /home/xxxx/xxxx/wp-content/uploads/civicrm/ext/ca.bidon.reporterror/CRM/ReportError/Utils.php(31): reporterror_civicrm_generatereport("xxxx", (Array:3), NULL, (Array:0))
#1 /home/xxxx/xxxx/wp-content/uploads/civicrm/ext/ca.bidon.reporterror/CRM/ReportError/Handler/FormsNoReferer.php(58): CRM_ReportError_Utils::sendReport((Array:3), (Array:0))
#2 /home/xxxx/xxxx/wp-content/uploads/civicrm/ext/ca.bidon.reporterror/reporterror.php(149): CRM_ReportError_Handler_FormsNoReferer::handler((Array:3), (Array:0))
#3 /home/xxxx/xxxx/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(429): reporterror_civicrm_handler((Array:3))
#4 /home/xxxx/xxxx/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(39): CRM_Core_Error::handleUnhandledException(Object(PEAR_Exception))
#5 /home/xxxx/xxxx/wp-content/plugins/civicrm/civicrm.php(1199): CRM_Core_Invoke::invoke((Array:4))
#6 /home/xxxx/xxxxl/wp-includes/class-wp-hook.php(307): CiviCRM_For_WordPress->invoke("")
#7 /home/xxxx/xxxx/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters("", (Array:1))
#8 /home/xxxx/xxxx/wp-includes/plugin.php(476): WP_Hook->do_action((Array:1))
#9 /home/xxxx/xxxx/wp-admin/admin.php(259): do_action("toplevel_page_CiviCRM")
#10 {main}

Thank you for help

2
  • can you add full sql code, it might have actual reason of DB: unknown error. Commented Oct 3, 2022 at 12:19
  • Custom field configuration for civivolunteer has become corrupted in some way. You can see it because in the query it says e.g. civicrm_value_civivolunteer_ which should have the full table name but is missing the last bit.
    – Demerit
    Commented Oct 3, 2022 at 18:30

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.