[已回答] 無法使用查看新帖功能

pergibo1973

Discuz! info: MySQL Query Error

User: 五甲小舜
Time: 2010-11-1 8:21pm
Script: /search.php

SQL: SELECT searchid, dateline,
(''<>'0' AND uid='35' AND 1288614085-dateline<) AS flood,
(searchstring='title||0||\'2\',\'3\',\'4\',\'22\',\'21\',\'42\',\'43\',\'44\',\'25\',\'10\',\'11\',\'19\',\'30\',\'31\',\'29\',\'32\',\'34\'|22000|0|all|' AND expiration>'1288614085') AS indexvalid
FROM [Table]searchindex
WHERE (''<>'0' AND uid='35' AND 1288614085-dateline<) OR (searchstring='title||0||\'2\',\'3\',\'4\',\'22\',\'21\',\'42\',\'43\',\'44\',\'25\',\'10\',\'11\',\'19\',\'30\',\'31\',\'29\',\'32\',\'34\'|22000|0|all|' AND expiration>'1288614085')
ORDER BY flood
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS flood,
(searchstring='title||0||\'2\',\'3\',\'4\',\'22\',\'21\',\'42\',' at line 2
Errno.: 1064

到 http://faq.comsenz.com 搜索此錯誤的解決方案
----------------------------------------------------------------------------------------------------------------

一按下 查看新帖的功能鍵～～就會跳到這個頁面～～無法使用該功能～～
麻煩請管理員幫忙
網址： http://pergibo1973.sclub.tw/index.php

------------------------------------------------------------------------------------------------------------------
補充一下~~所有的搜尋功能都出現同樣的情況~~
1.我的資料中的搜索帖子
2.查看新帖
3.論壇的搜索功能
以上均出現同樣問題.............謝謝

pergibo1973

非常感謝管理員大人
功能已經可以正常使用了~~~
再次感謝

admin

Discuz! info: MySQL Query Error

User: 五甲小舜
Time: 2010-11-1 8:21pm
Script: /search.php

SQL: SELECT searchid, dateline,
('''0' AND uid='35' AND 1288614085-dateline'1288614085') AS indexvalid
FROM  ...
pergibo1973 發表於 2010-11-1 20:23

你好!!
已處理好了!!
謝謝你對sCLUB的支持

andyzung

看樣子這問題似乎非常棘手耶!!
真是辛苦管理員大人了