If I go to my Mambo website and get an error on the session table.
To solve this, please login into your cpanel, and go to 'Site
Management Tools' and choose 'MySQL Databases' go to your mambo
installation and click 'Repair'.
If the repair function does not work you may try the following (use with caution and only if you are familiar with SQL statements, the below data might be from an older version so please check the SQL records).
You can fix this by going to myphpadmin and run the following script in the sql-query manager:
DROP TABLE IF EXISTS `mos_session`; CREATE TABLE `mos_session` ( `username` varchar(50) default '', `time` varchar(14) default '', `session_id` varchar(200) NOT NULL default '0', `guest` tinyint(4) default '1', `userid` int(11) default '0', `usertype` varchar(50) default '', `gid` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`session_id`), KEY `whosonline` (`guest`,`usertype`) ) TYPE=MyISAM; |
This should solve your issue.
