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

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

by Richard van Iwaarden -
Number of replies: 1
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)