DB Error V6 CREATE TABLE `history_data` > 1118 - Row size too large (> 8126)

Hello Community,

I’m new to this system. However there is experience with OS like magento, drupal, shopware…

When installing v6 clean, I’m getting this DB 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.

System:
10.5.11-MariaDB-1:10.5.11+maria~buster
PHP 7.4.x

Does anyone know a solution? Thanks for your attention :slight_smile:

rgds,
Kiteman

FYI: Full create statement

CREATE TABLE history_data
(
id BIGINT(20) NOT NULL auto_increment,
coffee LONGTEXT,
tobacco LONGTEXT,
alcohol LONGTEXT,
sleep_patterns LONGTEXT,
exercise_patterns LONGTEXT,
seatbelt_use LONGTEXT,
counseling LONGTEXT,
hazardous_activities LONGTEXT,
recreational_drugs LONGTEXT,
last_breast_exam VARCHAR(255) DEFAULT NULL,
last_mammogram VARCHAR(255) DEFAULT NULL,
last_gynocological_exam VARCHAR(255) DEFAULT NULL,
last_rectal_exam VARCHAR(255) DEFAULT NULL,
last_prostate_exam VARCHAR(255) DEFAULT NULL,
last_physical_exam VARCHAR(255) DEFAULT NULL,
last_sigmoidoscopy_colonoscopy VARCHAR(255) DEFAULT NULL,
last_ecg VARCHAR(255) DEFAULT NULL,
last_cardiac_echo VARCHAR(255) DEFAULT NULL,
last_retinal VARCHAR(255) DEFAULT NULL,
last_fluvax VARCHAR(255) DEFAULT NULL,
last_pneuvax VARCHAR(255) DEFAULT NULL,
last_ldl VARCHAR(255) DEFAULT NULL,
last_hemoglobin VARCHAR(255) DEFAULT NULL,
last_psa VARCHAR(255) DEFAULT NULL,
last_exam_results VARCHAR(255) DEFAULT NULL,
history_mother LONGTEXT,
dc_mother TEXT,
history_father LONGTEXT,
dc_father TEXT,
history_siblings LONGTEXT,
dc_siblings TEXT,
history_offspring LONGTEXT,
dc_offspring TEXT,
history_spouse LONGTEXT,
dc_spouse TEXT,
relatives_cancer LONGTEXT,
relatives_tuberculosis LONGTEXT,
relatives_diabetes LONGTEXT,
relatives_high_blood_pressure LONGTEXT,
relatives_heart_problems LONGTEXT,
relatives_stroke LONGTEXT,
relatives_epilepsy LONGTEXT,
relatives_mental_illness LONGTEXT,
relatives_suicide LONGTEXT,
cataract_surgery DATETIME DEFAULT NULL,
tonsillectomy DATETIME DEFAULT NULL,
cholecystestomy DATETIME DEFAULT NULL,
heart_surgery DATETIME DEFAULT NULL,
hysterectomy DATETIME DEFAULT NULL,
hernia_repair DATETIME DEFAULT NULL,
hip_replacement DATETIME DEFAULT NULL,
knee_replacement DATETIME DEFAULT NULL,
appendectomy DATETIME DEFAULT NULL,
date DATETIME DEFAULT NULL,
pid BIGINT(20) NOT NULL DEFAULT ‘0’,
name_1 VARCHAR(255) DEFAULT NULL,
value_1 VARCHAR(255) DEFAULT NULL,
name_2 VARCHAR(255) DEFAULT NULL,
value_2 VARCHAR(255) DEFAULT NULL,
additional_history TEXT,
exams TEXT,
usertext11 TEXT,
usertext12 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext13 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext14 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext15 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext16 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext17 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext18 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext19 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext20 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext21 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext22 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext23 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext24 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext25 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext26 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext27 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext28 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext29 VARCHAR(255) NOT NULL DEFAULT ‘’,
usertext30 VARCHAR(255) NOT NULL DEFAULT ‘’,
userdate11 DATE DEFAULT NULL,
userdate12 DATE DEFAULT NULL,
userdate13 DATE DEFAULT NULL,
userdate14 DATE DEFAULT NULL,
userdate15 DATE DEFAULT NULL,
userarea11 TEXT,
userarea12 TEXT,
PRIMARY KEY (id),
KEY pid (pid)
)
engine=innodb
auto_increment=1

If you are just trying the installation, reset all user* fields to varchar(1). This specially includes the TEXT fields.

thxs, will try next days. :slight_smile:

FYI: I realised perfectly with MAMP (something like XAMP) at a lokal Mac OS ENV. MAMP uses MySQL 5.7 while shared Hosting offers MariaDB 10.5.11-MariaDB. It might also be the reason

rgds,
Kiteman