Hello All:
Please help me fix this installation issue ...
I am installing CB and during the installation i get the following errors:
Installation Process:
Administrator and frontend menus corrected.
1.0 Beta 4 to 1.0 RC 1 Upgrade Applied Successfully.
1.0 RC 1 to 1.0 RC 2 part 1 Upgrade Applied Successfully.
1.0 RC 1 to 1.0 RC 2 part 2 Upgrade Applied Successfully.
1.0 RC 1 to 1.0 RC 2 part 3 Upgrade Applied Successfully.
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 Upgrade Applied Successfully.
1.0.2 to 1.1 Upgrade Applied Successfully.
Database fixing errors:
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'qmilgcdemo_comprofiler' already exists SQL=CREATE TABLE `qmilGcDemo_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 'qmilgcdemo_comprofiler_field_values' already exists SQL=CREATE TABLE `qmilGcDemo_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 'qmilgcdemo_comprofiler_fields' already exists SQL=CREATE TABLE `qmilGcDemo_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 'qmilgcdemo_comprofiler_lists' already exists SQL=CREATE TABLE `qmilGcDemo_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 'qmilgcdemo_comprofiler_members' already exists SQL=CREATE TABLE `qmilGcDemo_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 'qmilgcdemo_comprofiler_plugin' already exists SQL=CREATE TABLE `qmilGcDemo_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 'qmilgcdemo_comprofiler_tabs' already exists SQL=CREATE TABLE `qmilGcDemo_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 'qmilgcdemo_comprofiler_userreports' already exists SQL=CREATE TABLE `qmilGcDemo_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 'qmilgcdemo_comprofiler_views' already exists SQL=CREATE TABLE `qmilGcDemo_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
Core CB database upgrades done. If all lines above are in green, database upgrade completed successfully. Otherwise, please report exact errors and queries to forum, and try checking database again in components : community builder : tools : check database.
Then when I check the databse from the components-> tools i get the following:
Checking Community Builder Database:
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
The Core CB database structure differences can be fixed (adjusted) by clicking here: Click here to Fix (adjust) all Core CB database differences listed above (you can also Click here to preview fixing (adjusting) queries in a dry-run), but in all cases you need to backup database first as this adjustment is changing the database structure to match the needed structure for the installed version.
Core CB database checks done. If all lines above are in green, test completed successfully. Otherwise, please take corrective measures proposed in red.
