Joomla!
http://forum.joomla.org/

Problem database
http://forum.joomla.org/viewtopic.php?f=35&t=18197		 Page 1 of 1
Author:  Merak [ Sat Nov 12, 2005 3:25 pm ]
Post subject:  Problem database
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?
Author:  coldfrost [ Sun Dec 04, 2005 12:05 pm ]
Post subject:  Re: Problem database
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? :-\
Author:  de [ Sun Dec 04, 2005 12:53 pm ]
Post subject:  Re: Problem database
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)
Author:  coldfrost [ Sun Dec 04, 2005 2:47 pm ]
Post subject:  Re: Problem database
:laugh: 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.... :-[
Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/