Problem database

Merak · **Joined:** Sat Nov 12, 2005 1:16 pm **Posts:** 3

Hi, i have a prooblem with the DB when i enter on my website. This is:

DB function failed with error number 1016
Can't open file: 'jos_session.MYI'. (errno: 145) SQL=SELECT session_id FROM jos_session WHERE session_id = MD5( '1b59a6274d3e408c127f7d8314c200b8' )
SQL =
SELECT session_id
FROM jos_session
WHERE session_id = MD5( '1b59a6274d3e408c127f7d8314c200b8' )

I repaired the DB and the problem is again. Anything idea?

coldfrost · **Posted:** Sun Dec 04, 2005 12:05 pm

Hi
I have also run into this problem, but that's only for two of my sites.
I hope someone can respond to this problem, because it looks like there are not only us two who has this problem

So, please...can someone help us out? $:-\$

de · **Joined:** Thu Aug 18, 2005 9:06 am **Posts:** 1465

Maybe just try to drop the table and recreate it (it should not contain any permanent data):

Code:

DROP TABLE `jos_session`;
CREATE TABLE `jos_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;

(copied from /installation/sql/joomla.sql)

coldfrost · **Posted:** Sun Dec 04, 2005 2:47 pm

Hi

Thanks alot, it worked great.
I'm not so into databases, so I'm a littlebit nervous to start to drop some wrong things.... :-[

Joomla! Discussion Forums

Forum rules

Problem database

Quick reply

Who is online