Need help with MySql Errors

Using my Dolibarr CRM/SRM Modules
1

Hello,

I am encountering the following issue:

Row size too large.** The maximum row size for the table type being used (excluding BLOBs) is 8126 bytes. This includes storage overhead. Please refer to the manual for more details. To resolve this, you need to change some columns to TEXT or BLOB data types.

The problem occurred after I added some extra fields to the products. I have already attempted the following:

Setting innodb_default_row_format to DYNAMIC – The row format is already set to DYNAMIC.
Verified the Collation is utf8mb4_general_ci

When trying to reduce the size of the character fields to 10 it gives me the following error :
“Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.”*

Thank you in advance for your help!

2

For those who may encounter this problem, I resolved it by adding the following two lines:

Linux: /usr/local/etc/my.cnf

[mysqld]
innodb_log_file_size = 512M
innodb_strict_mode = 0

Then, I restarted the MySQL service.

3

which dolibarr version are you running?

4

V20.0.3 - The error occurred because I have around 150 extra fields just for products.