Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.5.3
-
Fix Version/s: 4.5.4
-
Component/s: Core CiviCRM
-
Labels:None
-
Documentation Required?:None
Description
Scheduled reminder job throws a fatal error (see below) if the reminder has been previously saved with 'Repeat' = TRUE, and then the user edits the reminder to set an absolute date. The is_repeat property in action_schedule is NOT reset to 0 - which then causes the fatal DB error below.
=============================
Nov 05 14:03:38 [info] $backTrace = #0 /Users/dgg/git/crm_v4.5/CRM/Core/Error.php(866): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /Users/dgg/git/crm_v4.5/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /Users/dgg/git/crm_v4.5/packages/DB.php(975): PEAR_Error->PEAR_Error("DB Error: syntax error", -2, 16, (Array:2), "SELECT e.contact_id as contact_id, e.id as entity_id, 'civicrm_participant' a...")
#4 /Users/dgg/git/crm_v4.5/packages/PEAR.php(564): DB_Error->DB_Error(-2, 16, (Array:2), "SELECT e.contact_id as contact_id, e.id as entity_id, 'civicrm_participant' a...")
#5 /Users/dgg/git/crm_v4.5/packages/DB/common.php(1905): PEAR->raiseError(NULL, -2, NULL, NULL, "SELECT e.contact_id as contact_id, e.id as entity_id, 'civicrm_participant' a...", "DB_Error", TRUE)
#6 /Users/dgg/git/crm_v4.5/packages/DB/mysql.php(899): DB_common->raiseError(-2, NULL, NULL, NULL, "1064 ** You have an error in your SQL syntax; check the manual that correspon...")
#7 /Users/dgg/git/crm_v4.5/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
#8 /Users/dgg/git/crm_v4.5/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT e.contact_id as contact_id, e.id as entity_id, 'civicrm_participant' a...")
#9 /Users/dgg/git/crm_v4.5/packages/DB/DataObject.php(2442): DB_common->query("SELECT e.contact_id as contact_id, e.id as entity_id, 'civicrm_participant' a...")
#10 /Users/dgg/git/crm_v4.5/packages/DB/DataObject.php(1634): DB_DataObject->_query("SELECT e.contact_id as contact_id, e.id as entity_id, 'civicrm_participant' a...")
#11 /Users/dgg/git/crm_v4.5/CRM/Core/DAO.php(325): DB_DataObject->query("SELECT e.contact_id as contact_id, e.id as entity_id, 'civicrm_participant' a...")
#12 /Users/dgg/git/crm_v4.5/CRM/Core/DAO.php(1116): CRM_Core_DAO->query("SELECT e.contact_id as contact_id, e.id as entity_id, 'civicrm_participant' a...", TRUE)
#13 /Users/dgg/git/crm_v4.5/CRM/Core/BAO/ActionSchedule.php(1286): CRM_Core_DAO::executeQuery("SELECT e.contact_id as contact_id, e.id as entity_id, 'civicrm_participant' a...", (Array:1))
#14 /Users/dgg/git/crm_v4.5/CRM/Core/BAO/ActionSchedule.php(1382): CRM_Core_BAO_ActionSchedule::buildRecipientContacts(3, "20141105140338", (Array:2))
#15 /Users/dgg/git/crm_v4.5/api/v3/Job.php(188): CRM_Core_BAO_ActionSchedule::processQueue(NULL, (Array:2))
#16 /Users/dgg/git/crm_v4.5/Civi/API/Provider/MagicFunctionProvider.php(86): civicrm_api3_job_send_reminder((Array:1))
#17 /Users/dgg/git/crm_v4.5/Civi/API/Kernel.php(95): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9))
#18 /Users/dgg/git/crm_v4.5/api/api.php(25): Civi\API\Kernel->run("job", "send_reminder", (Array:1), NULL)
#19 /Users/dgg/git/crm_v4.5/CRM/Core/JobManager.php(145): civicrm_api("job", "send_reminder", (Array:1))
#20 /Users/dgg/git/crm_v4.5/CRM/Core/JobManager.php(124): CRM_Core_JobManager->executeJob(Object(CRM_Core_ScheduledJob))
#21 /Users/dgg/git/crm_v4.5/CRM/Admin/Page/Job.php(156): CRM_Core_JobManager->executeJobById("8")
#22 /Users/dgg/git/crm_v4.5/CRM/Core/Page/Basic.php(182): CRM_Admin_Page_Job->browse(NULL, NULL)
#23 /Users/dgg/git/crm_v4.5/CRM/Admin/Page/Job.php(139): CRM_Core_Page_Basic->run()
#24 /Users/dgg/git/crm_v4.5/CRM/Core/Invoke.php(331): CRM_Admin_Page_Job->run((Array:3), NULL)
#25 /Users/dgg/git/crm_v4.5/CRM/Core/Invoke.php(75): CRM_Core_Invoke::runItem((Array:13))
#26 /Users/dgg/git/crm_v4.5/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#27 /Users/dgg/git/crm_v4.5/drupal/civicrm.module(457): CRM_Core_Invoke::invoke((Array:3))
#28 [internal function](): civicrm_invoke("admin", "job")
#29 /Users/dgg/htdocs/drupal7/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2))
#30 /Users/dgg/htdocs/drupal7/index.php(21): menu_execute_active_handler()
#31