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

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

文藝猫青年

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

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

lao7391730

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

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

文藝猫青年

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

文藝猫青年

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

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

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

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.

文藝猫青年

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