Mybits SQL语句报错

[wangsufu77]

SQL：

<select id="getCount" resultType="int" parameterType="map">
select count(*) from tb_item where 1=1 LIMIT #{start} , #{pageSize}
</select>

报错
The error occurred while setting parameters
### SQL: select count(*) from tb_item LIMIT ? , ?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'null , null' at line 1
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'null , null' at line 1] with root cause

[wangsufu77]

count 语句不要limit，我擦

[wzwdev1980]

在数据库中执行调试出来的语句，然后根据问题进行对应修改