[SOLVED] any limitation on fields number?

Hello,
i'm having issue creating video fields. Getting error message after trying to save. So far i created 5 video fields assigned to different tabs. plus i keep getting this message when i try to save other field types too e.g. link, image since then.
Is there anything i can change in settings ?
Thank you

No, there's only a MYSQL column size limitation (which you hit). Please search with key term "BLOBs" and you'll find multiple topics on the issue as well as multiple fixes to workaround the MYSQL limitation.

I searched 'BLOBs' as well as 'maximum row size'- was very helpful, thanks a lot


So - i have too many fields consuming to much space and hitting the limit of column size as soon as there is only one database table, and it's not yet possible to build a new database-table for each new tab, so that info is stored in different tables. would be great if that feature is available in the next CB version:)


so the temporary solution is - go to Mysql to _comprofiler and manually change each field type from varchar(255) to text (for every field i created), and so in cb.core.xml? and then run cb tools check and fix?

do i have to change database engine to InnoDB?

i am also having issues with CB conditional, but will be posting this separately

so the temporary solution is - go to Mysql to _comprofiler and manually change each field type from varchar(255) to text (for every field i created), and so in cb.core.xml? and then run cb tools check and fix?

If you change it in cb.core.xml then run CB tool for fields checking then it'll ask if you want to fix it. You really only need to change Select and Text fields from varchar(255) to text and you should be ok.

do i have to change database engine to InnoDB?

You can and I suggest you do as J2.5-J3.0 are all InnoDB now. Please ensure you've made a backup of your database before making any of these changes though.

it workes! thanks a lot for your help!

-i changed engine to InnoDB,
-edited cb.core.xml , where i only changed "select" (single select dropdown) and "text" types to "sql:text" - enough for now?
-ran tools check for fields, and it returned everything in green
-then changed every existing single dropdown and text field to text manually in database, as they all remained varchar(255)
-created text field and it appeared as text type in database