Openemr-4.1.2 installation OX10.9 Mavericks

OpenEMR Development
1

jklompje wrote on Friday, January 31, 2014:

I tried this http://sourceforge.net/projects/openemr/forums/forum/202506/topic/4781253#sthash.eTGeW7nU.dpuf on the above. No problems through setup, but on login:
ERROR: insert failed: insert into log ( date, event, user, groupname, success, comments, crt_user, patient_id) values ( NOW(), ‘login’,‘admin’,‘Default’,‘1’,‘success: 127.0.0.1’,NULL,‘NULL’)

Error: Incorrect integer value: ‘NULL’ for column ‘patient_id’ at row 1

Anyone with ideas to fix this?

2

yehster wrote on Friday, January 31, 2014:

You need to setup MySQL WITHOUT strict mode.

3

jklompje wrote on Friday, January 31, 2014:

Thanks, my oversight! Should actually be added to the wiki instructions.

4

blankev wrote on Friday, January 31, 2014:

If it is needed in the instructions, please feel free to make an additional note in the relevant WIKI Pages! (I would love to make them, but I don’t know anything of what you are talking about.)

5

fsgl wrote on Friday, January 31, 2014:

“If not using the XAMPP package, then ensure when configuring MySQL for OpenEMR, STRICT_MODE must be disabled.” from this web page for Windows.

Same instructions for Centos and Red Hat, but not spelled out here.