Re: Forum search kaput?
- Posted by jimcbrown (admin) Aug 24, 2010
- 1693 views
DanM said...
I tried to search Forum for "ARM", thinking I'd seen earlier posts about them that I could look over, and the search feature turned up nothing at all, even though there's a current topic subject with "ARM" in it, and it's contained in the post itself. Is Search busted?
Dan
I did some tests, and this is either a MySQL bug or a problem with the following SQL query:
mysql> SELECT 'forum', id, created_at, subject FROM messages WHERE MATCH(subject, body) AGAINST("arm" IN BOOLEAN MODE); Empty set (0.00 sec) mysql> SELECT 'forum', id, created_at, subject FROM messages WHERE MATCH(subject, body) AGAINST("kaput" IN BOOLEAN MODE); +-------+--------+---------------------+---------------------+ | forum | id | created_at | subject | +-------+--------+---------------------+---------------------+ | forum | 69267 | 1997-07-07 12:39:53 | New Address | | forum | 112159 | 2010-08-24 05:46:54 | Forum search kaput? | +-------+--------+---------------------+---------------------+ 2 rows in set (0.00 sec)
The results between the search function on the forum and the raw mysql query are identical.
A slightly different query returns plenty of results:
mysql> SELECT 'forum', id, created_at, subject FROM messages WHERE subject like '%ARM%'; +-------+--------+---------------------+---------------------+ | forum | id | created_at | subject | +-------+--------+---------------------+---------------------+ ...snip snip snip... | forum | 32460 | 2005-08-03 00:36:00 | Euphoria for StrongARM Processors | ...snip snip snip... | forum | 103168 | 2008-12-08 12:26:47 | cross compiling for ARM | | forum | 106681 | 2009-06-14 21:20:17 | Euphoria on the ARM processor? | ...snip snip snip... | forum | 110636 | 2010-01-06 20:27:14 | Euphoria on ARM (and other processors) | ...snip snip snip... | forum | 110757 | 2010-01-21 12:00:46 | Re: Euphoria on ARM (and other processors) | | forum | 112140 | 2010-08-21 12:48:22 | Euphoria 4.0b3 on ARM | ...snip snip snip... 113 rows in set (0.41 sec)
Anyways, here are some links I found that might interest you:
http://oe.cowgar.com/forum/110636.wc?last_id=110757
http://oe.cowgar.com/forum/106681.wc?last_id=107054
http://oe.cowgar.com/forum/24382.wc?last_id=24457
