Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.5.2
-
Fix Version/s: 4.5.3
-
Component/s: Core CiviCRM
-
Labels:
-
Documentation Required?:None
Description
Running a scheduled reminder on an event is throwing 1 or 2 different fatal errors:
- if the reminder date is set to N days prior to event start date, I'm getting a fatal as shown below when running scheduled job (see my comment for more details)
- If the reminder date is set to a fixed date value (as in this screenshot = http://forum.civicrm.org/index.php?action=dlattach;topic=34496.0;attach=12114;image), then it looks like a separate SQL query error may be happening
---- original post —
CiviCRM 4.5.2 running on WordPress 4.0.
When attempting to run the Send Scheduled Reminders (send_reminder) with an event reminder, the following is found in the job log:
0
Summary
Finished execution of Send Scheduled Reminders with result: Failure, Error message: A fatal error was triggered
Details
Parameters parsed (and passed to API method):
a:1:
Full message:
Finished execution of Send Scheduled Reminders with result: Failure, Error message: A fatal error was triggered
The following information is in the server log file:
Oct 17 13:38:17 [info] $Fatal Error Details = Array
(
[message] =>
[code] =>
)
Oct 17 13:38:17 [info] $backTrace = #0 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(328): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(946): CRM_Core_Error::fatal()
#2 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/FinancialTrxn.php(103): CRM_Core_DAO::getFieldValue("CRM_Contribute_BAO_Contribution", NULL, "financial_type_id")
#3 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/CRM/Contribute/BAO/Contribution.php(3366): CRM_Core_BAO_FinancialTrxn::getBalanceTrxnAmt(NULL)
#4 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/ActionSchedule.php(811): CRM_Contribute_BAO_Contribution::getPaymentInfo("10", "event")
#5 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/ActionSchedule.php(1373): CRM_Core_BAO_ActionSchedule::sendMailings(3, "20141017133817")
#6 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/api/v3/Job.php(188): CRM_Core_BAO_ActionSchedule::processQueue(NULL, (Array:2))
#7 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/Civi/API/Provider/MagicFunctionProvider.php(86): civicrm_api3_job_send_reminder((Array:1))
#8 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/Civi/API/Kernel.php(95): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9))
#9 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/api/api.php(25): Civi\API\Kernel->run("job", "send_reminder", (Array:1), NULL)
#10 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/JobManager.php(145): civicrm_api("job", "send_reminder", (Array:1))
#11 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/JobManager.php(124): CRM_Core_JobManager->executeJob(Object(CRM_Core_ScheduledJob))
#12 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/CRM/Admin/Page/Job.php(156): CRM_Core_JobManager->executeJobById("8")
#13 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Page/Basic.php(182): CRM_Admin_Page_Job->browse(NULL, NULL)
#14 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/CRM/Admin/Page/Job.php(139): CRM_Core_Page_Basic->run()
#15 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(331): CRM_Admin_Page_Job->run((Array:3), NULL)
#16 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(75): CRM_Core_Invoke::runItem((Array:13))
#17 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#18 /home/montgomery/www/www/wp-content/plugins/civicrm/civicrm.php(506): CRM_Core_Invoke::invoke((Array:3))
#19 [internal function](): CiviCRM_For_WordPress->invoke("")
#20 /home/montgomery/www/www/wp-includes/plugin.php(505): call_user_func_array((Array:2), (Array:1))
#21 /home/montgomery/www/www/wp-admin/admin.php(212): do_action("toplevel_page_CiviCRM")
#22
Steps the reproduce:
Create an event dated to start one week in the future.
Configured a scheduled reminder for the event set to be sent one week before event start date.
Register a contact for the event.
Execute the send_reminder job.
More information can be found here http://forum.civicrm.org/index.php/topic,34506.0.html