SiS001! Board - [第一会所关闭注册]

标题: [求助] 搜索的时候出现错误:Error: Query execution was interrupted [打印本页]

作者: 63220 时间: 2011-4-7 15:58 标题: 搜索的时候出现错误:Error: Query execution was interrupted

Discuz! info: MySQL Query Error

User: 63220
Time: 2011-4-7 3:55pm
Script: /bbs/search.php

完整信息:
SQL: SELECT t.tid, t.closed, t.author FROM [Table]threads t WHERE t.fid IN ('340','1','283','134','420','123','344','352','347','428','400','302','261','114','353','355','354','369','198','313','226','135','294','6','412','349','350','213','200','338','337','357','308','309','307','371','342','356','370','295','290','292','296','298','305','424','427','426','379','327','325','210','238','258','237','239','236','274','393','310','396','301','304','85','401','139','193','76','406','122','143','230','229','231','341','20','25','58','77','345','27','276','311','212','270','187','121','321','248','322','383','391','422','423','390','359','372','83','279','96','31','417','395','385','185','415','366','278','361','437','368','405','334','382','358','381','408','392','360','315','380','252','186','253','254','297','277','184','64','68','61','409','249','62','411','60','429','242','63','419','183','373','377','376','375','374','148','154','155','157','159','156','158','162','160','161','153','167','166','163','164','165','168','172','149','171','169','170','173','174','175','176','192','151','178','179','177','180','181','182','150','74','152','431') AND t.displayorder>='0' AND (0 OR MATCH(t.subject) AGAINST ('桐谷' IN BOOLEAN MODE)) ORDER BY tid DESC LIMIT 500
Error: Query execution was interrupted
Errno.: 1317

原来是没有的,最近一段基本上都用不了老出这个,啥原因说?

作者: 文藝猫青年 时间: 2011-4-7 16:11

呃，刚才我试了下，也是这样的问题，可能搜索功能还有点问题，耐心等待下吧

作者: 63220 时间: 2011-4-7 16:16

汗,我还以为就我有这个问题呢

作者: lao7391730 时间: 2011-4-7 16:17

我刚试了一下，搜索功能并没有问题。楼主和河流试着换一个论坛IP看看。呵呵。

作者: 63220 时间: 2011-4-7 16:32

换了一个,还是这个问题,是啥原因捏

作者: 文藝猫青年 时间: 2011-4-7 16:32

~~可能是吧
我现在又试了一次又好了，可能是有的ip有问题，楼主换个试试吧
论坛可用的ip很多

作者: 文藝猫青年 时间: 2011-4-7 16:34

67.220.93.10
我刚才用了上面这个可用，一开始忘了用了哪个了出了问题

作者: 63220 时间: 2011-4-7 16:39

搜英文字母的东西就没有问题
但是搜中文就不行了啊

作者: linchaooo 时间: 2011-4-7 16:51

我也刚想发帖关于搜索的，也不行，如下：

Discuz! info: MySQL Query Error

User: linchaooo
Time: 2011-4-7 4:49pm
Script: /bbs/search.php

SQL: SELECT t.tid, t.closed, t.author FROM [Table]threads t WHERE t.fid IN ('340','1','283','134','420','123','344','352','347','428','400','302','261','114','353','355','354','369','198','313','226','135','294','6','412','349','350','213','200','338','337','357','308','309','307','371','342','356','370','295','290','292','296','298','305','424','427','426','379','327','325','210','238','258','237','239','236','274','393','310','396','301','289','304','85','401','139','193','76','406','122','143','230','229','231','341','20','25','58','77','345','27','276','311','212','270','187','121','321','248','322','383','391','422','423','390','359','372','71','83','279','96','31','417','395','385','185','415','366','278','361','437','368','405','334','382','358','381','408','392','360','315','380','252','186','253','254','297','250','277','184','64','68','61','409','249','62','411','60','429','242','63','419','183','373','377','376','375','374','416','148','154','155','157','159','156','158','162','160','161','153','167','166','163','164','165','168','172','149','171','169','170','173','174','175','176','192','151','178','179','177','180','181','182','150','74','152','431') AND t.displayorder>='0' AND (0 OR MATCH(t.subject) AGAINST ('浙江' IN BOOLEAN MODE)) ORDER BY tid DESC LIMIT 500
Error: Query execution was interrupted
Errno.: 1317

Similar error report has beed dispatched to administrator before.

作者: 文藝猫青年 时间: 2011-4-7 16:53

看来还是有点问题啊，再等等吧

作者: linchaooo 时间: 2011-4-7 16:59

引用:

原帖由 支枕听河流 于 2011-4-7 16:32 发表
~~可能是吧
我现在又试了一次又好了，可能是有的ip有问题，楼主换个试试吧
论坛可用的ip很多

我换了一个IP。结果还是一样，估计是坏了

作者: 转身遇见你 时间: 2011-4-7 18:06

我刚试了一下，没问题
换个ip应该就可以了，现在基本上搜索都可以用了

作者: 转身遇见你 时间: 2011-4-7 18:12

更新：
刚才又试了一次，出现“搜索服务器在升级中，请耐心等待。”的字样，看来搜索还是不够稳定，时好时坏，请耐心等待吧

作者: 63220 时间: 2011-4-7 18:53

刚一登陆就看到置顶

已经修复啦

作者: hurui0927 时间: 2011-4-8 08:02

我这里搜索很正常，没有任何问题！换IP试试吧

欢迎光临 SiS001! Board - [第一会所关闭注册] (http://n.sis001.com/bbs/)