Jump to content

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

Featured Replies

Posted

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

rLHMlyS.png

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?

Solved by teraßyte

Go to solution
  • Solution

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. 😋

  • Author
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.

  • Author
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.

Recently Browsing 0

  • No registered users viewing this page.