I'm running AwareIM 2.2 on Linux using MySQL 5.0.24a.
Everytime I try to search/filter for values containing special characters like äöü (which are quite common in german) AwareIM drops an error.
When doing this via Standard/Search Object/All Objects [BO-Name] / Reduce-Extend Search then I see a Internal System Error and the output from Tomcat is
When doing this via a query with "[x] Use Form" then I get a A query with this name does not exist.Filter query is null|null|False|FIND Kunde WHERE Kunde.Firma CONTAINS 'jörg'|10,PLZ^n^y^n^y,KdNr^n^y^n^y,Firma^n^y^n^y,Bemerkung^n^y^n^y,Ort^n^y^n^y,KHKID^n^y^n^y,Land^n^y^n^y,Anschrift^n^y^n^y,MatchCode^n^y^n^y,FirmaZusatz^n^y^n^y,-1,null,1,Edit~null~null~5~false~1~null~null~true~true,null,null,y,y,y|null|null
Redirecting to /runQuery.do?actionMethod=redisplayForm&rangeFormInfo=1%4020%40null%7Cnull%7CFalse%7CFIND+Kunde+WHERE+Kunde.Firma+CONTAINS+%27j%C3%B6rg%27%7C10%2CPLZ%5En%5Ey%5En%5Ey%2CKdNr%5En%5Ey%5En%5Ey%2CFirma%5En%5Ey%5En%5Ey%2CBemerkung%5En%5Ey%5En%5Ey%2COrt%5En%5Ey%5En%5Ey%2CKHKID%5En%5Ey%5En%5Ey%2CLand%5En%5Ey%5En%5Ey%2CAnschrift%5En%5Ey%5En%5Ey%2CMatchCode%5En%5Ey%5En%5Ey%2CFirmaZusatz%5En%5Ey%5En%5Ey%2C-1%2Cnull%2C1%2CEdit%7Enull%7Enull%7E5%7Efalse%7E1%7Enull%7Enull%7Etrue%7Etrue%2Cnull%2Cnull%2Cy%2Cy%2Cy%7Cnull%7Cnull%402%40True%40False%40False%40null%40null%403014%40null%400%400&actionCallStack=&processFrame=-1[__null__[__null__[0
ActionErrorException thrown with error key error.assertion
In this case Tomcat says:
Please help ! This error is here since AwareIM 2.0 and *very* annoying when searching inside 15000 records.Query is null|null|False|FIND Kunde WHERE Kunde.MatchCode CONTAINS 'jörg' ORDER BY Kunde.MatchCode|6,MatchCode^n^y^n^y,Firma^n^y^n^y,FirmaZusatz^n^y^n^y,Anschrift^n^y^n^y,PLZ^n^y^n^y,Ort^n^y^n^y,20,null,2,Edit~null~Main~5~false~1~null~null~true~true,Neue Bestellung~NeueBestellung~Kunde~0~false~1~null~null~true~true,null,null,y,y,y|null|null
ActionErrorException thrown with error key error.noquery
Hubertus