topic Re: Query Bug?MySQLSyntaxErrorException in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/query-bug-mysqlsyntaxerrorexception/m-p/90360#M61526 <HTML><HEAD></HEAD><BODY><SPAN>The additional ' is added in the mysql stack trace message. You can't actually do 'LIKE %%', because that just matches everything… You should have at least ONE non-wildcard character in the parameter…</SPAN></BODY></HTML> Wed, 20 Jun 2012 07:24:57 GMT frederikherema1 2012-06-20T07:24:57Z Query Bug?MySQLSyntaxErrorException https://connect.hyland.com/t5/alfresco-archive/query-bug-mysqlsyntaxerrorexception/m-p/90359#M61525 Hi,allWhen I inovk this methodrepositoryService.createProcessDefinitionQuery().processDefinitionNameLike("%%");then it throw a MySQLSyntaxErrorExceptionorg.apache.ibatis.exceptions.PersistenceException: ### Error querying database.&nbsp; Cause: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You hav Tue, 19 Jun 2012 01:26:00 GMT https://connect.hyland.com/t5/alfresco-archive/query-bug-mysqlsyntaxerrorexception/m-p/90359#M61525 croc1 2012-06-19T01:26:00Z Re: Query Bug?MySQLSyntaxErrorException https://connect.hyland.com/t5/alfresco-archive/query-bug-mysqlsyntaxerrorexception/m-p/90360#M61526 <HTML><HEAD></HEAD><BODY><SPAN>The additional ' is added in the mysql stack trace message. You can't actually do 'LIKE %%', because that just matches everything… You should have at least ONE non-wildcard character in the parameter…</SPAN></BODY></HTML> Wed, 20 Jun 2012 07:24:57 GMT https://connect.hyland.com/t5/alfresco-archive/query-bug-mysqlsyntaxerrorexception/m-p/90360#M61526 frederikherema1 2012-06-20T07:24:57Z