Error in adding field to Accounts

Hi,

I added a new checkbox field to the user accounts but I was not able to recreate the issue.

Can you confirm that the /data/schema/accounts.ini.php file has writable permissions?

Does this error happen when adding any new field to the accounts?

Could you walk me through the steps?

Can you confirm that the /data/schema/accounts.ini.php file has writable permissions? Yes

Does this error happen when adding any new field to the accounts? Yes

Could you walk me through the steps? Using "quick add" or "add field" I receive a lengthy error box that appears to be generated by CMS. 

"Error:

Notice: There was an error creating the MySQL Column. the error was:

Row size too large. The maximum size for the used table type, not counting BLOB's is 8126. This includes storage overhead, check the manual. You have to change some colums to TEXE or BLOBs - in editField_functions.php on line 357 by updateMySQL() in cms common.php on line 278"

The field label is: Allow Printing

The Type is: checkbox

The filed is: allow_printing

NOTE: all other sections work fine, I can create fields with no problem!

Hi again,

Some more questions to help us track this down:

What version of CMS Builder is installed?

What is the version of MySQL?

CMC version:  CMS Builder v3.53 (Build 2265)

MySQL: MariaDB 10.3.23-MariaDB

Hi,

Can you email the CMS Builder and FTP details to support@interactivetools.com so we can look into this?

Thanks!

Hi Damon,

Did you find a resolution to this as I'm facing the same problem.  It's in trying to add a new field to a section I get the following:

Error:
Notice: There was an error creating the MySQL Column, the error was:

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 - in editField_functions.php on line 357 by _updateMySQL() in /var/www/vhosts/**********/httpdocs/Admin/lib/common.php on line 278

This is also with MariaDB 10.3 and CMSB 3.53

Thanks, Paul.

Thanks.

Did the problem occur for you following an upgrade to MariaDB?

Paul.

Yes, right after I upgraded to the new MariaDB SQL database!