1. Forums
  3. Support and Presales
  5. Professional Members Support
  7. [SOLVED] Error while adding a field

[SOLVED] Error while adding a field

11 years 10 months ago - 11 years 10 months ago #204141 by abrbhat
[SOLVED] Error while adding a field was created by abrbhat
When I am adding a text field it is showing an error:(see attached picture)
How can i resolve it?
It is adding fields of other type with no problem.
Attachments:

Please Log in to join the conversation.

11 years 10 months ago #204179 by krileon
Replied by krileon on topic Re: Error while adding a field
You've too many fields. When you have around 100 fields the database column size limit is hit (limitation in MYSQL). Please search as there's a couple solutions to this (requires changing the column type of fields to text). Permanent solution will be included with CB 2.0 as we restructure how fields are stored.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

11 years 10 months ago #204269 by abrbhat
Replied by abrbhat on topic Re: Error while adding a field
Yes, I have around 120 fields.
Can you please be more specific? Which column in which table?

Please Log in to join the conversation.

11 years 10 months ago #204292 by krileon
Replied by krileon on topic Re: Error while adding a field
_comprofiler column size limit is reached. It's a MYSQL limitation. Only fix is to change a bunch of columns to "text" type. Please search as we've provided a solution to this numerous times. Various keywords such as "the maximum row size", "BLOB", all turn up results.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

11 years 10 months ago #204543 by abrbhat
Replied by abrbhat on topic Re: Error while adding a field
did what Beat had said....now its fixed...thnx! :)

Please Log in to join the conversation.

Moderators: beat, nant, krileon
  1. Forums
  3. Support and Presales
  5. Professional Members Support
  7. [SOLVED] Error while adding a field
Time to create page: 0.194 seconds

Facebook Twitter LinkedIn

    You are here:  
  1. Home
  2. Forums
  3. Support and Presales
  4. Professional Members Support
  5. [SOLVED] Error while adding a field

Search

Login / Logout

User Menu