CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Scheduled Reminder Job finishes with result Failure
Pages: [1]

Author Topic: Scheduled Reminder Job finishes with result Failure  (Read 4083 times)

nzampella

  • I post occasionally
  • **
  • Posts: 61
  • Karma: 2
  • CiviCRM version: 4.5.3
  • CMS version: Joomla 3.3.6
  • MySQL version: 5.5.36
  • PHP version: 5.4.31
Scheduled Reminder Job finishes with result Failure
June 26, 2014, 02:18:44 pm
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:

Quote
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

  • I post frequently
  • ***
  • Posts: 235
  • Karma: 6
  • CiviCRM version: 4.4.13
  • CMS version: Drupal 7.28
  • MySQL version: 5.5.31-1
  • PHP version: 5.3.27
Re: Scheduled Reminder Job finishes with result Failure
June 30, 2014, 05:46:29 am
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.
If you like empowering charities in a free and open way, then you're going to love Civi.

Email Amender: https://civicrm.org/extensions/email-amender
UK Phone Validator: https://civicrm.org/extensions/uk-phone-number-validator
http://civifirst.com
https://twitter.com/civifirst

nzampella

  • I post occasionally
  • **
  • Posts: 61
  • Karma: 2
  • CiviCRM version: 4.5.3
  • CMS version: Joomla 3.3.6
  • MySQL version: 5.5.36
  • PHP version: 5.4.31
Re: Scheduled Reminder Job finishes with result Failure
July 05, 2014, 12:09:01 pm
Quote from: JohnFF on June 30, 2014, 05:46:29 am
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 post occasionally
  • **
  • Posts: 61
  • Karma: 2
  • CiviCRM version: 4.5.3
  • CMS version: Joomla 3.3.6
  • MySQL version: 5.5.36
  • PHP version: 5.4.31
Re: Scheduled Reminder Job finishes with result Failure
October 24, 2014, 11:52:44 am
 :-X

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.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Scheduled Reminder Job finishes with result Failure

This forum was archived on 2017-11-26.