SP Medical Install Error - Question | JoomShaper
SP Page Builder 6 is Here! Learn More →

SP Medical Install Error

S

Sebastian

Extension 2 years ago

When i try to install SP Medical on Joomla 4.3.2 i get this error: JInstaller: :Installera: SQL-fel Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

0
2 Answers
Anne
Anne
Accepted Answer
Support Agent 2 years ago #120514

Hello there,

Thanks for contacting us and sharing the information . Are you using the fresh joomla or any other template? Please let us know about it . We will check the issue and will get back to you soon.

-Regards

0
S
Szilárd
Accepted Answer
1 year ago #135359

Same issue,
SP Medical 2.1.0 on Joomla! 5.0.0, PHP Version 8.1.23, Database Version 8.0.35 / mysql

JInstaller: :Install: Error SQL Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

SOLVED: I've deleted ROW_FORMAT=COMPACT parameter from install.sql file :

CREATE TABLE IF NOT EXISTS `#__spmedical_specialists` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
...
  KEY `department_id` (`department_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
0