Updating to v24.0.01 error

Administration
1

I have successfully updated a number of Gibbon sites to v24.0.01.

However for the latest one I had this error:

Some aspects of your request failed, but others were successful. The elements that failed are shown below: The following SQL statements caused errors: ALTER TABLE gibbonPerson ADD `mfaSecret` VARCHAR(16) DEFAULT NULL AFTER `receiveNotificationEmails` 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 gibbonPerson ADD mfaToken TEXT DEFAULT NULL AFTER mfaSecret
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘mfaSecret’ in ‘gibbonPerson’

What should I do, if anything?

Thanks

Tieku

2

Updating from v23.0.02

3

Hi Tieku, which version of MySQL is this server using compared to the other servers? It seems like a server configuration issue limiting the table size.

4

I checked. 3 servers and each one is running MariaDB 10.4

5

Hi Tieku, here is some information about the error from the MariaDB docs, hope it helps: https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-innodb/