Situation
I am geting this error while trying to open a patient on a fresh install on ubuntu
Query Error
ERROR: query failed: SELECT title
FROM lists
WHERE type
=‘allergy’ AND activity
=1 AND ( enddate
IS NULL OR enddate
=’’ OR enddate
> NOW() ) AND pid
=?
Error: Incorrect DATE value: ‘’
/var/www/html/openemr/library/clinical_rules.php at 305:sqlStatement
/var/www/html/openemr/interface/patient_file/summary/demographics.php at 50:allergy_conflict(3,new,DTK-admin-79)
OpenEMR Version
I’m using OpenEMR version v5.0.2 (1)
Browser:
I’m using: Chrome
Operating System
I’m using:
server: ubuntu
client: windows 10
it looks like this: Cannot choose patient from list due to mysql 8 and I was wondering if the fix had ben pushed out yet or what