|
错误信息:
(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 '-1' at line 1SELECT * FROM forum_filter_post WHERE tid=3684 ORDER BY postlength DESC LIMIT -1
解决办法:
打开 \source\class\table\table_forum_filter_post.php
找到- public function fetch_all_by_tid_postlength_limit($tid, $limit = 10) {
- return DB::fetch_all('SELECT * FROM %t WHERE tid=%d ORDER BY postlength DESC LIMIT %d', array($this->_table, $tid, $limit), 'pid');
- }
复制代码 修改成- public function fetch_all_by_tid_postlength_limit($tid, $limit = 10) {
- (float)$limit <= 0 && $limit = 10; //或者增加这一行
- return DB::fetch_all('SELECT * FROM %t WHERE tid=%d ORDER BY postlength DESC LIMIT %d', array($this->_table, $tid, $limit), 'pid');
- }
复制代码
|
|