论坛搜索好像不正常了

[peilz]

在论坛的用搜索就出现错误，是不是那个表出现错误了？

[peilz]

Could not delete old search id sessions

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_search_results.MYI'. (errno: 145)

DELETE FROM phpbb_search_results WHERE session_id NOT IN ('06a54c0be3d8f3a9471daa4987065550', '0b2888b577ff299eb81f27447d72e2e8', '0fa8067c9cacb3c745a2f032f6f11157', '0ffafc851388df9596fbcef06f096405', '11f723404a0c351c3843416df521aa4b', '1f443b52c89a3db411ee64a8d064177d', '1f820921418d2c15a0cbf8351178f6cc', '24f1893f92359d298976ffb113221f36', '2846b60dc30e99b2f2d7ec9200921cd4', '309aeae4ccb4e48b58a0b4ab26f3375d', '35d95efd8c3370b802997ef762e23a82', '3bf914e86d6224c2ab82f32130ac311c', '485844f82bb9dcfb615df35b8ade9a32', '5121cb9f642da80d691f088c668f263a', '537e1f08f604d4adf323961563835195', '5a9fd3a289b3fd2e628e3b5dd7f7b1a9', '5b20a73a2276db80362fe3eec70b591d', '5edeb5f68a61008711f7a81fdaccb531', '60f8d0b7aabad8f4a3ff6925dc741d53', '6ad79a3ae86cf984dbcf74e9ad402abb', '6bfca5373df5f607a4a004d5f6d5705e', '6e49aa9ebd36bd8b7b81cdba73f16387', '6efaa7d838b44f029e186e34923459d2', '6faf2e46ebaea6828543e0357e7f9089', '718214b69bcde6cd9fea940a4721a881', '800ae48f87ca19d6a8a68d5d53d47c04', '8159608bbb3e9e6db27539a8da80bda0', '88265bc498a31716cca7477aa588bccb', '8870d440f606d247152641c8d6a771b7', '8d0fbfd7e6bd204f9b5ec4fe221c1cbb', '992fa2ef6c18d10436d895965e8a2246', 'aa419b533aa87a37b5c664ba12a21923', 'af6d87901ebff5ce1d318e8c4efd9cbc', 'bae69cdf3c1a47fd659312ef7a128e7d', 'bd1be081b8a401aa65882c4dd4b1a240', 'c3e1c2492dc7943f4a896d9f379d45a3', 'c7f5801ea0597f4396314cb49ea48cd0', 'cabec6737bade0c3d7084411363fcafc', 'd02767091e8f61fc364d4600b9b9e8c2', 'd5801e6b97f0a32956984fa7ca38756d', 'd73b7dac451308c5a1fca7b55b109cfb', 'd975959d32932a49078ee8300c35d077', 'e3607f82dfa932ef5eb93ce00fe399ca', 'e7856e02bcdcdea1a96f00ae7f280ceb', 'fc825da55513d42282aff777e6ab6d0e')

Line : 685
File : search.php

[oneleaf]

使用 mysqlcheck -r phpbb 修复数据库。
mysql 有时的确会坏索引，还是不太稳定。