CiviCRM Community Forums (archive)

Filed issue with patch: http://issues.civicrm.org/jira/browse/CRM-10160

I tried using the pre/post hooks on "ActionLog", but I'm not getting the info I expect.

What's odd (to me) is this: The hooks are called in CRM/BAO/ActionLog.php right before and after $actionLog->save() is called. If I dump $actionLog at that time, not much info (below). But yet the db table civicrm_action_log does have all of the info (specifically, the entity_id and entity_table, which is what I would need here). So how is the save() method writing information to the db when it's not handed that information?

(Object) CRM_Core_DAO_ActionLog
id (String, 2 characters ) 14
contact_id (NULL)
entity_id (NULL)
entity_table (NULL)
action_schedule_id (NULL)
action_date_time (String, 14 characters ) 20120503093809
is_error (Integer) 0
message (String, 4 characters ) null
repetition_number (NULL)
_DB_DataObject_version (String, 6 characters ) 1.8.12
__table (String, 18 characters ) civicrm_action_log
N (Integer) 0
_database_dsn (String, 0 characters )
_database_dsn_md5 (String, 32 characters ) d2b5c81ea8c5d3785e52dcb4ff1c7c57
_database (String, 8 characters ) mima_civ
_query (Array, 7 elements)
condition (String, 0 characters )
group_by (String, 0 characters )
order_by (String, 0 characters )
having (String, 0 characters )
limit_start (String, 0 characters )
limit_count (String, 0 characters )
data_select (String, 1 characters ) *
_DB_resultid (NULL)
_resultFields (Boolean) FALSE
_link_loaded (Boolean) FALSE
_join (String, 0 characters )
_lastError (Boolean) FALSE
Krumo version 0.2a | http://krumo.sourceforge.net Called from /home/mima/public_html/sites/all/modules/civicrm/CRM/Core/BAO/ActionLog.php, line 75 


Hi, I really hope you guys can help.

I read the posts above as I was having the same problem, I looked at your Patch and applied it. But the reminders are still not working and I am pulling my hair out. The error in the job log is:

Finished execution of Send Scheduled Reminders with result: Failure, Error message: DB Error: syntax error

The code I finished with after I applied the patch is below, I would be very very grateful if you could tell me where I have gone wrong, thanks you!

 $startDate = $operator .
                    "({$dateField}, INTERVAL {$actionSchedule->start_action_offset} {$actionSchedule->start_action_unit})";
                 $startDateClause[] = "'{$now}' >= {$date}";
 
                 $startDateClause[] = $operator. "({$now}, INTERVAL 1 DAY ) {$op} " . $actionSchedule->start_action_date;
                 $startDate= implode( ' AND ', $startDateClause );
             } else if ( $actionSchedule->absolute_date ) {
                 $startDate = "DATEDIFF(DATE('{$now}'),'{$actionSchedule->absolute_date}') = 0";
            }