Do you use or administer OpenEMR? Take the General Satisfaction Survey to help improve the product

Setup error with LMDE 4

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