Resolving DB function failed with error number 145

QUESTIONS CENTREResolving DB function failed with error number 145
ZENHOST Support Staff asked 7 years ago

We some times in joomla get this error:

jtablesession::Store Failed
DB function failed with error number 145

So what to do in order to fix this problem?

The solution is to log in to phpmyadmin and execute this sql query:

DROP TABLE IF EXISTS `jos_session`;
CREATE TABLE IF NOT EXISTS `jos_session` (
`username` varchar(150) 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’,
`client_id` tinyint(3) unsigned NOT NULL DEFAULT ‘0’,
`data` longtext,
PRIMARY KEY (`session_id`(64)),
KEY `whosonline` (`guest`,`usertype`),
KEY `userid` (`userid`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Please note that if you have altered the default Table prefix which is jos_  just change it to what you have now in the above code.

After this you could also repair all databases.

You are now good to go.