lsm8062 发表于 2007-4-6 19:44:48

SQL有问题了吧

老大!刚才我想查看新帖,给我出了一堆提示Discuz! info: MySQL Query Error

User: lsm8062
Time: 2007-4-6 7:42pm
Script: /search.php

SQL: SELECT searchid, dateline,
('120'<>'0' AND uid='134241' AND 1175859734-dateline<120) AS flood,
(searchstring='title||0||\'1\',\'2\',\'3\',\'4\',\'19\',\'42\',\'58\',\'79\',\'85\',\'89\',\'95\',\'94\',\'91\',\'35\',\'81\',\'82\',\'24\',\'83\',\'98\',\'38\',\'9\',\'75\',\'96\',\'5\',\'12\',\'87\',\'41\',\'54\',\'11\',\'77\',\'80\',\'86\',\'97\',\'44\',\'45\'|104000|0|all' AND expiration>'1175859734') AS indexvalid
FROM cdb_searchindex
WHERE ('120'<>'0' AND uid='134241' AND 1175859734-dateline<120) OR (searchstring='title||0||\'1\',\'2\',\'3\',\'4\',\'19\',\'42\',\'58\',\'79\',\'85\',\'89\',\'95\',\'94\',\'91\',\'35\',\'81\',\'82\',\'24\',\'83\',\'98\',\'38\',\'9\',\'75\',\'96\',\'5\',\'12\',\'87\',\'41\',\'54\',\'11\',\'77\',\'80\',\'86\',\'97\',\'44\',\'45\'|104000|0|all' AND expiration>'1175859734')
ORDER BY flood
Error: Got error 127 from table handler
Errno.: 1030

Similar error report has beed dispatched to administrator before.
赶紧让高人给看看是什么问题啊

Brando 发表于 2007-4-7 20:48:14

您是在使用搜索功能的时候发生问题了吧?

今天是否有发生?

如果能重现问题我们感激不尽,谢谢

Brando 发表于 2007-4-7 21:18:49

OK,我们已经找到了问题并解决

感谢您及时的发现问题并通告
页: [1]
查看完整版本: SQL有问题了吧