Error upgrading from CB 1.9 to CB 2.0.1 on Joomla 3.3.6

I have a CB 1.9 database where I have used up all of the fields. After successfully upgrading 3 other smaller websites to CB 2.0.1 on Joomla 3.3.6, I tried to upgrade on my largest site and the installation failed and my users are now unable to login. Here are some of the errors:

Error

Database loading error. Check and repair your database in Components / Community Builder / Tools.
SQL Error (visible to super-admins only): Unknown column 'a.edit' in 'field list' SQL=SELECT a.`fieldid`, a.`name`, a.`title`, b.`name` AS `pluginname`, b.`published` AS `pluginstate`, a.`pluginid`, a.`type`, c.`pluginid` AS `tabpluginid`, d.`name` AS `tabpluginname`, d.`published` AS `tabpluginstate`, c.`title` AS `tabname`, c.`enabled` AS `tabstate`, a.`tabid`, a.`required`, a.`profile`, a.`registration`, a.`edit`, a.`searchable`, a.`published`, a.`ordering`, a.`sys`, a.`tablecolumns` FROM `XXXXX_comprofiler_fields` AS a LEFT JOIN `XXXXX_comprofiler_plugin` AS b ON b.`id` = a.`pluginid` INNER JOIN `XXXXX_comprofiler_tabs` AS c ON c.`fields` = 1 AND c.`tabid` = a.`tabid` LEFT JOIN `XXXXX_comprofiler_plugin` AS d ON d.`id` = c.`pluginid` ORDER BY c.`ordering`, a.`ordering`, a.`name` LIMIT 0, 50

Warning

CB Plugins database not upgraded. Please check and fix CB database in administration area in Components / Community Builder / Tools / Check Community Builder Database.
SQL Error (visible to super-admins only): Unknown column 'viewaccesslevel' in 'where clause' SQL=SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup FROM `XXXXX_comprofiler_plugin` WHERE `published` = 1 AND `viewaccesslevel` IN (1,2,3,6) AND `type` = 'user' ORDER BY `ordering`

CB Plugins database not upgraded. Please check and fix CB database in administration area in Components / Community Builder / Tools / Check Community Builder Database.
SQL Error (visible to super-admins only): Unknown column 'viewaccesslevel' in 'where clause' SQL=SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup FROM `XXXXX_comprofiler_plugin` WHERE `published` = 1 AND `viewaccesslevel` IN (1,2,3,6) AND `type` = 'user/plug_cbgroupjive/plugins' ORDER BY `ordering`

CB Plugins database not upgraded. Please check and fix CB database in administration area in Components / Community Builder / Tools / Check Community Builder Database.
SQL Error (visible to super-admins only): Unknown column 'viewaccesslevel' in 'where clause' SQL=SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup FROM `XXXXX_comprofiler_plugin` WHERE `published` >= 0 AND `viewaccesslevel` IN (1,2,3,6) AND `type` = 'user' ORDER BY `ordering`


Warning: file /mnt/stor5-wc1-dfw1/XXXXXX/XXXXXX/www.ccdeh.com/web/content/administrator/components/com_comprofiler/pluginsfiles.tgz still exists. This is probably due to the fact that first installation step did not complete, or second installation step did not take place. If you are sure that first step has been performed, you need to execute second installation step before using CB. You can do this now by clicking here: please click here to continue next and last installation step.

NOTE: I put XXXXX in private fields to protect my info...

NOTE: When I click on this repair link, the site returns a messed up Admin homepage and did not work...

Do I need to delete or modify some fields? Is the install having a problem with me using all of the fields?

Please advise...thanks, Tim

I went ahead and deleted two fields from the database to see if that would help...it did not.

I also note that in the top tab, I see the message "Error:1118 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 'XXXXX_comprofiler'ADD'canvas'varchar(255)DEFAULT NULL AFTER 'avatarapproved'

Your column size limit has been hit before CB 2.0 was ever installed. This means it's going to continue to be hit upon install. Navigate to _comprofiler and convert some of your database columns from varchar(255) to text type and that should help. Once CB 2.0 is installed navigate to CB > Tools and run the strict column type tool (in description of Check Fields Database tool) to convert any remaining fields then run the remaining tools to convert the tables to InnoDB. You shouldn't hit this limitation again after doing so.