[Type] 查询语句错误
[1064] 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 'DESC LIMIT 0, 10' at line 1
[Query] SELECt t.*, f.name FROM forum_thread t, forum_forum f WHERe f.status<>'3' AND f.fid=t.fid AND t.displayorder not IN(-1,-2) AND t.replies!=0 AND t.dateline>0 ORDER BY t. DESC LIMIT 0, 10
Discuz! Database Error The database has encountered a problem. Need Help?Error messages: [Type] 查询语句错误
[1064] 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 'DESC LIMIT 0, 10' at line 1
[Query] SELECt t.*, f.name FROM forum_thread t, forum_forum f WHERe f.status<>'3' AND f.fid=t.fid AND t.displayorder not IN(-1,-2) AND t.replies!=0 AND t.dateline>0 ORDER BY t. DESC LIMIT 0, 10 Program messages: [Line: 0055]forum.php(runhooks)
[Line: 1188]source\function\function_core.php(hookscript)
[Line: 1230]source\function\function_core.php(plugin_thread_list_forum->index_top)
[Line: 0109]source\plugin\thread_list\thread_list.class.php(thread_list_query)
[Line: 0019]source\plugin\thread_list\thread_list.func.php(DB::query)
我QQ420398323 ,谢谢
MYsQL数据库问题,请各位老大帮忙
答案:1 悬赏:40
解决时间 2021-03-20 17:14
- 提问者网友:唤魂
- 2021-03-20 13:30
最佳答案
- 二级知识专家网友:白日梦制造商
- 2021-03-20 15:05
SELECt t.*, f.name FROM forum_thread t, forum_forum f WHERe f.status<>'3' AND f.fid=t.fid AND t.displayorder not IN(-1,-2) AND t.replies!=0 AND t.dateline>0 ORDER BY t. DESC LIMIT 0, 10
你这个有语法错了
order by 后面没字段了!!!
你这个有语法错了
order by 后面没字段了!!!
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯