[SOLVED] Upgraded from 1.8.1 to 1.9 - have the following errors when running the CB checks

I have upgraded a joomla 2.5.6 site's community builder from 1.8.1 to 1.9 following the instructions provided with the downloaded files.

installation was fine but when running the cb tool checks 3 of the 4 where issue free. The 'Check Community Builder User Fields Database' link had a list of issues and I continued to fix the issues and got the following errors:

CB fields data storage Database adjustments errors:

CBSQLupgrader::changeColumn (CHANGE `cb_pubdoyouoffertakeaway`) of Table #__comprofiler Column cb_pubdoyouoffertakeaway 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 `lle_comprofiler` CHANGE `cb_pubdoyouoffertakeaway` `cb_pubdoyouoffertakeaway` varchar(255) DEFAULT NULL
ALTER TABLE `#__comprofiler` CHANGE `cb_pubdoyouoffertakeaway` `cb_pubdoyouoffertakeaway` varchar(255) DEFAULT NULL
CBSQLupgrader::changeColumn (CHANGE `cb_pubdoyoudeliver`) of Table #__comprofiler Column cb_pubdoyoudeliver 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 `lle_comprofiler` CHANGE `cb_pubdoyoudeliver` `cb_pubdoyoudeliver` varchar(255) DEFAULT NULL
ALTER TABLE `#__comprofiler` CHANGE `cb_pubdoyoudeliver` `cb_pubdoyoudeliver` varchar(255) DEFAULT NULL
CBSQLupgrader::changeColumn (CHANGE `cb_pubmorethan3veggieoptions`) of Table #__comprofiler Column cb_pubmorethan3veggieoptions 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 `lle_comprofiler` CHANGE `cb_pubmorethan3veggieoptions` `cb_pubmorethan3veggieoptions` varchar(255) DEFAULT NULL
ALTER TABLE `#__comprofiler` CHANGE `cb_pubmorethan3veggieoptions` `cb_pubmorethan3veggieoptions` varchar(255) DEFAULT NULL
CBSQLupgrader::changeColumn (CHANGE `cb_size`) of Table #__comprofiler Column cb_size 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 `lle_comprofiler` CHANGE `cb_size` `cb_size` varchar(255) DEFAULT NULL
ALTER TABLE `#__comprofiler` CHANGE `cb_size` `cb_size` varchar(255) DEFAULT NULL
CBSQLupgrader::changeColumn (CHANGE `cb_bloggersreviewlink`) of Table #__comprofiler Column cb_bloggersreviewlink 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 `lle_comprofiler` CHANGE `cb_bloggersreviewlink` `cb_bloggersreviewlink` varchar(255) DEFAULT NULL
ALTER TABLE `#__comprofiler` CHANGE `cb_bloggersreviewlink` `cb_bloggersreviewlink` varchar(255) DEFAULT NULL


Now when checking this section again I get the following:

CB fields data storage Database structure differences:

Table #__comprofiler Column cb_pubdoyouoffertakeaway type is text instead of varchar(255)
Table #__comprofiler Column cb_pubdoyoudeliver type is text instead of varchar(255)
Table #__comprofiler Column cb_pubmorethan3veggieoptions type is text instead of varchar(255)
Table #__comprofiler Column cb_size type is text instead of varchar(255)
Table #__comprofiler Column cb_bloggersreviewlink type is text instead of varchar(255)


hopefully this is enough information to go on, If there is anybody with the knowledge to fix this it would be really helpful.

CB is trying to change the fields back to varchar, but looks like you changed them to text due to hitting database column size limits. You'll just have to ignore the tools check as it'll want to change them back, but it can't due to your database being at the column size limit.

Thank you! your help is appreciated.