Update CB problems

Getting this when I tried to update CB on my Joomla 2.5.
Going through Siteground.com

1118 - An error has occurred.
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` ADD `canvas` varchar(255) DEFAULT NULL AFTER `avatarapproved`

Found some posts and will see if they help.

Now I have this problem

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 `jos_comprofiler_fields` AS a LEFT JOIN `jos_comprofiler_plugin` AS b ON b.`id` = a.`pluginid` INNER JOIN `jos_comprofiler_tabs` AS c ON c.`fields` = 1 AND c.`tabid` = a.`tabid` LEFT JOIN `jos_comprofiler_plugin` AS d ON d.`id` = c.`pluginid` ORDER BY c.`position`, c.`ordering`, a.`ordering`, a.`name` LIMIT 0, 20
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 `jos_comprofiler_plugin` WHERE `published` = 1 AND `viewaccesslevel` IN (1,2,3,4) 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 `jos_comprofiler_plugin` WHERE `published` >= 0 AND `viewaccesslevel` IN (1,2,3,4) AND `type` = 'user' ORDER BY `ordering`

Changed as many as possible to "text" in the types, but still not working. Stuck.

Your database table is more or less full. Too many columns. CB can't fix this until after it's installed so if you've hit this limit before installing CB 2.x you have to manually fix it. To do that you need to convert varchar columns to text columns. Once that's done change the table engine to InnoDB and install CB 2.x then run CB > Tools database checks to fix any remaining issues and correct field column types.

The other database error is due to a half installed CB 2.x trying to query for a column that doesn't exist yet due to failed database queries.

Still trying to fix. Been reading and reading on the forums and there doesn't seem to be just one concrete answer. Please Please help! I don't know what to do. I feel like if I do more, I am going to jack up the whole site altogether. I just CB is messed up.