[3.4 -> 3.5] Data too long for column 'capabilities' at row 1

[3.4 -> 3.5] Data too long for column 'capabilities' at row 1

by Richard van Iwaarden -
Number of replies: 2
Picture of Particularly helpful Moodlers

I had quite some errors during the update from Moodle 3.4.1 to 3.5. Most of them could be fixed along the way, but one passed me by that I could not fix. Moodle continued the upgrade.


So how serious is this error? I'm now running Moodle 3.5, but these errors give me the creeps. Something was not stored in the database...

Anyone else have an idea what went wrong?

Average of ratings: -
In reply to Richard van Iwaarden

Re: [3.4 -> 3.5] Data too long for column 'capabilities' at row 1

by Richard van Iwaarden -
Picture of Particularly helpful Moodlers

Found the problem...

Make sure your Database rows are in 'Dynamic' mode and not in 'Compact'.

https://dev.mysql.com/doc/refman/5.6/en/innodb-row-format-dynamic.html


If you did a utf8mb4 conversion from the database in COMPACT mode, you will run into the problems above.

Average of ratings: Useful (2)
In reply to Richard van Iwaarden

Re: [3.4 -> 3.5] Data too long for column 'capabilities' at row 1

by Nicolas Ndalpe -

Hi Richard,

Thx for the tip.


In addition, I had to execute the following command in Mariadb/MySQL to make it work.

SET GLOBAL innodb_default_row_format = DYNAMIC;


My guess is that ROW_FORMAT=DYNAMIC is not explicitly specified in every CREATE TABLE statement of my mysqldump file.


My setup:

Server version: 10.1.37-MariaDB-0+deb9u1 Debian 9.6

Moodle 3.5.4+ (Build: 20190208)


Hope it helps

Average of ratings: Useful (1)