CiviCRM Community Forums (archive)

hi,

i have give these credentials to it. civicrm/bin/civimail.cronjob.php?name=ain&pass=pard&key=8cb4edb3630cc
and it is giving me a blank page nothing on it. but i have check the mailing list and that kicks off. any pointers where is the problem?
/civicrm/bin/action.cronjob.php?name=afin&pass=pword&key=8cb4edb363dfgf0bd64a1e

i have setup the schedule reminder but i am getting an error when i am using action.cronjob.php. which is DB Error : syntax error
this file even shows the blank page again after giving the values.

Hi We're now getting this on a 3.4.8 when running:

action.cronjob.php


    [type] => DB_Error
    [user_info] =>
INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_schedule_id)
SELECT  as contact_id, e.id as entity_id, 'civicrm_activity' as entity_table, 1 as action_schedule_id
FROM civicrm_activity e
INNER JOIN civicrm_contact c ON c.id =
LEFT JOIN civicrm_action_log reminder ON reminder.contact_id =  AND
reminder.entity_id    = e.id AND
reminder.entity_table = 'civicrm_activity' AND
reminder.action_schedule_id = 1
WHERE e.activity_type_id IN (30,31,21,1,2,22,36) AND e.status_id IN (1) AND  e.is_current_revision = 1  AND  e.is_deleted = 0  AND c.is_deleted = 0 AND reminder.id IS NULL AND '20120328091601' >= DATE_SUB(e.activity_date_time, INTERVAL 2 day) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as contact_id, e.id as entity_id, 'civicrm_activity' as entity_table, 1 as actio' at line 2]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="
INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_schedule_id)
SELECT  as contact_id, e.id as entity_id, 'civicrm_activity' as entity_table, 1 as action_schedule_id
FROM civicrm_activity e
INNER JOIN civicrm_contact c ON c.id =
LEFT JOIN civicrm_action_log reminder ON reminder.contact_id =  AND
reminder.entity_id    = e.id AND
reminder.entity_table = 'civicrm_activity' AND
reminder.action_schedule_id = 1
WHERE e.activity_type_id IN (30,31,21,1,2,22,36) AND e.status_id IN (1) AND  e.is_current_revision = 1  AND  e.is_deleted = 0  AND c.is_deleted = 0 AND reminder.id IS NULL AND '20120328091601' >= DATE_SUB(e.activity_date_time, INTERVAL 2 day) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as contact_id, e.id as entity_id, 'civicrm_activity' as entity_table, 1 as actio' at line 2]"]
)


Any ideas

Hi Lobo 

ON 4.1.1 I get a lovely 500 from wget:

PHP Fatal error:  require_once() [<a href='function.require'>function.require</a>]: Failed opening required '../civicrm.config.php' (include_path='.:/usr/local/lib/php') in /var/www/html/training/drupal-7.12/sites/all/modules/civicrm/bin/deprecated/action.cronjob.php on line 56" while reading response header from upstream, client: 77.99.22.187, server: foopants.co.uk, request: "GET /sites/all/modules/civicrm/bin/deprecated/action.cronjob.php?name=myusername&pass=mypassword&key=9211091289874ac31657465394d4f3ad HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "foopants.co.uk"

my civicrm.config.php is in sites/all/modules/civicrm/civicrm.config.php

So I've added a  ../ to line 56

        require_once '../../civicrm.config.php';

I as I'm guessing the fact that the script now lives in bin/deprecated needs it.

That now runs correctly and gives a 200 rather than a 500.

Cheers

Bails

So there's little chance of a fix in 4.0.8?