Skip to main content ↑ ↓
Topic: Search not working (Read 6304 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

Search not working

If I try to do a search at my forum and tell it to "Search in topic subjects only" as shown in the attached image I never get any results returned. It always just says "No results found" even if I know what I am searching for is in the topic subject. Is this a known issue or only happening on my forum?

Re: Search not working

Reply #1 –

Not a known problem to me.  

What search method are you using? (admin->forum->search->search method) and what options have you enabled there?

Re: Search not working

Reply #2 –

Here is a screenshot of my settings.

I did try the search here at this forum and it seems to work OK. But not in mine.

Re: Search not working

Reply #3 –

@b4pjoe : can you test this sql query via phpMyAdmin please?

Code: [Select]
CREATE TEMPORARY TABLE tmp (test INT(4));
IIRC many search issues are related to the mysql permission "create temporary tables".
Thorsten "TE" Eurich
------------------------

Re: Search not working

Reply #4 –

I remember that. Lightyears before ElkArte. ;D

Re: Search not working

Reply #5 –

Quote from: TE – @b4pjoe : can you test this sql query via phpMyAdmin please?

Code: [Select]
CREATE TEMPORARY TABLE tmp (test INT(4));
IIRC many search issues are related to the mysql permission "create temporary tables".

I ran the query. Attached image is the result in phpMyAdmin. Tried the search again and still get the "No results found" message.

Re: Search not working

Reply #6 –

Can you give an example of a word you are trying to search?
Bugs creator.
Features destroyer.
Template killer.

Re: Search not working

Reply #7 –

weather

And yes there is a topic with "weather" in the title.

Just testing a little further...

I have boards that are visible to guests, boards that are only visible to registered users, and other boards that are only available to users that are in a group called "Social Members". It appears the search is only failing if the topic is in one of the boards that are only available to the members of the "Social Members" group. So I assume this may have to do with board permissions. Haven't had a chance to investigate any further. I know in SMF it was working across all groups.

Re: Search not working

Reply #8 –

After some more testing...if I search for a term that is the title of a topic that is accessible to guests the search works but if it is a topic that guests can't see the search fails.

Re: Search not working

Reply #9 –

Looking through permissions I'm not finding anything that will fix this. Can someone tell me if the search here at this forum will search topic subjects that are not visible to guests and actually find them. I can search on the exact name of a topic and if it isn't visible to guests it will not find it.

Re: Search not working

Reply #10 –

Quote from: b4pjoe – After some more testing...if I search for a term that is the title of a topic that is accessible to guests the search works but if it is a topic that guests can't see the search fails.
Same for me
sorry for my bad english

Re: Search not working

Reply #11 –

I did some quick testing for a word that I know is only on a board that guests can't see but I can.

Searched under my id, word was found
Searched under a standard id, word was not found
Searched as a guest and it was not found

So that seems correct, one note is that the word was also in the body of the text, but I only searched on subject.  Is the word you are searching for solely in the subject?  Is it just that word or are there multiple examples of the behavior (just want to rule out that some special character did not get stuck in the word)

ETA: while typing I see a "me too" response, so not sure maybe @emanuele has some ideas of how to debug this

Re: Search not working

Reply #12 –

Sorry, works at my 1.0.1.

I made two boards visible only for members, not guests. In one of this boards exists a topic named "Zukunftsgestaltung".

1. If I search as a guest, I can't find this topic. As it should be.

2. If I search as a member who has access to this board (and the topic within) the search finds this topic.

See the attachments.

Re: Search not working

Reply #13 –

I tried on my smf forum  and it was not working... my mistake, there was a typo error in my search  O:-)

here is a screenshot. sorry again
Last Edit: December 05, 2014, 12:36:26 pm by radu81
sorry for my bad english

Re: Search not working

Reply #14 –

I think I can confirm it on my forum as well with at least 1 word: "Regolamento".

Sorry, something happened, I have to repeat the tests.

It's an import from 1.1.
The word appears in the body of about 58 messages and in the subject of at least three, two in open boards, one in a moderators-only board. Additionally, one of these three topics has the word in the body too, while the other two not.

In a "normal" search (i.e. "subject only" option NOT set) the search returns 58 messages: all those that have the word in the body, the two where the word appears only in the subject are not found.
If I search only in the subject the topics are not returned.
Even restricting the search only to the board, no results are returned.

I tried with no index, fulltext index, custom index and with enabled or disabled "match whole words only".
In order to exclude some placement effect I posted three additional topics with subjects: "regolamento test", "test regolamento", "test regolamento test".
Not a single result.

Spuds, if you have any suggestion on how to debug it, let me know. In the meantime I'll try to log the queries run.
Last Edit: December 05, 2014, 02:38:55 pm by emanuele
Bugs creator.
Features destroyer.
Template killer.