Adriano Faria Posted December 4, 2022 Share Posted December 4, 2022 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? Link to comment Share on other sites More sharing options...
Solution teraßyte Posted December 4, 2022 Solution Share Posted December 4, 2022 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 Link to comment Share on other sites More sharing options...
Adriano Faria Posted December 4, 2022 Author Share Posted December 4, 2022 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. Link to comment Share on other sites More sharing options...
teraßyte Posted December 4, 2022 Share Posted December 4, 2022 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/ Link to comment Share on other sites More sharing options...
Adriano Faria Posted December 4, 2022 Author Share Posted December 4, 2022 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. Link to comment Share on other sites More sharing options...
Gary Posted December 4, 2022 Share Posted December 4, 2022 Moved to this forum as requested. Glad you resolved the issue though, @Adriano Faria. Adriano Faria 1 Link to comment Share on other sites More sharing options...
Marc Posted December 4, 2022 Share Posted December 4, 2022 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. Randy Calvert and Adriano Faria 1 1 Link to comment Share on other sites More sharing options...
Recommended Posts