论坛搜索好像不正常了

论坛日常站务以及建议或咨询
回复
peilz
帖子: 75
注册时间: 2005-03-26 22:31
送出感谢: 0
接收感谢: 0

论坛搜索好像不正常了

#1

帖子 peilz » 2005-08-16 20:32

在论坛的用搜索就出现错误,是不是那个表出现错误了?
peilz
帖子: 75
注册时间: 2005-03-26 22:31
送出感谢: 0
接收感谢: 0

#2

帖子 peilz » 2005-08-16 20:33

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
论坛管理员
帖子: 10213
注册时间: 2005-03-27 0:06
系统: Ubuntu 12.04
送出感谢: 7 次
接收感谢: 101 次

#3

帖子 oneleaf » 2005-08-16 21:06

使用 mysqlcheck -r phpbb 修复数据库。
mysql 有时的确会坏索引,还是不太稳定。
当净其意如虚空,远离妄想及诸取,令心所向皆无碍
回复

回到 “论坛管理”