Error in adding field to Accounts

11 posts by 4 authors in: Forums > CMS Builder
Last Post: October 25, 2020   (RSS)

By nmsinc - July 27, 2020

I'm having an issue adding a new field to the Accounts Section. The reports "Row size is to large - max row size is 8126". I can add fields to all other Sections but Accounts without the error!

The field text is "Allow Print Creditor" using a checkbox!

Any help would be appreciated!

nmsinc

By Damon - July 28, 2020

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?

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By nmsinc - July 28, 2020

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!

nmsinc

By Damon - July 30, 2020

Hi again,

Some more questions to help us track this down:

What version of CMS Builder is installed?

What is the version of MySQL?

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By nmsinc - July 30, 2020

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

MySQL: MariaDB 10.3.23-MariaDB

nmsinc

By pault - October 18, 2020

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.

By nmsinc - October 18, 2020

I found that I had to run a database repair from the WHM. Worked great once I did this!

nmsinc

By pault - October 18, 2020

Thanks.

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

Paul.

By nmsinc - October 18, 2020 - edited: October 18, 2020

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

nmsinc