Hello Janos,

Am Donnerstag, den 21.03.2013, 22:44 +0100 schrieb Janos SUTO:
> On 2013-03-21 22:12, Frank Ellebrecht wrote:
> >> 
> >> I can't reproduce it on the demo site. When I click on the search
> >> button,
> >> it returns every kind of actions. Is it from the latest build?
> 
> almost
> 
> > Well, I can't reproduce it either. On the demo site
> > (<http://demo.mailpiler.org>) there is no audit log for the 
> > admin@local
> > user. I tried <http://piler.aaa.fu.acts.hu> and there it seems to work
> > (but it looks quite different, so I'm not really sure).
> 
> this is the latest build, even though I use the future gui, another 
> user
> is developing. When he's ready, then it will be the default.
> 
Well, on the demo site it seems to work as it should. 

But I installed the latest version from Bitbucket (last commit 0d59e95)
and the problem still persists with my installation. 


> > In the meantime I noticed that the search result depends on the 
> > language
> > settings. If you have chosen another language then English (or your
> > browser default points to a non-English language) then both ways will
> > return the same result. If you have chosen English, then the results
> > will be different like I said.
> 
> can you show me an example?
> 
I may provide screenshots, would they help?

> > I use build 776 from March, 19th (on Bitbucket it's f530f84). As most 
> > of
> > the later changes are done to make me happy, I can't imagine that they
> > changed the search. But I will start to try with the latest version in 
> > a
> > minute.
> 
> the search results depend on exclusively on the query. The query 
> depends on
> what you enter in the search box, the language settings shouldn't 
> affect it.

When I look at the search queries in syslog, there is a difference:

- With English set as language

1. Click Search button only:

Mar 22 11:23:08 asgaard piler-webui[4669]: audit query: 'SELECT COUNT(*)
AS count FROM audit  WHERE action=?' in 0.01 s, 348 hits
Mar 22 11:23:08 asgaard piler-webui[4669]: audit query: 'SELECT * FROM
audit  WHERE action=? ORDER BY `ts` DESC LIMIT 0,50', param: '10' in
0.02 s, 50 hits

2. Click in search terms first and then the Search button:

Mar 22 11:23:59 asgaard piler-webui[4669]: audit query: 'SELECT * FROM
audit  ORDER BY `ts` DESC LIMIT 0,50', param: '' in 0.01 s, 50 hits

- With German 

1. Search button only

Mar 22 11:25:08 asgaard piler-webui[4669]: audit query: 'SELECT * FROM
audit  ORDER BY `ts` DESC LIMIT 0,50', param: '' in 0.01 s, 50 hits

2. Empty search term + Search button

Mar 22 11:25:35 asgaard piler-webui[4669]: audit query: 'SELECT * FROM
audit  ORDER BY `ts` DESC LIMIT 0,50', param: '' in 0.00 s, 50 hits


You'll see that there is an additional condition in the query »WHERE
action=?« if the language is set to English and only the search button
is clicked. Does that help? 

Frank


Reply via email to