I'm just upgraded CB from 1.9 to 2.0.4. When I go to Tool > Check CB Databases > Click here to fix (adjust) all Core CB database differences listed above I will get an error like below:
An error has occurred.
1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline. SQL=ALTER TABLE `cbtest_comprofiler` ENGINE = 'InnoDB'
I've try to change _comprofiler tables storage engine from MyISAM to InnoDB using phpmyadmin but get an error like below:
#1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT_DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
I'm using PHP 5.4.30 and MySQL 5.5.40. Do you need admin account / FTP access to look into this problem?
Your column size limit is being hit on the _comprofiler table. You need some of your varchar(255) columns converted to text type. CB can do this for you by clicking the link in the description of the "Check Community Builder User Fields Database" tool. Once that converts their type you should be able to run the other database tools fine.
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.
I've done CB fields data storage database checks by clicking "Check Community Builder User Fields Database with strict column types" link as you said and I got all lines in green color but the error still exists.
Try converting your _comprofiler database table to InnoDB manually from phpmyadmin (see Operations tab of while viewing the table).
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.
The columns are all adjusted correctly and there really isn't that many of them. I'm no database expert so I recommend contacting your host as maybe they've something to suggest. We've pulled the data and tested locally and could duplicate your issue locally. So it doesn't appear host or configuration related. I believe this is due to you storing a very large amount of text (10+ paragraphs it would seam) into a single field. When all rows are deleted (again, this is done locally) I am able to convert the table fine. We'll need to do some more research and figure out exactly what's going on with InnoDB usage in this regard. At this time I recommend just not bothering to convert the tables Engine for now.
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.
krileon
