SP Medical install error - Forum | JoomShaper
Awaiting an answer Extensions

SP Medical install error

Asked by Sebastian 3 years ago Last activity 3 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.

2 replies

Oldest first Newest first Most helpful
Anne Staff
3 years ago

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

Szilárd
3 years ago · edited

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;
Log in to reply.