
I dropped the table.. then ran: (make sure the "xoops session" is named the same as yours was)
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,
PRIMARY KEY (sess_id),
KEY updated (sess_updated)
) TYPE=MyISAM;