topic Re: Error happend when I try to get tasks!Please help me. in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194488#M147618 <HTML><HEAD></HEAD><BODY><SPAN>I found that "### SQL: select distinct RES.* from ACT_RU_TASK RES WHERE RES.ASSIGNEE_ = ? order by order by RES.ID_ asc LIMIT ? OFFSET ?".</SPAN><BR /><BR /><SPAN>Why there are two "order by"?</SPAN></BODY></HTML> Wed, 29 Jul 2015 07:20:53 GMT looyli 2015-07-29T07:20:53Z Error happend when I try to get tasks!Please help me. https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194486#M147616 Error message<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.apache.ibatis.exceptions.PersistenceException: ### Error querying database.&nbsp; 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 'orde Wed, 29 Jul 2015 07:11:04 GMT https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194486#M147616 looyli 2015-07-29T07:11:04Z Re: Error happend when I try to get tasks!Please help me. https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194487#M147617 <HTML><HEAD></HEAD><BODY><SPAN>below is the code:</SPAN><BR /><BR /><SPAN>taskService.createTaskQuery().taskAssignee(userid).list()</SPAN></BODY></HTML> Wed, 29 Jul 2015 07:12:34 GMT https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194487#M147617 looyli 2015-07-29T07:12:34Z Re: Error happend when I try to get tasks!Please help me. https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194488#M147618 <HTML><HEAD></HEAD><BODY><SPAN>I found that "### SQL: select distinct RES.* from ACT_RU_TASK RES WHERE RES.ASSIGNEE_ = ? order by order by RES.ID_ asc LIMIT ? OFFSET ?".</SPAN><BR /><BR /><SPAN>Why there are two "order by"?</SPAN></BODY></HTML> Wed, 29 Jul 2015 07:20:53 GMT https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194488#M147618 looyli 2015-07-29T07:20:53Z Re: Error happend when I try to get tasks!Please help me. https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194489#M147619 <HTML><HEAD></HEAD><BODY><SPAN>I have resolved the problem. The version of mybatis is wrong. I downgraded the version to 3.2.5 and it works.</SPAN></BODY></HTML> Wed, 29 Jul 2015 08:00:22 GMT https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194489#M147619 looyli 2015-07-29T08:00:22Z