forum_filter_post 表出现错误

nkc3g4

错误信息：
[color=rgb(0, 0, 0)][backcolor=rgb(243, 243, 243)][size=11pt](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 1[backcolor=rgb(255, 255, 204)][size=9pt]SELECT * FROM forum_filter_post WHERE tid=3684 ORDER BY postlength DESC LIMIT -1[/size][/backcolor]
[/size][/backcolor][/color]
[color=rgb(0, 0, 0)][backcolor=rgb(243, 243, 243)][size=11pt] [/size][/backcolor][/color]

[color=rgb(0, 0, 0)][backcolor=rgb(243, 243, 243)][size=11pt][backcolor=rgb(255, 255, 255)]解决办法：[/backcolor][/size][/backcolor][/color]

打开 \source\class\table\table_forum_filter_post.php
[color=rgb(0, 0, 0)][backcolor=rgb(243, 243, 243)][size=11pt][backcolor=rgb(255, 255, 255)]找到[/backcolor][/size][/backcolor][/color]

1. 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');
   }

[color=rgb(0, 0, 0)][backcolor=rgb(243, 243, 243)][size=11pt][backcolor=rgb(255, 255, 255)]修改成[/backcolor][/size][/backcolor][/color]

1. 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');
   }

[color=rgb(0, 0, 0)][backcolor=rgb(243, 243, 243)][size=11pt][backcolor=rgb(255, 255, 255)]
[/backcolor]



[/size][/backcolor][/color]