I get this error message during the installation process:
CBSQLupgrader::createTableof Table #__comprofiler_sessions failed with SQL error: Table 'jos_comprofiler_sessions' already exists SQL=CREATE TABLE `jos_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
I've tried uninstalling and installing all again but the result is always the same...
I've also verified that the table jos_comprofiler_session does not exists in my database...
However, there is a reference to this table in database.cbcore.xml line 1306. I'm not sure about the fix, should i remove this section?
kind regards,
Post edited by: fidoboy, at: 2008/12/09 11:42