15 12
该用户匿名发帖 发表于 2011-4-7 15:58   只看TA 1楼
该用户已被删除

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

原来是没有的,最近一段基本上都用不了老出这个,啥原因说?
0
文藝猫青年 发表于 2011-4-7 16:11   只看TA 2楼
呃,刚才我试了下,也是这样的问题,可能搜索功能还有点问题,耐心等待下吧
0
该用户匿名发帖 发表于 2011-4-7 16:16   只看TA 3楼
汗,我还以为就我有这个问题呢
0
lao7391730 发表于 2011-4-7 16:17   只看TA 4楼
我刚试了一下,搜索功能并没有问题。楼主和河流试着换一个论坛IP看看。呵呵。
0
该用户匿名发帖 发表于 2011-4-7 16:32   只看TA 5楼
换了一个,还是这个问题,是啥原因捏
0
文藝猫青年 发表于 2011-4-7 16:32   只看TA 6楼
~~可能是吧
我现在又试了一次又好了,可能是有的ip有问题,楼主换个试试吧
论坛可用的ip很多
0
文藝猫青年 发表于 2011-4-7 16:34   只看TA 7楼
67.220.93.10
我刚才用了上面这个可用,一开始忘了用了哪个了出了问题
0
该用户匿名发帖 发表于 2011-4-7 16:39   只看TA 8楼
搜英文字母的东西就没有问题
但是搜中文就不行了啊
0
该用户匿名发帖 发表于 2011-4-7 16:51   只看TA 9楼
我也刚想发帖关于搜索的,也不行,如下:

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.
0
文藝猫青年 发表于 2011-4-7 16:53   只看TA 10楼
看来还是有点问题啊,再等等吧
0
回复帖子 发新话题
 15 12