Situation
Applying the latest patch and getting the SQL error when running the sql_patch.php
OpenEMR Version
I’m using OpenEMR version v6.0.0 (3)
Browser:
I’m using: Chrome/latest. Same on firefox.
Operating System
I’m using: Server is CentOS7 with MariaDB server 5.5.68
Logs
Query Error
ERROR: query failed: CREATE TABLE
document_templates
(id
bigint(21) UNSIGNED NOT NULL,pid
bigint(20) DEFAULT NULL,provider
int(11) UNSIGNED DEFAULT NULL,encounter
int(11) UNSIGNED DEFAULT NULL,modified_date
datetime NOT NULL DEFAULT current_timestamp(),profile
varchar(31) DEFAULT NULL,category
varchar(63) DEFAULT NULL,location
varchar(255) DEFAULT NULL,template_name
varchar(255) DEFAULT NULL,status
varchar(31) DEFAULT NULL,exclude_portal
tinyint(1) NOT NULL DEFAULT 0,exclude_dashboard
tinyint(1) UNSIGNED NOT NULL DEFAULT 0,size
int(11) NOT NULL DEFAULT 0,template_content
mediumblob DEFAULT NULL,mime
varchar(31) DEFAULT NULL, PRIMARY KEY (id
), UNIQUE KEYlocation
(pid
,category
,template_name
,status
)) ENGINE=InnoDBError: Invalid default value for ‘modified_date’
/var/www/library/sql_upgrade_fx.php at 1175:sqlStatement
/var/www/sql_patch.php at 53:upgradeFromSqlFile(patch.sql)