Couple of problems

Installation Process: Administrator and frontend menus corrected. 1.0 RC 1 to 1.0 RC 2 part 1 failed! SQL error:DB function failed with error number 1054 Unknown column 'plugin' in 'field list' SQL=INSERT INTO `MBB_comprofiler_tabs` (`title`, `description`, `ordering`, `width`, `enabled`, `plugin`, `plugin_include`, `fields`, `sys`) VALUES ( '_UE_CONNECTION', '',99, '1', 0, 'getConnectionTab', NULL, 0, 1); SQL = INSERT INTO `MBB_comprofiler_tabs` (`title`, `description`, `ordering`, `width`, `enabled`, `plugin`, `plugin_include`, `fields`, `sys`) VALUES ( '_UE_CONNECTION', '',99, '1', 0, 'getConnectionTab', NULL, 0, 1); 1.0 RC 1 to 1.0 RC 2 part 1 failed! SQL error:DB function failed with error number 1054 Unknown column 'plugin' in 'field list' SQL=INSERT INTO `MBB_comprofiler_tabs` (`title`, `description`, `ordering`, `width`, `enabled`, `plugin`, `plugin_include`, `fields`, `sys`) VALUES ( '_UE_NEWSLETTER_HEADER', '_UE_NEWSLETTER_INTRODCUTION', 99, '1', 0, 'getNewslettersTab', NULL, 0, 1); SQL = INSERT INTO `MBB_comprofiler_tabs` (`title`, `description`, `ordering`, `width`, `enabled`, `plugin`, `plugin_include`, `fields`, `sys`) VALUES ( '_UE_NEWSLETTER_HEADER', '_UE_NEWSLETTER_INTRODCUTION', 99, '1', 0, 'getNewslettersTab', NULL, 0, 1); 1.0 RC 1 to 1.0 RC 2 part 1 failed! SQL error:DB function failed with error number 1054 Unknown column 'plugin' in 'where clause' SQL=UPDATE `MBB_comprofiler_tabs` SET sys=2, enabled=1 WHERE plugin='getContactTab' SQL = UPDATE `MBB_comprofiler_tabs` SET sys=2, enabled=1 WHERE plugin='getContactTab' 1.0 RC 1 to 1.0 RC 2 part 1 failed! SQL error:DB function failed with error number 1060 Duplicate column name 'useraccessgroupid' SQL=ALTER TABLE `MBB_comprofiler_lists` ADD `useraccessgroupid` INT( 9 ) DEFAULT '18' NOT NULL AFTER `usergroupids` SQL = ALTER TABLE `MBB_comprofiler_lists` ADD `useraccessgroupid` INT( 9 ) DEFAULT '18' NOT NULL AFTER `usergroupids` 1.0 RC 1 to 1.0 RC 2 part 1 Upgrade Applied Successfully. 1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061 Duplicate key name 'pamr' SQL=ALTER TABLE `MBB_comprofiler_members` ADD INDEX `pamr` ( `pending` , `accepted` , `memberid` , `referenceid` ); SQL = ALTER TABLE `MBB_comprofiler_members` ADD INDEX `pamr` ( `pending` , `accepted` , `memberid` , `referenceid` ); 1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061 Duplicate key name 'aprm' SQL=ALTER TABLE `MBB_comprofiler_members` ADD INDEX `aprm` ( `accepted` , `pending` , `referenceid` , `memberid` ); SQL = ALTER TABLE `MBB_comprofiler_members` ADD INDEX `aprm` ( `accepted` , `pending` , `referenceid` , `memberid` ); 1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061 Duplicate key name 'membrefid' SQL=ALTER TABLE `MBB_comprofiler_members` ADD INDEX `membrefid` ( `memberid` , `referenceid` ); SQL = ALTER TABLE `MBB_comprofiler_members` ADD INDEX `membrefid` ( `memberid` , `referenceid` ); 1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061 Duplicate key name 'type_pub_order' SQL=ALTER TABLE `MBB_comprofiler_plugin` ADD INDEX `type_pub_order` ( `type` , `published` , `ordering` ); SQL = ALTER TABLE `MBB_comprofiler_plugin` ADD INDEX `type_pub_order` ( `type` , `published` , `ordering` ); 1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061 Duplicate key name 'enabled_position_ordering' SQL=ALTER TABLE `MBB_comprofiler_tabs` ADD INDEX `enabled_position_ordering` ( `enabled` , `position` , `ordering` ); SQL = ALTER TABLE `MBB_comprofiler_tabs` ADD INDEX `enabled_position_ordering` ( `enabled` , `position` , `ordering` ); 1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061 Duplicate key name 'pub_ordering' SQL=ALTER TABLE `MBB_comprofiler_lists` ADD INDEX `pub_ordering` ( `published` , `ordering` ); SQL = ALTER TABLE `MBB_comprofiler_lists` ADD INDEX `pub_ordering` ( `published` , `ordering` ); 1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061 Duplicate key name 'default_published' SQL=ALTER TABLE `MBB_comprofiler_lists` ADD INDEX `default_published` ( `default` , `published` ); SQL = ALTER TABLE `MBB_comprofiler_lists` ADD INDEX `default_published` ( `default` , `published` ); 1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061 Duplicate key name 'status_user_date' SQL=ALTER TABLE `MBB_comprofiler_userreports` ADD INDEX `status_user_date` ( `reportedstatus` , `reporteduser` , `reportedondate` ); SQL = ALTER TABLE `MBB_comprofiler_userreports` ADD INDEX `status_user_date` ( `reportedstatus` , `reporteduser` , `reportedondate` ); 1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061 Duplicate key name 'reportedbyuser_ondate' SQL=ALTER TABLE `MBB_comprofiler_userreports` ADD INDEX `reportedbyuser_ondate` ( `reportedbyuser` , `reportedondate` ); SQL = ALTER TABLE `MBB_comprofiler_userreports` ADD INDEX `reportedbyuser_ondate` ( `reportedbyuser` , `reportedondate` ); 1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061 Duplicate key name 'lastview' SQL=ALTER TABLE `MBB_comprofiler_views` ADD INDEX `lastview` ( `lastview` ); SQL = ALTER TABLE `MBB_comprofiler_views` ADD INDEX `lastview` ( `lastview` ); 1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1061 Duplicate key name 'profile_id_lastview' SQL=ALTER TABLE `MBB_comprofiler_views` ADD INDEX `profile_id_lastview` (`profile_id`,`lastview`); SQL = ALTER TABLE `MBB_comprofiler_views` ADD INDEX `profile_id_lastview` (`profile_id`,`lastview`); 1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 Upgrade Applied Successfully. Database fixing errors: CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'mbb_comprofiler' already exists SQL=CREATE TABLE `MBB_comprofiler` ( `id` int(11) NOT NULL DEFAULT 0, `user_id` int(11) NOT NULL DEFAULT 0, `firstname` varchar(100) DEFAULT NULL, `middlename` varchar(100) DEFAULT NULL, `lastname` varchar(100) DEFAULT NULL, `hits` int(11) NOT NULL DEFAULT 0, `message_last_sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `message_number_sent` int(11) NOT NULL DEFAULT 0, `avatar` varchar(255) DEFAULT NULL, `avatarapproved` tinyint(4) NOT NULL DEFAULT 1, `approved` tinyint(4) NOT NULL DEFAULT 1, `confirmed` tinyint(4) NOT NULL DEFAULT 1, `lastupdatedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `registeripaddr` varchar(50) NOT NULL DEFAULT '', `cbactivation` varchar(50) NOT NULL DEFAULT '', `banned` tinyint(4) NOT NULL DEFAULT 0, `banneddate` datetime DEFAULT NULL, `unbanneddate` datetime DEFAULT NULL, `bannedby` int(11) DEFAULT NULL, `unbannedby` int(11) DEFAULT NULL, `bannedreason` mediumtext, `acceptedterms` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`), KEY `apprconfbanid` (`approved`, `confirmed`, `banned`, `id`), KEY `avatappr_apr_conf_ban_avatar` (`avatarapproved`, `approved`, `confirmed`, `banned`, `avatar`), KEY `lastupdatedate` (`lastupdatedate`) )ENGINE=MyISAM CREATE TABLE `#__comprofiler` ( `id` int(11) NOT NULL DEFAULT 0, `user_id` int(11) NOT NULL DEFAULT 0, `firstname` varchar(100) DEFAULT NULL, `middlename` varchar(100) DEFAULT NULL, `lastname` varchar(100) DEFAULT NULL, `hits` int(11) NOT NULL DEFAULT 0, `message_last_sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `message_number_sent` int(11) NOT NULL DEFAULT 0, `avatar` varchar(255) DEFAULT NULL, `avatarapproved` tinyint(4) NOT NULL DEFAULT 1, `approved` tinyint(4) NOT NULL DEFAULT 1, `confirmed` tinyint(4) NOT NULL DEFAULT 1, `lastupdatedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `registeripaddr` varchar(50) NOT NULL DEFAULT '', `cbactivation` varchar(50) NOT NULL DEFAULT '', `banned` tinyint(4) NOT NULL DEFAULT 0, `banneddate` datetime DEFAULT NULL, `unbanneddate` datetime DEFAULT NULL, `bannedby` int(11) DEFAULT NULL, `unbannedby` int(11) DEFAULT NULL, `bannedreason` mediumtext, `acceptedterms` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`), KEY `apprconfbanid` (`approved`, `confirmed`, `banned`, `id`), KEY `avatappr_apr_conf_ban_avatar` (`avatarapproved`, `approved`, `confirmed`, `banned`, `avatar`), KEY `lastupdatedate` (`lastupdatedate`) )ENGINE=MyISAM CBSQLupgrader::createTableof Table #__comprofiler_field_values failed with SQL error: Table 'mbb_comprofiler_field_values' already exists SQL=CREATE TABLE `MBB_comprofiler_field_values` ( `fieldvalueid` int(11) NOT NULL auto_increment, `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, PRIMARY KEY (`fieldvalueid`), KEY `fieldid_ordering` (`fieldid`, `ordering`), KEY `fieldtitle_id` (`fieldtitle`, `fieldid`) )AUTO_INCREMENT=16, ENGINE=MyISAM CREATE TABLE `#__comprofiler_field_values` ( `fieldvalueid` int(11) NOT NULL auto_increment, `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, PRIMARY KEY (`fieldvalueid`), KEY `fieldid_ordering` (`fieldid`, `ordering`), KEY `fieldtitle_id` (`fieldtitle`, `fieldid`) )AUTO_INCREMENT=16, ENGINE=MyISAM CBSQLupgrader::createTableof Table #__comprofiler_fields failed with SQL error: Table 'mbb_comprofiler_fields' already exists SQL=CREATE TABLE `MBB_comprofiler_fields` ( `fieldid` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL DEFAULT '', `tablecolumns` text NOT NULL, `table` varchar(50) NOT NULL DEFAULT '#__comprofiler', `title` varchar(255) NOT NULL DEFAULT '', `description` mediumtext NOT NULL, `type` varchar(50) NOT NULL DEFAULT '', `maxlength` int(11) DEFAULT NULL, `size` int(11) DEFAULT NULL, `required` tinyint(4) DEFAULT 0, `tabid` int(11) DEFAULT NULL, `ordering` int(11) DEFAULT NULL, `cols` int(11) DEFAULT NULL, `rows` int(11) DEFAULT NULL, `value` varchar(50) DEFAULT NULL, `default` mediumtext, `published` tinyint(1) NOT NULL DEFAULT 1, `registration` tinyint(1) NOT NULL DEFAULT 0, `profile` tinyint(1) NOT NULL DEFAULT 1, `displaytitle` tinyint(1) NOT NULL DEFAULT 1, `readonly` tinyint(1) NOT NULL DEFAULT 0, `searchable` tinyint(1) NOT NULL DEFAULT 0, `calculated` tinyint(1) NOT NULL DEFAULT 0, `sys` tinyint(4) NOT NULL DEFAULT 0, `pluginid` int(11) NOT NULL DEFAULT 0, `params` mediumtext, PRIMARY KEY (`fieldid`), KEY `tabid_pub_prof_order` (`tabid`, `published`, `profile`, `ordering`), KEY `readonly_published_tabid` (`readonly`, `published`, `tabid`), KEY `registration_published_order` (`registration`, `published`, `ordering`) )AUTO_INCREMENT=54, ENGINE=MyISAM CREATE TABLE `#__comprofiler_fields` ( `fieldid` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL DEFAULT '', `tablecolumns` text NOT NULL, `table` varchar(50) NOT NULL DEFAULT '#__comprofiler', `title` varchar(255) NOT NULL DEFAULT '', `description` mediumtext NOT NULL, `type` varchar(50) NOT NULL DEFAULT '', `maxlength` int(11) DEFAULT NULL, `size` int(11) DEFAULT NULL, `required` tinyint(4) DEFAULT 0, `tabid` int(11) DEFAULT NULL, `ordering` int(11) DEFAULT NULL, `cols` int(11) DEFAULT NULL, `rows` int(11) DEFAULT NULL, `value` varchar(50) DEFAULT NULL, `default` mediumtext, `published` tinyint(1) NOT NULL DEFAULT 1, `registration` tinyint(1) NOT NULL DEFAULT 0, `profile` tinyint(1) NOT NULL DEFAULT 1, `displaytitle` tinyint(1) NOT NULL DEFAULT 1, `readonly` tinyint(1) NOT NULL DEFAULT 0, `searchable` tinyint(1) NOT NULL DEFAULT 0, `calculated` tinyint(1) NOT NULL DEFAULT 0, `sys` tinyint(4) NOT NULL DEFAULT 0, `pluginid` int(11) NOT NULL DEFAULT 0, `params` mediumtext, PRIMARY KEY (`fieldid`), KEY `tabid_pub_prof_order` (`tabid`, `published`, `profile`, `ordering`), KEY `readonly_published_tabid` (`readonly`, `published`, `tabid`), KEY `registration_published_order` (`registration`, `published`, `ordering`) )AUTO_INCREMENT=54, ENGINE=MyISAM CBSQLupgrader::createTableof Table #__comprofiler_lists failed with SQL error: Table 'mbb_comprofiler_lists' already exists SQL=CREATE TABLE `MBB_comprofiler_lists` ( `listid` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL DEFAULT '', `description` mediumtext, `published` tinyint(1) NOT NULL DEFAULT 0, `default` tinyint(1) NOT NULL DEFAULT 0, `usergroupids` varchar(255) DEFAULT NULL, `useraccessgroupid` int(9) NOT NULL DEFAULT 18, `sortfields` varchar(255) DEFAULT NULL, `filterfields` mediumtext, `ordering` int(11) NOT NULL DEFAULT 0, `col1title` varchar(255) DEFAULT NULL, `col1enabled` tinyint(1) NOT NULL DEFAULT 0, `col1fields` mediumtext, `col2title` varchar(255) DEFAULT NULL, `col2enabled` tinyint(1) NOT NULL DEFAULT 0, `col1captions` tinyint(1) NOT NULL DEFAULT 0, `col2fields` mediumtext, `col2captions` tinyint(1) NOT NULL DEFAULT 0, `col3title` varchar(255) DEFAULT NULL, `col3enabled` tinyint(1) NOT NULL DEFAULT 0, `col3fields` mediumtext, `col3captions` tinyint(1) NOT NULL DEFAULT 0, `col4title` varchar(255) DEFAULT NULL, `col4enabled` tinyint(1) NOT NULL DEFAULT 0, `col4fields` mediumtext, `col4captions` tinyint(1) NOT NULL DEFAULT 0, `params` mediumtext, PRIMARY KEY (`listid`), KEY `pub_ordering` (`published`, `ordering`), KEY `default_published` (`default`, `published`) )AUTO_INCREMENT=4, ENGINE=MyISAM CREATE TABLE `#__comprofiler_lists` ( `listid` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL DEFAULT '', `description` mediumtext, `published` tinyint(1) NOT NULL DEFAULT 0, `default` tinyint(1) NOT NULL DEFAULT 0, `usergroupids` varchar(255) DEFAULT NULL, `useraccessgroupid` int(9) NOT NULL DEFAULT 18, `sortfields` varchar(255) DEFAULT NULL, `filterfields` mediumtext, `ordering` int(11) NOT NULL DEFAULT 0, `col1title` varchar(255) DEFAULT NULL, `col1enabled` tinyint(1) NOT NULL DEFAULT 0, `col1fields` mediumtext, `col2title` varchar(255) DEFAULT NULL, `col2enabled` tinyint(1) NOT NULL DEFAULT 0, `col1captions` tinyint(1) NOT NULL DEFAULT 0, `col2fields` mediumtext, `col2captions` tinyint(1) NOT NULL DEFAULT 0, `col3title` varchar(255) DEFAULT NULL, `col3enabled` tinyint(1) NOT NULL DEFAULT 0, `col3fields` mediumtext, `col3captions` tinyint(1) NOT NULL DEFAULT 0, `col4title` varchar(255) DEFAULT NULL, `col4enabled` tinyint(1) NOT NULL DEFAULT 0, `col4fields` mediumtext, `col4captions` tinyint(1) NOT NULL DEFAULT 0, `params` mediumtext, PRIMARY KEY (`listid`), KEY `pub_ordering` (`published`, `ordering`), KEY `default_published` (`default`, `published`) )AUTO_INCREMENT=4, ENGINE=MyISAM CBSQLupgrader::createTableof Table #__comprofiler_members failed with SQL error: Table 'mbb_comprofiler_members' already exists SQL=CREATE TABLE `MBB_comprofiler_members` ( `referenceid` int(11) NOT NULL DEFAULT 0, `memberid` int(11) NOT NULL DEFAULT 0, `accepted` tinyint(1) NOT NULL DEFAULT 1, `pending` tinyint(1) NOT NULL DEFAULT 0, `membersince` date NOT NULL DEFAULT '0000-00-00', `reason` mediumtext, `description` varchar(255) DEFAULT NULL, `type` mediumtext, PRIMARY KEY (`referenceid`, `memberid`), KEY `pamr` (`pending`, `accepted`, `memberid`, `referenceid`), KEY `aprm` (`accepted`, `pending`, `referenceid`, `memberid`), KEY `membrefid` (`memberid`, `referenceid`) )ENGINE=MyISAM CREATE TABLE `#__comprofiler_members` ( `referenceid` int(11) NOT NULL DEFAULT 0, `memberid` int(11) NOT NULL DEFAULT 0, `accepted` tinyint(1) NOT NULL DEFAULT 1, `pending` tinyint(1) NOT NULL DEFAULT 0, `membersince` date NOT NULL DEFAULT '0000-00-00', `reason` mediumtext, `description` varchar(255) DEFAULT NULL, `type` mediumtext, PRIMARY KEY (`referenceid`, `memberid`), KEY `pamr` (`pending`, `accepted`, `memberid`, `referenceid`), KEY `aprm` (`accepted`, `pending`, `referenceid`, `memberid`), KEY `membrefid` (`memberid`, `referenceid`) )ENGINE=MyISAM CBSQLupgrader::createTableof Table #__comprofiler_plugin failed with SQL error: Table 'mbb_comprofiler_plugin' already exists SQL=CREATE TABLE `MBB_comprofiler_plugin` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL DEFAULT '', `element` varchar(100) NOT NULL DEFAULT '', `type` varchar(100) DEFAULT '', `folder` varchar(100) DEFAULT '', `backend_menu` varchar(255) NOT NULL DEFAULT '', `access` tinyint(3) unsigned NOT NULL DEFAULT 0, `ordering` int(11) NOT NULL DEFAULT 0, `published` tinyint(3) NOT NULL DEFAULT 0, `iscore` tinyint(3) NOT NULL DEFAULT 0, `client_id` tinyint(3) NOT NULL DEFAULT 0, `checked_out` int(11) unsigned NOT NULL DEFAULT 0, `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_folder` (`published`, `client_id`, `access`, `folder`), KEY `type_pub_order` (`type`, `published`, `ordering`) )AUTO_INCREMENT=500, ENGINE=MyISAM CREATE TABLE `#__comprofiler_plugin` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL DEFAULT '', `element` varchar(100) NOT NULL DEFAULT '', `type` varchar(100) DEFAULT '', `folder` varchar(100) DEFAULT '', `backend_menu` varchar(255) NOT NULL DEFAULT '', `access` tinyint(3) unsigned NOT NULL DEFAULT 0, `ordering` int(11) NOT NULL DEFAULT 0, `published` tinyint(3) NOT NULL DEFAULT 0, `iscore` tinyint(3) NOT NULL DEFAULT 0, `client_id` tinyint(3) NOT NULL DEFAULT 0, `checked_out` int(11) unsigned NOT NULL DEFAULT 0, `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_folder` (`published`, `client_id`, `access`, `folder`), KEY `type_pub_order` (`type`, `published`, `ordering`) )AUTO_INCREMENT=500, ENGINE=MyISAM CBSQLupgrader::createTableof Table #__comprofiler_tabs failed with SQL error: Table 'mbb_comprofiler_tabs' already exists SQL=CREATE TABLE `MBB_comprofiler_tabs` ( `tabid` int(11) NOT NULL auto_increment, `title` varchar(50) NOT NULL DEFAULT '', `description` text, `ordering` int(11) NOT NULL DEFAULT 0, `ordering_register` int(11) NOT NULL DEFAULT 10, `width` varchar(10) NOT NULL DEFAULT '.5', `enabled` tinyint(1) NOT NULL DEFAULT 1, `pluginclass` varchar(255) DEFAULT NULL, `pluginid` int(11) DEFAULT NULL, `fields` tinyint(1) NOT NULL DEFAULT 1, `params` mediumtext, `sys` tinyint(4) NOT NULL DEFAULT 0, `displaytype` varchar(255) NOT NULL DEFAULT '', `position` varchar(255) NOT NULL DEFAULT '', `useraccessgroupid` int(9) NOT NULL DEFAULT -2, PRIMARY KEY (`tabid`), KEY `enabled_position_ordering` (`enabled`, `position`, `ordering`), KEY `orderreg_enabled_pos_order` (`enabled`, `ordering_register`, `position`, `ordering`) )AUTO_INCREMENT=23, ENGINE=MyISAM CREATE TABLE `#__comprofiler_tabs` ( `tabid` int(11) NOT NULL auto_increment, `title` varchar(50) NOT NULL DEFAULT '', `description` text, `ordering` int(11) NOT NULL DEFAULT 0, `ordering_register` int(11) NOT NULL DEFAULT 10, `width` varchar(10) NOT NULL DEFAULT '.5', `enabled` tinyint(1) NOT NULL DEFAULT 1, `pluginclass` varchar(255) DEFAULT NULL, `pluginid` int(11) DEFAULT NULL, `fields` tinyint(1) NOT NULL DEFAULT 1, `params` mediumtext, `sys` tinyint(4) NOT NULL DEFAULT 0, `displaytype` varchar(255) NOT NULL DEFAULT '', `position` varchar(255) NOT NULL DEFAULT '', `useraccessgroupid` int(9) NOT NULL DEFAULT -2, PRIMARY KEY (`tabid`), KEY `enabled_position_ordering` (`enabled`, `position`, `ordering`), KEY `orderreg_enabled_pos_order` (`enabled`, `ordering_register`, `position`, `ordering`) )AUTO_INCREMENT=23, ENGINE=MyISAM CBSQLupgrader::createTableof Table #__comprofiler_userreports failed with SQL error: Table 'mbb_comprofiler_userreports' already exists SQL=CREATE TABLE `MBB_comprofiler_userreports` ( `reportid` int(11) NOT NULL auto_increment, `reporteduser` int(11) NOT NULL DEFAULT 0, `reportedbyuser` int(11) NOT NULL DEFAULT 0, `reportedondate` date NOT NULL DEFAULT '0000-00-00', `reportexplaination` text NOT NULL, `reportedstatus` tinyint(4) NOT NULL DEFAULT 0, PRIMARY KEY (`reportid`), KEY `status_user_date` (`reportedstatus`, `reporteduser`, `reportedondate`), KEY `reportedbyuser_ondate` (`reportedbyuser`, `reportedondate`) )AUTO_INCREMENT=11, ENGINE=MyISAM CREATE TABLE `#__comprofiler_userreports` ( `reportid` int(11) NOT NULL auto_increment, `reporteduser` int(11) NOT NULL DEFAULT 0, `reportedbyuser` int(11) NOT NULL DEFAULT 0, `reportedondate` date NOT NULL DEFAULT '0000-00-00', `reportexplaination` text NOT NULL, `reportedstatus` tinyint(4) NOT NULL DEFAULT 0, PRIMARY KEY (`reportid`), KEY `status_user_date` (`reportedstatus`, `reporteduser`, `reportedondate`), KEY `reportedbyuser_ondate` (`reportedbyuser`, `reportedondate`) )AUTO_INCREMENT=11, ENGINE=MyISAM CBSQLupgrader::createTableof Table #__comprofiler_views failed with SQL error: Table 'mbb_comprofiler_views' already exists SQL=CREATE TABLE `MBB_comprofiler_views` ( `viewer_id` int(11) NOT NULL DEFAULT 0, `profile_id` int(11) NOT NULL DEFAULT 0, `lastip` varchar(50) NOT NULL DEFAULT '', `lastview` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `viewscount` int(11) NOT NULL DEFAULT 0, `vote` tinyint(3) DEFAULT NULL, `lastvote` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`viewer_id`, `profile_id`, `lastip`), KEY `lastview` (`lastview`), KEY `profile_id_lastview` (`profile_id`, `lastview`, `viewer_id`) )ENGINE=MyISAM CREATE TABLE `#__comprofiler_views` ( `viewer_id` int(11) NOT NULL DEFAULT 0, `profile_id` int(11) NOT NULL DEFAULT 0, `lastip` varchar(50) NOT NULL DEFAULT '', `lastview` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `viewscount` int(11) NOT NULL DEFAULT 0, `vote` tinyint(3) DEFAULT NULL, `lastvote` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`viewer_id`, `profile_id`, `lastip`), KEY `lastview` (`lastview`), KEY `profile_id_lastview` (`profile_id`, `lastview`, `viewer_id`) )ENGINE=MyISAM CBSQLupgrader::createTableof Table #__comprofiler_sessions failed with SQL error: Table 'mbb_comprofiler_sessions' already exists SQL=CREATE TABLE `MBB_comprofiler_sessions` ( `username` varchar(50) NOT NULL DEFAULT '', `userid` int(11) unsigned NOT NULL DEFAULT 0, `ui` tinyint(4) NOT NULL DEFAULT 0, `incoming_ip` varchar(39) NOT NULL DEFAULT '', `client_ip` varchar(39) NOT NULL DEFAULT '', `session_id` varchar(33) NOT NULL DEFAULT '', `session_data` mediumtext NOT NULL, `expiry_time` int(14) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`session_id`), KEY `expiry_time` (`expiry_time`), KEY `userid` (`userid`) )ENGINE=MyISAM CREATE TABLE `#__comprofiler_sessions` ( `username` varchar(50) NOT NULL DEFAULT '', `userid` int(11) unsigned NOT NULL DEFAULT 0, `ui` tinyint(4) NOT NULL DEFAULT 0, `incoming_ip` varchar(39) NOT NULL DEFAULT '', `client_ip` varchar(39) NOT NULL DEFAULT '', `session_id` varchar(33) NOT NULL DEFAULT '', `session_data` mediumtext NOT NULL, `expiry_time` int(14) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`session_id`), KEY `expiry_time` (`expiry_time`), KEY `userid` (`userid`) )ENGINE=MyISAM

DB function failed with error number 1054 Unknown column 'f.searchable' in 'field list' SQL=SELECT f.fieldid, f.title, f.name, f.description, f.type, f.required, f.published, f.profile, f.ordering, f.registration, f.searchable, f.pluginid, f.sys, f.tablecolumns, t.title AS 'tab', t.enabled AS 'tabenabled', t.pluginid AS 'tabpluginid', p.name AS pluginname, p.published AS pluginpublished, pf.name AS fieldpluginname, pf.published AS fieldpluginpublished FROM MBB_comprofiler_fields AS f INNER JOIN MBB_comprofiler_tabs AS t ON ( (f.tabid = t.tabid) AND (t.fields = 1) ) LEFT JOIN MBB_comprofiler_plugin AS p ON p.id = t.pluginid LEFT JOIN MBB_comprofiler_plugin AS pf ON pf.id = f.pluginid WHERE t.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1) ORDER BY t.ordering, f.ordering LIMIT 0, 20

All Community Builder comprofiler_field_values table fieldid rows all match existing fields. All Community Builder comprofiler_field_values table rows link to correct fieldtype fields in comprofiler_field table. All Community Builder fields from comprofiler_fields are present as columns in the comprofiler table, but comprofiler_fields table is not yet upgraded to CB 1.2 table structure. Just going to Community Builder Fields Management will fix this automatically. Checking Community Builder folders: Avatars and thumbnails folder is Writeable. All Core CB mandatory basics Database is up to date. Core CB mandatory basics database checks done. If all lines above are in green, test completed successfully. Otherwise, please take corrective measures proposed in red. Core CB Database structure differences: Table #__comprofiler does not exist Table #__comprofiler_field_values does not exist Table #__comprofiler_fields does not exist Table #__comprofiler_lists does not exist Table #__comprofiler_members does not exist Table #__comprofiler_plugin does not exist Table #__comprofiler_tabs does not exist Table #__comprofiler_userreports does not exist Table #__comprofiler_views does not exist Table #__comprofiler_sessions does not exist