MySQL Version

OpenEMR Development
1

aaricpittman wrote on Saturday, January 09, 2016:

What are the MySQL version requirements/limitations for the project?

I’m runing 5.6.20 and the database.sql is failing. One of the reasons is default values on text fields. The setup process I guess ignores the failures and keeps executing. I noticed the problem when I started getting errors that certain tables were missing.

Aaric

2

yehster wrote on Saturday, January 09, 2016:

From the MySQL tool of your choice, execute the following

SELECT @@GLOBAL.sql_mode;

If STRICT_TRANS_TABLES is included in the sql mode shown, that would explain the problem.

https://dev.mysql.com/doc/refman/5.6/en/sql-mode.html

OpenEMR requires disabling Strict Transactions, and the default option when installing MYSQL with the windows installer is enabled.