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.
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.
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?
varchar is the most commonly used type, you appear to have surpassed your databases maximum for this field type.
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.