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?
Not a known problem to me.
What search method are you using? (admin->forum->search->search method) and what options have you enabled there?
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.
@b4pjoe : can you test this sql query via phpMyAdmin please?
CREATE TEMPORARY TABLE tmp (test INT(4));
IIRC many search issues are related to the mysql permission "create temporary tables".
I remember that. Lightyears before ElkArte. ;D
I ran the query. Attached image is the result in phpMyAdmin. Tried the search again and still get the "No results found" message.
Can you give an example of a word you are trying to search?
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.
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.
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.
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
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.
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
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.
@b4pjoe can you try admin > maintenance > routine > "find and repair any error"?
It may simply be that the log_search_subjects table has not been populated during the conversion...
Emanuele...that seems to have fixed it. It showed a lot of errors and I clicked it to fix them and the search now finds those topics when I search as an admin or as a member of that group. Thank you!
You are welcome! :D
It may be worth adding the check to a scheduled task...
Was it an imported board? Maybe we should add that task to the importer..
That was another option I thought, the nuisance with adding it to the importer is code duplication, unless we start to rely on the destination forum for some functions (if it is possible).
Yes, all of my boards were imported over from SMF and I haven't created any new ones since then.
Thanks for this. I was just starting to debug my imported test forum's completely broken search function. This is now part of my SOP when upgrading.
Yup.
I wonder if the importer/upgrader should try itself to do a "find and repair errors" just before starting the process.
A message/link in the final confirmation would be a simple step. In the generic sense, each target platform might require different "post import" steps that could be referenced in the confirmation.
I think a link recommending that it be done and ask if you would like to do it now. Then, at the end, do another check and list out any issues that come up.