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!
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?
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!
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?
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
By Damon - August 3, 2020
Hi,
Can you email the CMS Builder and FTP details to support@interactivetools.com so we can look into this?
Thanks!
Damon Edis - interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
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!
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!