MyISAM- innoDB engines, plug_cbactivity_3.0.0-rc.1

After upgrading to CB 2.0.8, I encountered several problems. For the last 15 days, I tried to address issues blocking the frontend cb-user profile access page. I read in-and-out all forum pages with regard to MyISAM and innoDB Engines, and similar issues already addressed on the forums. I followed the instructions of all the answers. I am still encountering problems on the backend and the frontend.

Backend:
A. I re-installed pkg_communitybuilder_2.0.8+ac65b53b3
- I run all Community Builder tools: CB users database: all green.Check Community Builder User Fields Database with strict column types, used the fix tool as recommended, then all green. Check Community Builder Plugin Database: all green, CB Tools: Check CB plugins database: Results: most green, with specific issues:
CB plugin "Rounded": no database or no database description.
CB plugin "en-GB": en-GB has no readable xml file /home/frontmat/public_html/components/com_comprofiler/plugin/language/en-gb/language.xml
CB plugin "CB Activity" database structure differences:
Table #__comprofiler_plugin_activity Index type_item_date does not exist
Table #__comprofiler_plugin_activity Storage Engine is MyISAM instead of InnoDB
Table #__comprofiler_plugin_activity_comments does not exist
Table #__comprofiler_plugin_activity_hidden does not exist
Table #__comprofiler_plugin_activity_actions does not exist
Table #__comprofiler_plugin_activity_emotes does not exist
CB plugin "CB LastViews Tab": no database or no database description.
CB plugin "Invoicing Invoices -Tab": no database or no database description.
The CB plugin "CB Activity" database structure differences can be fixed (adjusted) by clicking here: Click here to fix (adjust) all CB plugin "CB Activity" database differences listed above Click here to show details. When running “CB fix”: "an error has occurred.
“ 1071 Specified key was too long; max key length is 1000 bytes SQL=ALTER TABLE `aj9u3_comprofiler_plugin_activity` ADD KEY `type_item_date` (`type`, `item`, `date`)”

- I checked Joomla user table: administrator/components/com_admin/sql/updates/mysql/3.0.0.sql line 87:ALTER TABLE `#__session` ENGINE=InnoDB; all tables uses InnoDB; see file attached to Ticket ID: 252452
- I verified mysql tables engines and extracted a report showing several CB plugins still using MyISAM (see Ticket ID: 252452, attached file MyISAM-InnoDB MySQL Tables), all cb subscriptions table engines are using MyISAM, secondly a large number of other CB plugins are still using MyISAM,
- I uninstalled /unpublished third party plugins potential source of the problem.

B: I installed plug_cbactivity_3.0.0-rc.1+908e20f9c, hoping that it addresses the old activity plugin issues. plug_cbactivity_3.0.0-rc.1+908e20f9c
Specified key was too long; max key length is 1000 bytes SQL=ALTER TABLE `xxxxx_comprofiler_plugin_activity` ADD KEY `type_item_date` (`type`, `item`, `date`):...

When I enable plug_cbactivity_3.0.0-rc, I encounter the following problems:
- Frontend, CB user profile access: blank page. Debug message: Fatal error: Class 'CB\Plugin\Activity\Activity' not found in /home/xxxxx/public_html/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.php on line 31
- Backend: Community Builder Tools: CB users database, CB plugin database, Check Community Builder User Fields Database: all green. Check Community Builder Plugin Database: redirect to frontend, no debugging message or elements issue on the console.

Your help will be well appreciated.

Your install is incomplete. It's erroring at the database level so the files are not copying over completely. You need to fix your database table engine. Navigate to your database in phpmyadmin and fix all of Joomla and CBs tables to InnoDB. CB uses the engine of the _users table specifically. The index causing this issue has been removed for RC2 as many installs seam to still be on MyISAM (everyone should fix this ASAP). You'll probably need to uninstall CB Activity before attempting to install it again.