I have two clients using Yahoo Small Business as their host. Both sites

A

amy

New member
continually get jos_session errors...? about once a month... it will say something like:

Can't open file: 'jos_session.MYI' (errno: 145) SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '5123d5cae7073ae9f2407f5021117d1f','1245181982','','0','1','0' )

I have to run the following script to get it to run again:

#
# Table structure for table `jos_session`
#
DROP table IF EXISTS 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;
#
# Dumping data for table `mos_session`
#


Then it works again... but it never fails, a few weeks to a month later the same problem happens, for both sites. Any ideas?????
 
Back
Top