Discuz! Database Error (1064) You have an error in your SQL syntax; check the manual that correspo

Question

Discuz! Database Error
(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 'AND c.starttimefrom <86400) GROUP BY a.tid ORDER BY a.tid DESC LIMIT 20,5' at line 1
SELECT a.tid,a.subject,a.author,a.authorid,a.views,b.message,b.pid,c.aid,c.cost,c.starttimefrom,c.starttimeto,c.place,c.class,c.applynumber,c.expiration FROM forum_thread AS a,forum_post AS b,forum_activity AS c WHERE a.tid=c.tid AND a.special=4 AND b.tid=a.tid AND b.position=1 AND ( c.starttimefrom > AND c.starttimefrom <86400) GROUP BY a.tid ORDER BY a.tid DESC LIMIT 20,5

PHP Debug

No. File Line Code
1 plugin.php 47 include(%s)
2 source/plugin/eis_activity/eis_activity.inc.php 17 activity->thread_list()
3 source/plugin/eis_activity/activity.class.php 118 discuz_database::fetch_all(%s, Array, %s)
4 source/class/discuz/discuz_database.php 100 discuz_database::query(%s, Array, false, false)
5 source/class/discuz/discuz_database.php 136 db_driver_mysql->query(%s, false, false)
6 source/class/db/db_driver_mysql.php 151 db_driver_mysql->halt(%s, %d, %s)
7 source/class/db/db_driver_mysql.php 218 break()
怎么解决

Answer 1

提示的是SQL语法错误,请检查这里 AND前面的> 我不知道你的表结构你只能根据你的需求改吧
( c.starttimefrom > AND c.starttimefrom <86400) GROUP BY a.tid ORDER BY a.tid DESC LIMIT 20,5追问

不会！可以加我Q帮我改一下吗？35323533

追答

SELECT a.tid,a.subject,a.author,a.authorid,a.views,b.message,b.pid,c.aid,c.cost,c.starttimefrom,c.starttimeto,c.place,c.class,c.applynumber,c.expiration FROM forum_thread AS a,forum_post AS b,forum_activity AS c WHERE a.tid=c.tid AND a.special=4 AND b.tid=a.tid AND b.position=1 AND ( c.starttimefrom <86400) GROUP BY a.tid ORDER BY a.tid DESC LIMIT 20,5

这样试试.....