OpenEMR patch 5.0.2_1 error

patching

(Tomáš Vilhelm) #1

Hello colleagues,
I have tried to patch 5.0.2 by 1st released patch without success. I have no idea how to solve it . See bellow.

Processing patch.sql …
Skipping section #IfNotRow2D list_options list_id apps option_id oeSignerRemote
ALTER TABLE form_eye_neuro MODIFY ACT5CCDIST text

Query Error

ERROR: query failed: ALTER TABLE form_eye_neuro MODIFY ACT5CCDIST text

Error: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

/var/www/html/openemr502/library/sql_upgrade_fx.php at 933:sqlStatement
/var/www/html/openemr502/sql_patch.php at 66:upgradeFromSqlFile(patch.sql)


(Tomáš Vilhelm) #2

Solved by adding :slight_smile:

[mysqld]

innodb_log_file_size = 512M

innodb_strict_mode = 0

into /etc/mysql/conf.d/mysql.cnf/mysql.cnf