Create new patient error

Day-to-Day Users
#1

When I create new patient, I got follow error but patient has been created:

## 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(41,new,admin)

####openemr Version Number: v5.0.2 (1)
windows10 Google Chrome
version 85.0.4183.102 (64 bits)
server ubuntu18.0

#2

Hi @liwenz,

Give me the access of your machine then and then I can tell you what is the exact issue

#3

http://liwensoft.com/openemr/
I restore the database only from demo.
the username is admin
password is pass
I try the patient query is also such an error

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(32,new,admin)

I found a solution about , install patch
https://www.open-emr.org/wiki/index.php/OpenEMR_Patches
When unzip , it is unknown ccommand,
then sudo apt-get install zip unzip
it work well