Can't add any new fields all of a sudden

14 years 5 months ago #116297 by romannumeralus
Can't add any new fields all of a sudden was created by romannumeralus
I have been adding fields for tabs in CB and all of a sudden, I started getting the following pop-up for each new field I have tried to add:

moscomprofilerFields::store failed: CBSQLupgrader::changeColumn (ADD) of Table #__comprofiler Column cb_businessuploads failed with SQL error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `jos_comprofiler`\n ADD `cb_businessuploads` varchar(255) DEFAULT NULL\nCBSQLupgrader::changeColumn (ADD) of Table #__comprofiler Column cb_businessuploadsapproved failed with SQL error: Unknown column 'cb_businessuploads' in 'jos_comprofiler' SQL=ALTER TABLE `jos_comprofiler`\n ADD `cb_businessuploadsapproved` tinyint(4) NOT NULL DEFAULT 1 AFTER `cb_businessuploads` Unknown column 'cb_businessuploads' in 'jos_comprofiler' SQL=ALTER TABLE `jos_comprofiler`\n ADD `cb_businessuploadsapproved` tinyint(4) NOT NULL DEFAULT 1 AFTER `cb_businessuploads`


What's the problem? I have the latest version of CB and CBSubs installed. I have run checks on the DB and gotten all green lights. This is time critical at this point. Thank you for your help.

Please Log in to join the conversation.

14 years 5 months ago #116299 by Rapunzl
Replied by Rapunzl on topic Re:Can't add any new fields all of a sudden
You have too many text fields for the database. Change some to another field type, like multi-select or text area or radio select.

NOTE: There's no way to change the field type without changing it from within the database itself, which is not advised unless you know what you're doing. You can, however, delete and re-create the field if no data exists for it yet.

Jamie (Rapunzl)
Community Builder Team Member

Before posting on forums: Read all CB Articles | Specially the FAQ | Help us help you
CB links: Subscribe to CB documentation | [url=http://www.joomlapolis.com/content/view/7363/37/
]Our templates[/url] | [url=http://www.joomlapolis.com/content/blogcategory/61/74/
]Paid Subscriptions[/url] | Get Hosting | Our Forge
Visit my CB Profile

My personal site Rapunzl's Reality always under reconstruction

Please Log in to join the conversation.

14 years 5 months ago #116302 by romannumeralus
Replied by romannumeralus on topic Re:Can't add any new fields all of a sudden
Wow. How does that happen?!? Thank you for your expertise. I'm pretty saavy when it comes to figuring things out, but I'm not a pro. Is there a way to change the configuration to allow more text fields?

Please Log in to join the conversation.

14 years 5 months ago #116324 by Rapunzl
Replied by Rapunzl on topic Re:Can't add any new fields all of a sudden
I'm not a database guru, so I'm not sure. :unsure:

Jamie (Rapunzl)
Community Builder Team Member

Before posting on forums: Read all CB Articles | Specially the FAQ | Help us help you
CB links: Subscribe to CB documentation | [url=http://www.joomlapolis.com/content/view/7363/37/
]Our templates[/url] | [url=http://www.joomlapolis.com/content/blogcategory/61/74/
]Paid Subscriptions[/url] | Get Hosting | Our Forge
Visit my CB Profile

My personal site Rapunzl's Reality always under reconstruction

Please Log in to join the conversation.

14 years 5 months ago #116432 by krileon
Replied by krileon on topic Re:Can't add any new fields all of a sudden
varchar is the most commonly used type, you appear to have surpassed your databases maximum for this field type. :blink:

To fix this you'll need to manually edit your database (probably with phpmyadmin; contact your host for details) and change some from varchar to text should help. Alternative is to remove some un-necessary fields if possible.


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.

Moderators: beatnantkrileon
Time to create page: 0.294 seconds

Facebook Twitter LinkedIn