Also, when I try to create my own reminder, I get the following query error:
Query Error
ERROR: query failed: SELECT pc_eventDate
FROM openemr_postcalendar_events
WHERE pc_eventDate
>? AND pid=? AND (date
BETWEEN DATE_SUB(‘2019-07-03 10:29:05’, INTERVAL 3 MONTH) AND ‘2019-07-03 10:29:05’)
Error: Unknown column ‘pid’ in ‘where clause’
/var/www/localhost/htdocs/openemr/library/sql.inc at 171:sqlStatementNoLog
/var/www/localhost/htdocs/openemr/library/clinical_rules.php at 1961:sqlStatementCdrEngine(SELECT pc_eventDate
FROM openemr_postcalendar_events
WHERE pc_eventDate
>? AND pid=? AND (date
BETWEEN DATE_SUB(‘2019-07-03 10:29:05’, INTERVAL 3 MONTH) AND ‘2019-07-03 10:29:05’) ,Array)
/var/www/localhost/htdocs/openemr/library/clinical_rules.php at 1717:exist_database_item(307,openemr_postcalendar_events,pc_eventDate,gt,STR_TO_DATE(‘Dec 31, 2018’,’%M %d,%Y’),lt,1,month,3,2019-07-03 10:29:05)
/var/www/localhost/htdocs/openemr/library/clinical_rules.php at 1241:database_check(307,Array,Array,2019-07-03 10:29:05)
/var/www/localhost/htdocs/openemr/library/clinical_rules.php at 820:test_targets(307,rule_102,2019-07-03 10:29:05)
/var/www/localhost/htdocs/openemr/library/reminders.php at 220:test_rules_clinic(,patient_reminder,2019-04-03 10:29:05,reminders-due,307)
/var/www/localhost/htdocs/openemr/library/reminders.php at 49:update_reminders(2019-04-03 10:29:05,307)
/var/www/localhost/htdocs/openemr/interface/patient_file/summary/patient_reminders_fragment.php at 24:patient_reminder_widget(307)