5
Ok ... this was ages ago. IPB alters the XOOPS tables on installation. From a quick look the correct thing
might be:
#
# Table structure for table `session`
#
CREATE TABLE `xoops_session` (
`sess_id` varchar(32) NOT NULL default '',
`sess_updated` int(10) unsigned NOT NULL default '0',
`sess_ip` varchar(15) NOT NULL default '',
`sess_data` text NOT NULL,
`member_name` varchar(64) NOT NULL default '',
`member_id` mediumint(8) NOT NULL default '0',
`browser` varchar(64) NOT NULL default '',
`login_type` tinyint(1) NOT NULL default '0',
`location` varchar(40) NOT NULL default '',
`member_group` smallint(3) NOT NULL default '0',
`in_forum` smallint(5) NOT NULL default '0',
`in_topic` int(10) NOT NULL default '0',
PRIMARY KEY (`sess_id`),
KEY `updated` (`sess_updated`),
KEY `in_topic` (`in_topic`),
KEY `in_forum` (`in_forum`)
) TYPE=MyISAM;
So you can try deleting the table we created before and maybe create this one instead. With a little luck ...
(do you have any old sql backup where you can just grad the table structure from the dump?)
EDIT: i edited this at 22:22 again so the querry changed if you looked at it in the 3 minutes after i posted!
Sorry, this signature is experiencing technical difficulties. We will return you to the sheduled signature as soon as possible ...
