Scheduled Reminder Job finishes with result Failure

[nzampella]

Since I'm still having problems trying to run a CRON to kick off the scheduled jobs, I've been doing it manually.   I just came back from two weeks without Internet access (argghh), and so kicked them off again manually.

Checking the job logs, they all ran fine except the Scheduled Reminder job, which shows up with this:

0
Summary
Finished execution of Scheduled reminders sender with result: Failure, Error message: DB Error: syntax error
Details


Parameters parsed (and passed to API method):
a:1:{s:7:"version";i:3;}

Full message:
Finished execution of Scheduled reminders sender with result: Failure, Error message: DB Error: syntax error

I'm not sure where to look for the full error message.

[JohnFF]

Check out {your civi base dir} files/civicrm/ConfigAndLog. Look at the most recent file to be updated. Then search "error". These files can be quite large, so I tend to use vi as opposed to editing them all in notepad.

[nzampella]

Check out {your civi base dir} files/civicrm/ConfigAndLog. Look at the most recent file to be updated. Then search "error". These files can be quite large, so I tend to use vi as opposed to editing them all in notepad.

Thanks John for pointing me to the location.

I usually access the backend using Filezilla FTP, and The Semware Editor (TSE) viewing them on my Win7 desktop.   

[nzampella]

 

I totally forgot about this issue, as I've been putting out other fires on other websites I maintain.   Then after v4.5 was installed, the CRON job for the scheduled jobs quit, and this brought this back to the forefront.   Once I got the CRON jobs running again on Joomla, I looked at each job log and remembered this DB error.

SO ... here's the error backtrace block found in the CiviCRM logs:

Code: [Select]

$backTrace = #0 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(866): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/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 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/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 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/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 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/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 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
#8 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT e.contact_id as contact_id, e.id as entity_id, 'civicrm_participant' a...")
#9 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2442): DB_common->query("SELECT e.contact_id as contact_id, e.id as entity_id, 'civicrm_participant' a...")
#10 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1634): DB_DataObject->_query("SELECT e.contact_id as contact_id, e.id as entity_id, 'civicrm_participant' a...")
#11 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(325): DB_DataObject->query("SELECT e.contact_id as contact_id, e.id as entity_id, 'civicrm_participant' a...")
#12 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/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 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/ActionSchedule.php(1276): CRM_Core_DAO::executeQuery("SELECT e.contact_id as contact_id, e.id as entity_id, 'civicrm_participant' a...", (Array:1))
#14 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/ActionSchedule.php(1372): CRM_Core_BAO_ActionSchedule::buildRecipientContacts(3, "20141024112202", (Array:2))
#15 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/api/v3/Job.php(188): CRM_Core_BAO_ActionSchedule::processQueue(NULL, (Array:2))
#16 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/Civi/API/Provider/MagicFunctionProvider.php(86): civicrm_api3_job_send_reminder((Array:1))
#17 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/Civi/API/Kernel.php(95): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9))
#18 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/api/api.php(25): Civi\API\Kernel->run("Job", "send_reminder", (Array:1), NULL)
#19 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/JobManager.php(145): civicrm_api("Job", "send_reminder", (Array:1))
#20 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/JobManager.php(94): CRM_Core_JobManager->executeJob(Object(CRM_Core_ScheduledJob))
#21 /home/nwtaadmin/public_html/administrator/components/com_civicrm/civicrm/bin/cron.php(42): CRM_Core_JobManager->execute()

Hope this helps to identify the statement causing this error.