hi everybody
im trying to install the component, the installation is sucess, but when i go to Check Core CB database the results is this one:
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

and if i try to do something in field management appear the following error:
Función de la base de datos fallida con el número de error 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 WCS_comprofiler_fields AS f INNER JOIN WCS_comprofiler_tabs AS t ON ( (f.tabid = t.tabid) AND (t.fields = 1) ) LEFT JOIN WCS_comprofiler_plugin AS p ON p.id = t.pluginid LEFT JOIN WCS_comprofiler_plugin AS pf ON pf.id = f.pluginid WHERE t.useraccessgroupid IN (1,2,3,4,5,6,7,8,-2,-1) ORDER BY t.ordering, f.ordering LIMIT 0, 20


i dont really know whats happening can somebody help me please.

I am getting the same error from checking the Core DB. Sorry if it looks like a topic hijack, but I'm having the same issue.

As well as:

For User Managemnt
For Tab Management
For Field Management
For List Management

I had the same errors, and was able to fix both by going to the Community Builder -> Tools page in the admin area. There was a link that ran a script that fixed the issues & the errors went away.

HTH

Hi ... my name is Raffaele and i have the same problems ... well, i try to run scripts ti fix the problems but i register an error and nothing is fixed. Someone can help me !?

Some details:

I have istalled "Joomla! 2.5.1 Stable [ Ember ]" ... and this is the error of the script (ALL RED):

Core CB Database adjustments errors:
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'iir_comprofiler' already exists SQL=CREATE TABLE `IIR_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 'iir_comprofiler_field_values' already exists SQL=CREATE TABLE `IIR_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 'iir_comprofiler_fields' already exists SQL=CREATE TABLE `IIR_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 'iir_comprofiler_lists' already exists SQL=CREATE TABLE `IIR_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 'iir_comprofiler_members' already exists SQL=CREATE TABLE `IIR_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 'iir_comprofiler_plugin' already exists SQL=CREATE TABLE `IIR_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 'iir_comprofiler_tabs' already exists SQL=CREATE TABLE `IIR_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 'iir_comprofiler_userreports' already exists SQL=CREATE TABLE `IIR_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 'iir_comprofiler_views' already exists SQL=CREATE TABLE `IIR_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 'iir_comprofiler_sessions' already exists SQL=CREATE TABLE `IIR_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