AnsweredAssumed Answered

engine problem of 5.20.0.1

Question asked by cjk_activiti on Dec 24, 2015
Latest reply on Dec 25, 2015 by cjk_activiti
When I use the newest version ,I found this problem ,can any one help?

2015-12-24 15:58:25,304 [main] DEBUG [org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:142)] - ==>  Preparing: select distinct RES.* from ACT_RE_MODEL RES WHERE RES.NAME_ = ? order by order by RES.ID_ asc LIMIT ? OFFSET ?
2015-12-24 15:58:25,525 [main] DEBUG [org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:142)] - ==> Parameters: Demo model(String), 2147483647(Integer), 0(Integer)
2015-12-24 15:58:25,556 [main] DEBUG [org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:171)] - Error while closing command context
### Error querying database.  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 'order by RES.ID_ asc 
    LIMIT 2147483647 OFFSET 0' at line 6
### The error may exist in org/activiti/db/mapping/entity/Model.xml

Outcomes