Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted December 4, 20222 yr 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?
December 4, 20222 yr 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. 😋
December 4, 20222 yr 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.
December 4, 20222 yr 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/
December 4, 20222 yr 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.
December 4, 20222 yr Moved to this forum as requested. Glad you resolved the issue though, @Adriano Faria.
December 4, 20222 yr 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.