docs mysql script error while upgrading iRedMail from 1.7.2 to 1.7.3

on mariadb backend while running https://github.com/iredmail/iRedMail/raw/1.7.3/update/1.7.3/vmail.mysql

it threw the following error:

ERROR 1118 (42000) at line 57: 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

no changes were made to either table.

Apr 10 '25 02:04 truckerboy

Which linux distribution and release are you running?

Apr 10 '25 02:04 iredmail

Ubuntu 24.04.2 kernel 6.8.0-57 mariadb Ver 15.1 Distrib 10.11.11-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper

Apr 10 '25 03:04 truckerboy

Did you add any custom columns yourself in vmail.mailbox?

Apr 11 '25 07:04 iredmail

I have not added any columns of my own to vmail.mailbox I ran this command and the error went away when I re-ran your script:

ALTER TABLE mailbox ROW_FORMAT=DYNAMIC;

maybe consider converting all the iredmail tables to dynamic format as part of an update to avoid this error on newer versions of mariadb? https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-innodb/

Apr 12 '25 16:04 truckerboy