查看完整版本: 搜索的时候出现错误:Error: Query execution was interrupted

搜索的时候出现错误: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

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

*** 作者被禁止或删除 内容自动屏蔽 ***

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

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

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

*** 作者被禁止或删除 内容自动屏蔽 ***

*** 作者被禁止或删除 内容自动屏蔽 ***

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

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

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.

*** 作者被禁止或删除 内容自动屏蔽 ***

[quote]原帖由 [i]支枕听河流[/i] 于 2011-4-7 16:32 发表 [url=http://67.220.93.13/bbs/redirect.php?goto=findpost&pid=70063453&ptid=3781850][img]http://67.220.93.13/bbs/images/common/back.gif[/img][/url]
~~可能是吧
我现在又试了一次又好了，可能是有的ip有问题，楼主换个试试吧
论坛可用的ip很多 [/quote]

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

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

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

刚一登陆就看到置顶:excellence 已经修复啦

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