#366 Can't open file: 'tiki_searchindex.MYI

[cemseker]

[ - Clyde v3-BETA 2 - ] [ Mon Jun 20 01:44:07 2005 ]
#### USER AGENT: Mozilla/4.0 (compatible; MSIE 6.0;
Windows NT 5.1; SV1; .NET CLR 1.1.4322)
#### ACCT: ID: -1 - Login: guest - e-mail:
guest@localhost
#### URL: http://www.sal.web.tr/clyde/phpbb/index.php?c=5
#### HOST: www.sal.web.tr
#### IP: 85.97.108.18
#### SQL: delete from `tiki_searchindex` where
`location`='tikipage' and `content_id`='1048'
#### ADODB: Errno: 1016 Message: Can't open file:
'tiki_searchindex.MYI'. (errno: 145)

}}}}}}}}}} -> tiki_error_string(Array[7])
}}}}}}}}}} LINE: 33,
/home/salweb/public_html/clyde/kernel/tiki_error_inc.php
}}}}}}}}} -> tiki_error_handler(mysql, EXECUTE,
1016, Can't open file: 'tiki_searchindex.MYI'. (errno:
145), delete from `tiki_searchindex` where
`location`='tikipage' and `..., false, Object:adodb_mysql)
}}}}}}}}} LINE: 859,
/home/salweb/public_html/clyde/util/adodb/adodb.inc.php
}}}}}}}} -> adodb_mysql::_execute(delete from
`tiki_searchindex` where `location`='tikipage' and `...)
}}}}}}}} LINE: 818,
/home/salweb/public_html/clyde/util/adodb/adodb.inc.php
}}}}}}} ->
adodb_mysql::adodb_mysql::execute(delete from
`tiki_searchindex` where `location`=? and
`content_i..., Array[2])
}}}}}}} LINE: 349,
/home/salweb/public_html/clyde/kernel/TikiDB.php
}}}}}} ->
adodb_mysql::adodb_mysql::tikidb::query(delete from
`tiki_searchindex` where `location`=? and
`content_i..., Array[2], -1, -1, -1)
}}}}}} LINE: 188,
/home/salweb/public_html/clyde/kernel/TikiBase.php
}}}}} ->
adodb_mysql::adodb_mysql::tikidb::tikisystem::query(delete
from `tiki_searchindex` where `location`=? and
`content_i..., Array[2])
}}}}} LINE: 270,
/home/salweb/public_html/clyde/search/refresh_functions.php
}}}} ->
adodb_mysql::adodb_mysql::tikidb::tikisystem::insert_index(Array[3],
tikipage, 1048)
}}}} LINE: 45,
/home/salweb/public_html/clyde/search/refresh_functions.php
}}} ->
adodb_mysql::adodb_mysql::tikidb::tikisystem::refresh_index_wiki(1048)
}}} LINE: 30,
/home/salweb/public_html/clyde/search/refresh_functions.php
}} ->
adodb_mysql::adodb_mysql::tikidb::tikisystem::random_refresh_index_wiki()
}} LINE: 20,
/home/salweb/public_html/clyde/search/refresh.php
} ->
adodb_mysql::adodb_mysql::tikidb::tikisystem::refresh_search_index()
} LINE: 0,

[cemseker]

Logged In: YES
user_id=1222549

When I tried to access `tiki_searchindex`, I get "in use"
error in phpMyAdmin

[cemseker]

Logged In: YES
user_id=1222549

I have deleted and recreated tiki_searchindex table by
CREATE TABLE `tiki_searchindex` (
`searchword` varchar(80) NOT NULL default '',
`location` varchar(80) NOT NULL default '',
`content_id` int(11) NOT NULL default '0',
`count` int(11) NOT NULL default '1',
`last_update` int(11) NOT NULL default '0',
PRIMARY KEY (`searchword`,`location`,`content_id`),
KEY `tiki_searchidx_last_update_idx` (`last_update`)
) TYPE=MyISAM;

--
-- Dumping data for table `tiki_searchindex`
--

INSERT INTO `tiki_searchindex` VALUES ('grafik', 'tikipage',
4, 2, 1114734822);
INSERT INTO `tiki_searchindex` VALUES ('welcome',
'tikipage', 4, 2, 1114734822);

Problem seems solved at least for now. But I need to
investigate if this is a local problem only just for my
installation.