Update to Webform 1.x-4.26.5, Database update failed

[olafgrabienski]

On a site with an extensive webform (numerous conditionals), the Database update 1609 failed with a PDOException. The db update is for adding a column to the webform table regarding the "Go back to the form" link.

Failed: PDOException: 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 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs: ALTER TABLE {webform} ADD back_to_form_link TINYINT NOT NULL DEFAULT 1 COMMENT 'Boolean value for whether to show or hide the "Go back to the form" link.'; Array ( ) in db_add_field() (line 3143 of (…)/core/includes/database/database.inc).

The message says, I have to "change some columns to TEXT or BLOBs". Hm, are there other ways to work around the issue?

[argiepiano]

You must be using an InnoDB engine with a small page size. See https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html. Can you run SHOW VARIABLES LIKE 'innodb_page_size';?

I don't know what the solution might be other than switching some or all of the varchar columns to text or blob. Can you check which of the varchar columns are the longest ones in your webform table? Perhaps there is a way to shorten them? The longer set is the redirect_url. Perhaps there are ways to shorten that? For example, query strings not needed, or remove the domain and just leave the relative path?

Still, I'm a bit mystified by this, since, if you add all the varchars maximum lenghts you get to about 4000 bytes, and the limit in the error messages is 8126. So perhaps all those tiny ints are also taking a lot of space?

[olafgrabienski]

Thanks for your thoughts! I don't have direct access to the database for this site and will contact the server admin.

[maltem-za]

Hi, I'm the server admin and can't explain it either. The innodb_page_size is 16384 and the webform table contains only a single row, with the longest value being in the confirmation column at 216 characters.

ETA: This is on MariaDB 11.4.3