How to FIX jtablesession::Store Failed error in Joomla
Yeah.. today i get this message from my lovely website
DB function failed with error number 1146
Table ‘dbname.jos_session’ doesn’t exist SQL=INSERT INTO bla…bla…bla….
i dont know what happen and what’s wrong ??
so i go to uncle google and searching about the issue.. and lucky me, i read one article that have problem same like me. and the article give me tutorial how to fix this error in Joomla 1.5.
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;
fuih… already apply the tutorial and… yesss… my website look fine. thanks serversideguy.
So.. why it happened to me ???
Serverside guy explain, the error appear because jos_session is used to manage user sessions, so it is written to frequently. The most common cause of a corrupt table is a failed write. When the server runs out of resources, it is usually in the middle of a write, thus the corrupt jos_session table.
ok… solve the problem then..
thanks to serversideguy, google, and my hosting support team.
look great post that fix my problem here
Incoming search terms:
- jtablesession::store failed
- jtablesession::store failed db function failed with error number 1146
- session\ doesn\t exist sql=insert into
- smiley ok
- db function failed with error number 1146