Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.4.3
-
Fix Version/s: 4.4.4
-
Component/s: None
-
Labels:None
Description
Currently the Schedule Reminder form allows admins to save a reminder with both the absolute date and the start action offset empty. This results in the DB error described below when the job is run. I don't think this is a valid configuration so the fix would be to add a formRule to not allow this condition.
— Original Post ----
See screen show from demo as to how I got the error. Problem is in this line CRM_Core_BAO_ActionSchedule when $addWhere = '' there are 2 consecutive ANDs
{$additionWhere} c.is_deleted = 0 AND c.is_deceased = 0 AND {$addWhere}
AND {$dateClause}
NB - I have no idea whether this is a valid config - I was trying to get 'any' test reminder out to test something & couldn't seem to leave the 'limit to' / additional field empty as I desired so this was dummy data I couldn't really understand why the field was required & the help text only seems to refer to the limit to option as it pertains to events
