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;