[Resolved] Row size too large. The maximum row size for the used table type, not counting..

[Author]

Posts

[Derick]

I am trying to:
We upgraded WP Toolset to latest version but got the error message:
"Oops! There's been a problem when upgrading Toolset data structures. Please make sure your current configuration allows WordPress to alter database tables.If the problem persists, please don't hesitate to contact our support with this technical information:

Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs"

Link to a page where the issue can be seen:
hidden link

I expected to see:
We expected to be fine, since we did test upgrade on a UAT environment and we did not encounter this error before

[Luo Yang]

Hello,

It is database problem, if you are using Mysql server, you can follow below document to fix your website database:
hidden link

If it is Mariadb server, please check below document:
hidden link

[Derick]

Hi Lou,

The error message we see is too vague, we are not sure which table or columns need to update.

Can we get more details on which tables and columns toolset is using?

[Luo Yang]

I am not sure which one is the problem database table, please provide your website database dump file in below private message box, you can put the package files in your own google drive disk, share the link only, I need to test and debug it in my localhost, thanks
https://toolset.com/faq/provide-supporters-copy-site/

[Luo Yang]

Thanks for the details, I can download the files, will update here if find anything

[Luo Yang]

I can install the database dump file in my localhost (MySQL 8.0), it works fine, see my screenshot dhl.JPG.

And I have checked the debug information you provided above, you are using mysql 5.5.5, it is lower than the Toolset Server requirements:
https://toolset.com/toolset-requirements/
MySQL 5.6 and above.

You need to upgrade your mysql server to MySQL 5.6 or above, and test again

[Derick]

Hi Lou,

Thanks for the reply, but we checked our db and details below, sorry it is MariaDB

Server: Localhost via UNIX socket
Server type: MariaDB
Server connection: SSL is not being used Documentation
Server version: 10.5.9-MariaDB-1:10.5.9+maria~focal - mariadb.org binary distribution
Protocol version: 10

Errors coming from " ALTER TABLE `wp_toolset_relationships`" area

I also attached a sample screenshot of the errors logs we having right now.

[Derick]

Hi Lou,

Sorry forgot to mention we are on Kinsta and the db is Mariadb server.

and also we see this error on our logs about " ALTER TABLE `wp_toolset_relationships`"

"PHP message: WordPress database error Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs for query ALTER TABLE `wp_toolset_relationships`
ADD `autodelete_intermediary` TINYINT(1) NOT NULL DEFAULT '1' AFTER `is_active` made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('after_setup_theme'), WP_Hook->do_action, WP_Hook->apply_filters, Types_Main->after_setup_theme, Toolset_Common_Bootstrap::get_instance, Toolset_Common_Bootstrap->__construct, do_action('toolset_common_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, OTGS\Toolset\Common\Upgrade\UpgradeController->check_upgrade, OTGS\Toolset\Common\Upgrade\UpgradeController->do_upgrade, OTGS\Toolset\Common\Upgrade\UpgradeController->process_command, OTGS\Toolset\Common\Upgrade\Command\AddRelationshipTableColumnAut", client: 34.87.248.217, server: lot.dhl.com, request: "GET / HTTP/1.0", host: "lot.dhl.com"

[Luo Yang]

Thanks for the details, according to MariaDB document:
hidden link
MariaDB 10.5 should compatible with Mysql 8.0, so I need to test it with with MariaDB database, and will update here if find anything.

[Derick]

Hi Lou,

Just found the fix and solution for it, just need to the Update `wp_toolset_relationships` table row_format from "Compact" to "Dynamic".

Thanks!

[Derick]

My issue is resolved now. Thank you!