Recent Topics

1 Feb 01, 2010 01:43    

My b2evolution Version: 3.3.1

I got an error that my evo_sessions table was corrupt and so noone could access the site. I then dropped the table and need to add it.

I tried recreating with the table with the fields listed here http://doc.b2evo.net/DB_schema/

but it looks like that is out of date. Is there somewhere I can get the correct table fields? Thanks!

2 Feb 01, 2010 02:00

-- Table structure for table `evo_sessions`
--

CREATE TABLE IF NOT EXISTS `evo_sessions` (
  `sess_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sess_key` char(32) DEFAULT NULL,
  `sess_hitcount` int(10) unsigned NOT NULL DEFAULT '1',
  `sess_lastseen` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
  `sess_ipaddress` varchar(15) NOT NULL DEFAULT '',
  `sess_user_ID` int(10) DEFAULT NULL,
  `sess_data` mediumblob,
  PRIMARY KEY (`sess_ID`),
  KEY `sess_user_ID` (`sess_user_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Run this under 'sql' tab, that should recreate it, watch out for the CHARSET=utf8 though

3 Feb 01, 2010 03:15

Thanks a lot for the quick response!


Form is loading...