Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or...

[Adriano Faria]

I got this error when I'm trying to install the suite on my dev install.

Problem is that is happens in the install when it tries to create the table, so I can go to that table and change the format.

What can I do here?

[teraßyte]

They should really include the ROW_FORMAT=DYNAMIC in queries by default for such situations.

For now as a fix you'd need to change your Wamp server MySQL configuration to create new tables using DYNAMIC by default.

 

P.S.: You posted this in topic Marketplace Support. 😋

[Adriano Faria]

1 minute ago, teraßyte said:

P.S.: You posted this in topic Marketplace Support. 😋

LOL. I never get it right. 😄

1 minute ago, teraßyte said:

For now as a fix you'd need to change your Wamp server MySQL configuration to create new tables using DYNAMIC by default.

Let me see where I find this in MariaDB (Wamp).

3 minutes ago, teraßyte said:

For now as a fix you'd need to change your Wamp server MySQL configuration to create new tables using DYNAMIC by default.

Found it. Let me try.

[teraßyte]

MariaDB 10.2.2+ should be using such format by default, but maybe you have an old configuration file.

 

Here's a link: https://mariadb.com/kb/en/innodb-dynamic-row-format/

[Adriano Faria]

7 minutes ago, teraßyte said:

For now as a fix you'd need to change your Wamp server MySQL configuration to create new tables using DYNAMIC by default.

That did it. Thanks. 👍

2 minutes ago, teraßyte said:

MariaDB 10.2.2+ should be using such format by default, but maybe you have an old configuration file.

Nope. Using 10.7.3 and it was COMPACT.

Suite installed. Thanks.

[Gary]

Moved to this forum as requested.

Glad you resolved the issue though, @Adriano Faria.

[Marc]

6 hours ago, teraßyte said:

MariaDB 10.2.2+ should be using such format by default, but maybe you have an old configuration file.

 

Here's a link: https://mariadb.com/kb/en/innodb-dynamic-row-format/

I have tagged our developers to see if this is something we can do.