 JoshPet
FusionBB Developer
Total Posts: 6722
Birthday: 02-08
Location: Charlotte, NC
Average Post Ranks%:
|
07-12-08 10:40 PM - Post#77955
In response to greg
Hey Try dropping the fbb_sessions table, then run this query to recreate it.
Code:
CREATE TABLE IF NOT EXISTS `fbb_sessions` (
`session_id` varchar(64) NOT NULL default '',
`session_time` int(11) unsigned NOT NULL default '0',
`user_id` mediumint(8) unsigned NOT NULL default '0',
`session_visible` tinyint(1) NOT NULL default '1',
`session_details` tinyint(1) NOT NULL default '1',
`session_username` varchar(100) default NULL,
`session_ip` varchar(15) default NULL,
`session_track_vars` text,
`session_site_auth` text,
`session_forum_auth` mediumtext,
`session_mod_forums` text,
`session_post_array` text,
`session_error_array` text,
`session_user_loc` varchar(255) default NULL,
`session_forum_name` varchar(255) default NULL,
`session_forum_id` mediumint(8) default NULL,
`session_topic_name` varchar(255) default NULL,
`session_topic_id` mediumint(8) default NULL,
`session_user_prefs` text NOT NULL,
`session_cp_auth` text NOT NULL,
`session_cp_authenticated` tinyint(1) unsigned NOT NULL default '0',
`session_http_via` varchar(100) default NULL,
`session_referer` varchar(150) default NULL,
`session_user_agent` varchar(100) default NULL,
`session_total_pt` smallint(4) unsigned NOT NULL default '0',
`session_unread_pt` smallint(4) unsigned NOT NULL default '0',
`session_forum_visit` text,
`session_topic_visit` text,
`session_become_id` mediumint(8) unsigned NOT NULL default '0',
`session_become_name` varchar(100) default NULL,
`session_group_flag` varchar(30) NOT NULL default '',
`session_name_color` varchar(15) default NULL,
PRIMARY KEY (`session_id`,`session_time`),
KEY `user_id_index` (`user_id`,`session_visible`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Feel Better, Feel Younger, Sleep Better - Trans-D Tropin
Visit www.BuyTransD.com - use coupon code 1004 to save $20 |
|
