Read about OpenEMR's Response to the COVID-19 Pandemic at https://www.open-emr.org/covid19/

Cant view patient

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 :confused:

You should update to OpenEMR patch 3 when possible.