Empty search results

[s s]

Hi

We use following piler version

piler 0.1.25-master-branch, build 857, Janos SUTO <[e-mail]>

Build Date: Mon Jan 13 08:13:44 EST 2014
ldd version: ldd (Debian EGLIBC 2.13-38) 2.13
gcc version: gcc version 4.7.2 (Debian 4.7.2-5) 
Configure command: ./configure --localstatedir=/var --enable-starttls --enable-tcpwrappers --with-database=mysql --enable-memcached

RESTRICTED_AUDITOR=0 MEMCACHED_ENABLED=0

When i just hit search button then i page spin up a while. But i do not see any output. In the bottom i see results count 1-50, total: 10000 (4839838)

Mail log:

Nov  5 14:00:08 piler-webui[10558]: sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHERE        MATCH('') ORDER BY `sent` DESC LIMIT 0,10000 OPTION max_matches=10000' in 3.26 s, 10000 hits, 4839838 total found

It is also interesting that when i sort the same search by size then result is available. Another actions (Data,From,To,Subject) - do not sort the same search window.

Here is what we have in nginx error log

PHP message: PHP Notice:  Undefined index: sort in /var/www/piler/model/search/search.php on line 256"

Please help us to fix the search.

Thanks.

[Janos SUTO]

The logged sphinx query says you have plenty of search results, you just have a problem displaying them. After sorting by size, and seeing the results, try sorting the by date, and check if they disappear again. Also try setting the max results down to 1000, and see if it fixes the issue. And you may try the mobile theme as well with 10000 as the limit.

[s s]

After sorting by size, and seeing the results, try sorting the by date, and check if they disappear again. Tested. It does not appear again

Also try setting the max results down to 1000, and see if it fixes the issue It worked for the 1st search only. After that i see the same issue.

And you may try the mobile theme as well with 10000 as the limit. The same problem. Only sort by size display results.

[Janos SUTO]

Can we arrange a remote session to look around? If so, then find me on skype - I think we have talked in the past, though I'm not 100% sure.

[Janos SUTO]

No news is good news.