[SOLVED] CB Tools - Error: 1075 Incorrect Tables

I'm trying to run the Check CB Database Tool and it lists the following issues:

Core CB Database structure differences:
Table #__comprofiler Index PRIMARY does not exist
Table #__comprofiler Index user_id does not exist
Table #__comprofiler Index apprconfbanid does not exist
Table #__comprofiler Index avatappr_apr_conf_ban_avatar does not exist
Table #__comprofiler Index lastupdatedate does not exist
Table #__comprofiler_field_values Column fieldvalueid AUTO_INCREMENT attribute is "" instead of "auto_increment"
Table #__comprofiler_field_values Index PRIMARY does not exist
Table #__comprofiler_field_values Index fieldid_ordering does not exist
Table #__comprofiler_field_values Index fieldtitle_id does not exist
Table #__comprofiler_fields Column fieldid AUTO_INCREMENT attribute is "" instead of "auto_increment"
Table #__comprofiler_fields Index PRIMARY does not exist
Table #__comprofiler_fields Index tabid_pub_prof_order does not exist
Table #__comprofiler_fields Index readonly_published_tabid does not exist
Table #__comprofiler_fields Index registration_published_order does not exist
Table #__comprofiler_lists Column listid AUTO_INCREMENT attribute is "" instead of "auto_increment"
Table #__comprofiler_lists Index PRIMARY does not exist
Table #__comprofiler_lists Index pub_ordering does not exist
Table #__comprofiler_lists Index default_published does not exist
Table #__comprofiler_members Index PRIMARY does not exist
Table #__comprofiler_members Index pamr does not exist
Table #__comprofiler_members Index aprm does not exist
Table #__comprofiler_members Index membrefid does not exist
Table #__comprofiler_plugin Column id AUTO_INCREMENT attribute is "" instead of "auto_increment"
Table #__comprofiler_plugin Index PRIMARY does not exist
Table #__comprofiler_plugin Index idx_folder does not exist
Table #__comprofiler_plugin Index type_pub_order does not exist
Table #__comprofiler_tabs Column tabid AUTO_INCREMENT attribute is "" instead of "auto_increment"
Table #__comprofiler_tabs Index PRIMARY does not exist
Table #__comprofiler_tabs Index enabled_position_ordering does not exist
Table #__comprofiler_tabs Index orderreg_enabled_pos_order does not exist
Table #__comprofiler_userreports Column reportid AUTO_INCREMENT attribute is "" instead of "auto_increment"
Table #__comprofiler_userreports Index PRIMARY does not exist
Table #__comprofiler_userreports Index status_user_date does not exist
Table #__comprofiler_userreports Index reportedbyuser_ondate does not exist
Table #__comprofiler_views Index PRIMARY does not exist
Table #__comprofiler_views Index lastview does not exist
Table #__comprofiler_views Index profile_id_lastview does not exist
Table #__comprofiler_sessions Index PRIMARY does not exist
Table #__comprofiler_sessions Index expiry_time does not exist
Table #__comprofiler_sessions Index userid does not exist

When I try to run the Fix, the browser page reloads with an error page with the content missing and the page layout looking broken. (Screen Capture attached) The title of the error page that appears is:

Error: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jcms3_comprofiler_field_values` CHANGE `fieldvalueid` `fieldvalueid` int(11) NOT NULL auto_increment

I've tried reinstalling CB 1.9.1 and receive the following error:

Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `jcms3_comprofiler_field_values` CHANGE `fieldvalueid` `fieldvalueid` int(11) NOT NULL auto_increment
Error

Error installing component

I'm working from a Joomla 3.4.8 version, with PHP 5.4.45. I've tried running direct repairs of the tables through phpMyAdmin but to no avail. If anyone has any suggestions I'd appreciate it.

Thanks much.

Were you attempting to migration from CB 1.x? Sounds like your migration failed. Revert to a backup. Next disable all Joomla extension and all 3rd party intgrations with CB (modules, system plugins, kunena integration, k2 integration, etc..). Next install CB 2.x and it should migrate fine without conflict. Do not install CB 1.x over CB 2.x as it just makes the situation worse.

I was trying to run the tools function for CB 1.9.1 when I encountered the issue.

I went back to the original database I exported and found that the AUTO_INCREMENT attribute was dropped from the sql file.

Error database
DROP TABLE IF EXISTS `jcms3_comprofiler_field_values`;
CREATE TABLE IF NOT EXISTS `jcms3_comprofiler_field_values` (
`fieldvalueid` int(11) NOT NULL,
`fieldid` int(11) NOT NULL DEFAULT '0',
`fieldtitle` varchar(255) NOT NULL DEFAULT '',
`ordering` int(11) NOT NULL DEFAULT '0',
`sys` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Fixed database
DROP TABLE IF EXISTS `j33_comprofiler_field_values`;
CREATE TABLE IF NOT EXISTS `j33_comprofiler_field_values` (
`fieldvalueid` int(11) NOT NULL,
`fieldid` int(11) NOT NULL DEFAULT '0',
`fieldtitle` varchar(255) NOT NULL DEFAULT '',
`fieldlabel` varchar(255) NOT NULL DEFAULT '',
`ordering` int(11) NOT NULL DEFAULT '0',
`sys` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=777 DEFAULT CHARSET=latin1;

Importing in the corrected database resolved the errors being flagged by the CB Tools and allowed for both reinstalling CB 1.9.1 as well as updating CB to version 2.0.12.