GUI not showing any message.

[Guilherme Oliveira]

Hello,

I can see the messages come to Piler, but GUI not showing any message to me in a search field with user "auditor".

Anyone could help me?

PS: If I edit the file /var/www/piler/model/search/search.php puting the string "sent" on SELECT I can see 50 messages but appear a string "sphinx" on my GUI and I can´t see more then 50 messages :(

piler-1.2.0

Thanks.

[eXtremeSHOK]

Check your permissions and sphinx logs.

Ensure you have the latest versions

[Guilherme Oliveira]

Hello,

Thanks for the help, but I can´t see anything on /var/log/sphinxsearch, but in my syslog I can see this:

Nov 9 17:00:36 piler piler-webui[1113]: sphinx query: 'SELECT id,sent FROM main1,dailydelta1,delta1 WHERE MATCH('') ORDER BY sent DESC LIMIT 0,50 OPTION max_matches=1000' in 0.00 s, 50 hits, 0 total found Nov 9 17:23:02 piler piler-webui[1113]: sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH('') ORDER BY sent DESC LIMIT 0,50 OPTION max_matches=1000' in 0.00 s, 0 hits, 0 total found

I believe this is something on search.php, because like I said if I change puting "sent" on SELECT I can see 50 messages and appear a string "sphinx" in my GUI, I´ll attach a file.

Thanks.

[Guilherme Oliveira]

Puting Sent on search.php

[Guilherme Oliveira]

Sphnix String on GUI

[Guilherme Oliveira]

My sphinx version:

dpkg -la |grep sphinx ii sphinxsearch 2.0.4-1.1ubuntu2 amd64 Fast standalone full-text SQL search engine

[Janos SUTO]

The installation docs clearly says: you need sphinx 2.2.x, and yet you managed to install 2.0.x.

[Guilherme Oliveira]

Hello,

Sorry for my mistake, I´ll try with sphinx 2.2.x.

thanks.