Searching for threads

[GoogleCodeExporter]

I am using r114 right now and if you change the search from "Posts" to 
"Threads" it will always error with "I can't figure your search query out! Try 
reading the search FAQ. Report a new bug or send an email if you think your 
query should have worked.".

Original issue reported on code.google.com by ajjr1...@yahoo.com on 18 Feb 2012 at 9:47

[GoogleCodeExporter]

Sorry.. r118

Original comment by ajjr1...@yahoo.com on 18 Feb 2012 at 9:49

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Did you reindex Sphinx? Considering I can search by date, I'm assuming you did.

Did you perhaps forget to add the tnum field to your Sphinx configuration?

Also, edit line 170 in Sphinx_Mysql.pm and add:
,$self->_log_bad_query($query)

before the return. Then try to run a thread search, look at that file and paste 
the corresponding query that errored out.

(You might need to touch bad_queries.txt && chmod 666 bad_queries.txt for the 
webserver to be able to write to it)

Original comment by eksopl on 18 Feb 2012 at 10:45

[GoogleCodeExporter]

I used the most up-to-date version of the example config.

This is the output from bad_queries.txt

Bad query: select tnum from g_ancient, g_main, g_delta
                        where match('@comment \"help\" ')  group by tnum order by timestamp desc limit 0, 24 option max_matches=5000;

Original comment by aa...@installgentoo.net on 18 Feb 2012 at 11:11

[GoogleCodeExporter]

Well, crap, I think I may have made a mistake. Looking.

Original comment by eksopl on 18 Feb 2012 at 11:34

• Changed state: Accepted

[GoogleCodeExporter]

Nope, it works fine for me, with the stock sphinx.conf. Can you connect 
directly to Sphinx and do this?

$ mysql -h 127.0.0.1 -P 9306
mysql> describe g_ancient;
mysql> describe g_main;
mysql> describe g_delta;

They should all return this:
+-------------+-----------+
| Field       | Type      |
+-------------+-----------+
| id          | integer   |
| name        | field     |
| trip        | field     |
| email       | field     |
| media       | field     |
| title       | field     |
| comment     | field     |
| num         | uint      |
| subnum      | uint      |
| tnum        | uint      |
| cap         | uint      |
| has_image   | bool      |
| is_internal | bool      |
| is_spoiler  | bool      |
| is_deleted  | bool      |
| is_sticky   | bool      |
| is_op       | bool      |
| timestamp   | timestamp |
+-------------+-----------+
18 rows in set (0.00 sec)

Run that query on the command line too, and post the results, please.
mysql> select tnum from a_ancient, a_main, a_delta where match('@comment 
\"help\" ') group by tnum order by timestamp desc limit 0, 24 option 
max_matches=5000;
(I used /a/ because I don't have /g/ indexed, but it's obviously the same 
thing.)

Also, what's your version of Sphinx?

Original comment by eksopl on 18 Feb 2012 at 11:39

[GoogleCodeExporter]

My fault! Its fixed, I apparently didn't reindex all of the boards :/

Original comment by aa...@installgentoo.net on 19 Feb 2012 at 12:22

[GoogleCodeExporter]

Another happy customer! o/

Original comment by eksopl on 19 Feb 2012 at 1:31

• Changed state: Invalid