I am using IIS7 on Windows 7, Joomla 2.5.8 (fresh install), PHP 5.4.10 (fresh), Mysql 5.0.10 (fresh) and trying to install Community Builder 1.9 (cb_1_9_0-unzip1st.zip).
When installing com_comprofiler.zip the following is still appearing in red after the second pass:
Installation Process:
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 'jom_comprofiler' already exists SQL=CREATE TABLE `Jom_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 'jom_comprofiler_field_values' already exists SQL=CREATE TABLE `Jom_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 'jom_comprofiler_fields' already exists SQL=CREATE TABLE `Jom_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 'jom_comprofiler_lists' already exists SQL=CREATE TABLE `Jom_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, `viewaccesslevel` int(10) unsigned 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, `viewaccesslevel` int(10) unsigned 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 'jom_comprofiler_members' already exists SQL=CREATE TABLE `Jom_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 'jom_comprofiler_plugin' already exists SQL=CREATE TABLE `Jom_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 'jom_comprofiler_tabs' already exists SQL=CREATE TABLE `Jom_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 '', `viewaccesslevel` int(10) unsigned NOT NULL DEFAULT 0, `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 '', `viewaccesslevel` int(10) unsigned NOT NULL DEFAULT 0, `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 'jom_comprofiler_userreports' already exists SQL=CREATE TABLE `Jom_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 'jom_comprofiler_views' already exists SQL=CREATE TABLE `Jom_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
Using the Tools to check Core DB Database the following is shown:
CB Tools: Check Core CB database: Results
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.
Clicking to fix the errors produces:
Core CB Database adjustments errors:
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'jom_comprofiler' already exists SQL=CREATE TABLE `Jom_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 'jom_comprofiler_field_values' already exists SQL=CREATE TABLE `Jom_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 'jom_comprofiler_fields' already exists SQL=CREATE TABLE `Jom_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 'jom_comprofiler_lists' already exists SQL=CREATE TABLE `Jom_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, `viewaccesslevel` int(10) unsigned 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, `viewaccesslevel` int(10) unsigned 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 'jom_comprofiler_members' already exists SQL=CREATE TABLE `Jom_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 'jom_comprofiler_plugin' already exists SQL=CREATE TABLE `Jom_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 'jom_comprofiler_tabs' already exists SQL=CREATE TABLE `Jom_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 '', `viewaccesslevel` int(10) unsigned NOT NULL DEFAULT 0, `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 '', `viewaccesslevel` int(10) unsigned NOT NULL DEFAULT 0, `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 'jom_comprofiler_userreports' already exists SQL=CREATE TABLE `Jom_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 'jom_comprofiler_views' already exists SQL=CREATE TABLE `Jom_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 'jom_comprofiler_sessions' already exists SQL=CREATE TABLE `Jom_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
Have tried deleting the tables and trying again as well as fresh installs of PHP, Mysql and Joomla.
ANy help much appreciated.
