Error in adding field to Accounts
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!
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.
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!
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.
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:
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