Error when installing: Row size too large

[haary]

When installing the plugin in Ilias 7.26 I get the error "1118 Row size too large."

Here's the the error log:

PDOException thrown with message "SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This 
includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs"

Stacktrace:
#15 PDOException in /var/www/htdocs/Services/Database/classes/PDO/Manager/class.ilDBPdoManager.php:306
#14 PDO:exec in /var/www/htdocs/Services/Database/classes/PDO/Manager/class.ilDBPdoManager.php:306
#13 ilDBPdoManager:alterTable in /var/www/htdocs/Services/Database/classes/PDO/class.ilDBPdo.php:468
#12 ilDBPdo:addTableColumn in /var/www/htdocs/Services/Database/classes/class.ilDBUpdate.php:504
#11 eval in /var/www/htdocs/Services/Database/classes/class.ilDBUpdate.php:504
#10 ilDBUpdate:applyUpdateNr in /var/www/htdocs/Services/Database/classes/class.ilDBUpdate.php:371
#9 ilDBUpdate:applyUpdate in /var/www/htdocs/Services/Component/classes/class.ilPlugin.php:526
#8 ilPlugin:updateDatabase in /var/www/htdocs/Services/Component/classes/class.ilPlugin.php:1087
#7 ilPlugin:update in /var/www/htdocs/Services/Component/classes/class.ilObjComponentSettingsGUI.php:507
#6 ilObjComponentSettingsGUI:update in /var/www/htdocs/Services/Component/classes/class.ilObjComponentSettingsGUI.php:502
#5 ilObjComponentSettingsGUI:updatePlugin in /var/www/htdocs/Services/Component/classes/class.ilObjComponentSettingsGUI.php:123
#4 ilObjComponentSettingsGUI:executeCommand in /var/www/htdocs/Services/UICore/classes/class.ilCtrl.php:217
#3 ilCtrl:forwardCommand in /var/www/htdocs/Services/Administration/classes/class.ilAdministrationGUI.php:246
#2 ilAdministrationGUI:executeCommand in /var/www/htdocs/Services/UICore/classes/class.ilCtrl.php:217
#1 ilCtrl:forwardCommand in /var/www/htdocs/Services/UICore/classes/class.ilCtrl.php:178
#0 ilCtrl:callBaseClass in /var/www/htdocs/ilias.php:23

[nmatuschek]

I can not reproduce this and it's not fixable in the code. Is it a clean new ILIAS installation and could i be you created the database manually? Please check the row_format of the database tables. I suggest to set it to "dynamic". Maybe this could solve the problem.

[haary]

All tables already have ROW_FORMAT "dynamic", so that seems not to be the cause of the problem. Is is an old installation, upgraded from originally Ilias 5.4.26.

I noticed that the error occurs when creating tables for the plugin. Not all tables are created, for example rep_robj_xvid_youtube is missing. Is there a specific table which could be the cause of the problem?

[nmatuschek]

Ok. It seems like there are some updates mimssing.

• Navigate to the plugin administration in ILIAS. -> Select "configure" from the action menu of the InteractiveVideo-Plugin

On the Configure overview you can select the db updates for the features you would like to use.

[haary]

Ok. It seems like there are some updates mimssing.

* > Navigate to the plugin administration in ILIAS.
  > -> Select "configure" from the action menu of the InteractiveVideo-Plugin

Since the installation and activation fails in the first place I can't configure the plugin.

[dmundra]

Create a new issue in mantis https://mantis.ilias.de/my_view_page.php for 'Interactive Video' e.g. https://mantis.ilias.de/view.php?id=39392

[Stefan-Schulze-SIMTEVA]

Any update on this? On the Mantis Bugtracker there is no update, and i have the same error. I also commented in the open Bug https://mantis.ilias.de/view.php?id=40117#bugnotes