请教是什么错?(1064) You have an error in your SQL syntax

UUNIN 发布于 2014/07/26 17:11
阅读 8K+
收藏 0

我以为表名错了,但改了表名还是有错,SQL语句也没查出哪错了。

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 '' at line 1
SELECT * FROM tuan_goods WHERE goods_status = '1' AND goods_show='1' AND goods_begin_time < 1406365462 AND goods_end_time > '1406365462' ORDER BY goods_hot DESC,goods_order DESC, goods_hot DESC LIMIT 0,

PHP Debug

No. File Line Code
1 tuan.php 10 require(%s)
2 plugin.php 47 include(%s)
3 source/plugin/tuan/tuan.inc.php 55 require_once(%s)
4 source/plugin/tuan/module/index.inc.php 60 fetch_all()
5 source/plugin/tuan/include/function.class.php 81 discuz_database::query(%s)
6 source/class/discuz/discuz_database.php 136 db_driver_mysql->query(%s, false, false)
7 source/class/db/db_driver_mysql.php 153 db_driver_mysql->halt(%s, %d, %s)
8 source/class/db/db_driver_mysql.php 224 break()

加载中
0
leo108
leo108
SELECT * FROM tuan_goods WHERE goods_status = '1' AND goods_show='1' AND goods_begin_time < 1406365462 AND goods_end_time > '1406365462' ORDER BY goods_hot DESC,goods_order DESC, goods_hot DESC LIMIT 0,<----这里的数字呢
0
UUNIN
UUNIN

引用来自“leo108”的评论

SELECT * FROM tuan_goods WHERE goods_status = '1' AND goods_show='1' AND goods_begin_time < 1406365462 AND goods_end_time > '1406365462' ORDER BY goods_hot DESC,goods_order DESC, goods_hot DESC LIMIT 0,<----这里的数字呢
啊?要不大神帮看下文件?真的没看懂。
返回顶部
顶部