Hi,
I cannot first install openemr-5.0.2 on LMDE 4 (LinuxMint Debian 10) . I have corrected the php.ini to the require configuration and am using Mariadb ( mysql Ver 15.1 Distrib 10.3.25-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2) and php-7.3. I get the following error on setup :
OpenEMR Setup
Step 3 - Creating Database and First UserConnecting to MySQL Server… OK .
Creating database… OK .
Creating user with permissions for database… OK .
Reconnecting as new user… OK .
ERROR . unable to execute SQL: ‘CREATE TABLE form_eye_neuro
( id
bigint (20) NOT NULL COMMENT ‘Links to forms.form_id’, pid
bigint(20) DEFAULT NULL, ACT
char (3) NOT NULL DEFAULT ‘on’, ACT5CCDIST
varchar (50) DEFAULT NULL, ACT1CCDIST
varchar (50) DEFAULT NULL, ACT2CCDIST
varchar (50) DEFAULT NULL, ACT3CCDIST
varchar (50) DEFAULT NULL, ACT4CCDIST
varchar (50) DEFAULT NULL, ACT6CCDIST
varchar (50) DEFAULT NULL, ACT7CCDIST
varchar (50) DEFAULT NULL, ACT8CCDIST
varchar (50) DEFAULT NULL, ACT9CCDIST
varchar (50) DEFAULT NULL, ACT10CCDIST
varchar (50) DEFAULT NULL, ACT11CCDIST
varchar (50) DEFAULT NULL, ACT1SCDIST
varchar (50) DEFAULT NULL, ACT2SCDIST
varchar (50) DEFAULT NULL, ACT3SCDIST
varchar (50) DEFAULT NULL, ACT4SCDIST
varchar (50) DEFAULT NULL, ACT5SCDIST
varchar (50) DEFAULT NULL, ACT6SCDIST
varchar (50) DEFAULT NULL, ACT7SCDIST
varchar (50) DEFAULT NULL, ACT8SCDIST
varchar (50) DEFAULT NULL, ACT9SCDIST
varchar (50) DEFAULT NULL, ACT10SCDIST
varchar (50) DEFAULT NULL, ACT11SCDIST
varchar (50) DEFAULT NULL, ACT1SCNEAR
varchar (50) DEFAULT NULL, ACT2SCNEAR
varchar (50) DEFAULT NULL, ACT3SCNEAR
varchar (50) DEFAULT NULL, ACT4SCNEAR
varchar (50) DEFAULT NULL, ACT5CCNEAR
varchar (50) DEFAULT NULL, ACT6CCNEAR
varchar (50) DEFAULT NULL, ACT7CCNEAR
varchar (50) DEFAULT NULL, ACT8CCNEAR
varchar (50) DEFAULT NULL, ACT9CCNEAR
varchar (50) DEFAULT NULL, ACT10CCNEAR
varchar (50) DEFAULT NULL, ACT11CCNEAR
varchar (50) DEFAULT NULL, ACT5SCNEAR
varchar (50) DEFAULT NULL, ACT6SCNEAR
varchar (50) DEFAULT NULL, ACT7SCNEAR
varchar (50) DEFAULT NULL, ACT8SCNEAR
varchar (50) DEFAULT NULL, ACT9SCNEAR
varchar (50) DEFAULT NULL, ACT10SCNEAR
varchar (50) DEFAULT NULL, ACT11SCNEAR
varchar (50) DEFAULT NULL, ACT1CCNEAR
varchar (50) DEFAULT NULL, ACT2CCNEAR
varchar (50) DEFAULT NULL, ACT3CCNEAR
varchar (50) DEFAULT NULL, ACT4CCNEAR
varchar (50) DEFAULT NULL, MOTILITYNORMAL
char (3) NOT NULL DEFAULT ‘on’, MOTILITY_RS
char (1) DEFAULT ‘0’, MOTILITY_RI
char (1) DEFAULT ‘0’, MOTILITY_RR
char (1) DEFAULT ‘0’, MOTILITY_RL
char (1) DEFAULT ‘0’, MOTILITY_LS
char (1) DEFAULT ‘0’, MOTILITY_LI
char (1) DEFAULT ‘0’, MOTILITY_LR
char (1) DEFAULT ‘0’, MOTILITY_LL
char (1) DEFAULT ‘0’, MOTILITY_RRSO
int (1) DEFAULT NULL, MOTILITY_RLSO
int (1) DEFAULT NULL, MOTILITY_RRIO
int (1) DEFAULT NULL, MOTILITY_RLIO
int (1) DEFAULT NULL, MOTILITY_LRSO
int (1) DEFAULT NULL, MOTILITY_LLSO
int (1) DEFAULT NULL, MOTILITY_LRIO
int (1) DEFAULT NULL, MOTILITY_LLIO
int (1) DEFAULT NULL, NEURO_COMMENTS
text, STEREOPSIS
varchar (25) DEFAULT NULL, ODNPA
varchar (50) DEFAULT NULL, OSNPA
varchar (50) DEFAULT NULL, VERTFUSAMPS
varchar (50) DEFAULT NULL, DIVERGENCEAMPS
varchar (50) DEFAULT NULL, NPC
varchar (10) DEFAULT NULL, DACCDIST
varchar (20) DEFAULT NULL, DACCNEAR
varchar (20) DEFAULT NULL, CACCDIST
varchar (20) DEFAULT NULL, CACCNEAR
varchar (20) DEFAULT NULL, ODCOLOR
varchar (50) DEFAULT NULL, OSCOLOR
varchar (50) DEFAULT NULL, ODCOINS
varchar (50) DEFAULT NULL, OSCOINS
varchar (50) DEFAULT NULL, ODREDDESAT
varchar (20) DEFAULT NULL, OSREDDESAT
varchar (20) DEFAULT NULL, PRIMARY KEY neuro_link
(id
), UNIQUE KEY id_pid
(id
,pid
) ) ENGINE = InnoDB’ due to: 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.
I am just testing openemr on various Linux distributions in this period of Covid-19 lockdown.
Thanks.
Jack