Running SMF 1.1.1 with the default theme and no mods.
We had a lot of complaints about search over the last couple months. Basically you can put in an exact keyword that you know should have several results (with or without quotes) and you get a lot of irrelevant results that do not have that keyword in them, intermixed with the correct ones (highlighted yellow).
So I have tried all combinations of weighting, index tables (fulltext & all 3 custom), and other various admin search option check boxes, thinking something would work. Nothing worked.
I decided to do some forum maintenace, and although I am not 100% which step it is, I am pretty sure that "Optimize all tables..." fixes the search to work pretty much perfectly. The problem is, in only holds for maybe a couple hours I think.
I will repost here more as I narrow it down, but just wondered if anyone else had such issues, or if there is some possible root cause for this that I can start looking at? Or is this just the nature of the beast? We have 21073 Posts in 1412 Topics by 1017 Members. We have been up for about a year.
Thanks
Chris
Just an update:
Once the search starts returning irrelevant results, I invoke "Empty out unimportant logs" and attempt another search. At this point search returns nothing for the keyword. Then I invoke "Optimize all tables to improve performance." Now I attempt another exact search, and it is perfect - only relevant search results are returned.
A couple of hours later, the search starts malfunctioning again!
Arrrrrgggghhhh!
Is there anything in your error log?
Quote from: jerm on January 26, 2007, 01:08:49 AM
Is there anything in your error log?
Well, not right now, it is empty. I guess that is maybe because I selected "Empty out unimportant logs"? Not sure if that is considered important or not...
I will watch it for the next bit and when the search starts failing I will check the log.
OK, still no errors in my log, however I have a more narrowed steps to reproduce.
Once the search starts returning irrelevant results, I invoke "Empty out unimportant logs" and attempt another search. At this point search returns nothing for the keyword.
Now I just search for some other keyword and the results are correct. Then I search again for the first keyword and the results are also correct.
So I DO NOT need to perform the "Optimize..." step. It is somehow related to emptying out the unimportant log.
Still it seems a couple hours later it goes back to incorrect behavior...
Regarding the log - it looks like one user had lost connection to the database for load.php, and it seems that it might correlate to when the search function breaks.
Of course "Empty out unimportant logs" fixes it every time, but only for a short period of time (usually hours).
Does anyone have any help!!!???
Thanks
Hi,
I am going through the old unsolved support topics. Did you get this resolved? If not then please let us know what you have tried since. Are you upgraded to the latest version? What are your current search settings?
I upgraded to 1.1.2, re-ran all the maintenance, still same issue.
"Empty out important logs" fixes it every time - but only for a short time.
So I gave up completely - search is just broken somehow.
What are the settings for search? (Added in the newer versions.) Did you build a database and force it to use that?
I have tried "No Index", "Full Index", and "Custom Index".
I have tried "Force the use of a search Index" both on and off in conjunction with the above latter 2.
I have tried "Match Whole words only" both on and off.
I have tried Simple and Advanced search.
I have tried dozens of weighting combinations.
- All with the same result.
I have seen a few other posts with what appears to be the same issue. Not a whole lot but, well, a few. It may be time to call in a developer? Do you have a phpinfo.php file available should it be requested?
Not sure where that file would live, but...
This SMF site is on a hosted account, and currently only have FTP/SSH access to the files - nothing on the database or domain admin side of things (although I may be able to get this access).
I hope that is clear enough.
http://docs.simplemachines.org/index.php?topic=479.msg688#msg688
That should help you outon the phpinfo.php thing
Quote from: KGIII on April 08, 2007, 02:37:02 PM
I have seen a few other posts with what appears to be the same issue. Not a whole lot but, well, a few. It may be time to call in a developer? Do you have a phpinfo.php file available should it be requested?
OK - got phpinfo figured out.
sumocomputers,
Sorry for the delayed response.
Do you know if your mysql user for SMF has the ability to create temp tables? I seen this issue occur with this as the tables are not being deleted once smf is done using the temp tables.
I too have experienced the Search results to be quite poor. And like some of you here, performing the Empty Out Unimportant Logs does improve the performance of the search results.
Has anyone seen or found a real solution to this problem. I continue to daily use the Empty Out Unimportant Logs function, which temporarily solves the problem, but this not a realistic solution.
Just a simple "we are working on a solution" or "it won't be fixed until the next update" would suffice. :)
Can't work on a solution unless we know what the cause of the problem is first. Only one of the dev's knows the search functionality extensively.
I can say that search is being reviewed and looked at. There has been no determination of anything to my knowledge yet.
Was your board a conversion?
PHP version?
MySQL version?
Quote from: metallica48423 on June 07, 2007, 10:52:58 PM
Was your board a conversion?
PHP version?
MySQL version?
My board was a conversion ... some time ago, maybe two years ago. Originally YaBB, then SuperMod, then SMF.
MySQL: 4.1
PHP: 5.0
I created a Custom Index for the search method; the table is about 240Mb.
Any further information on this?
I still experience this issue with my forum. Clearing the logs does wonders for the search function. The question is why and how do we fix this.
Let us know if you need more information as to what we are experiencing if it will help isolate and resolve this problem.
I will post this up for Someone more knowledgeable to look at. Please allow some time for my request to be noticed.
Please provide as much information about your system.
You've provided mysql and php versions, thanks. can you provide a link to your phpinfo.php? Mods installed (list them all). Do you experience the problem without the mods?
Anyone who offers will need to know everything they can about the situation, so i ask, please let us know everything you can save from the passwords until they're requested in private
Thanks
This occurs with the default template, wrapped in Joomla with the SMF Bridge, no mods.
I have used some SEO on the site, but SEF is turned OFF in SMF.
I have a large membership and 5 years worth of posts, so the smf_messages table is over 100Mb, pushing 200Mb.
Also have the custom search index created in SMF; size of the table is 242082.76 KB.
Personally,I don't think it's wise/safe for me to post a link to phpinfo.php.
and does it happen with the bridge disabled and when accessing just the forum itself?
Quote from: metallica48423 on July 20, 2007, 06:11:48 PM
and does it happen with the bridge disabled and when accessing just the forum itself?
I'll give this a test later this week, like on Friday. I don't want to go testing this on my live site ... my members wouldn't appreciate that too much. My server is being physically moved on Friday, so I'll give it a few tests before the move and report back.
hello!
i have exact the same error on my server.
i have 3 different smf-boards installed.
number one has no bridge
number two and three have http://gallerybridge.oldiesmann.us installed
all thre are running version 1.1.3 of smf.
here is the link of unbridged forum
http://www.go-vista.de/forum/index.php
here the phpinfo of my server http://www.go-vista.de/forum/status.php?php
and http://www.go-vista.de/forum/status.php
EDIT: i noticed the following.
i clean all unneccasery logs
so the table log_search_topics, logs_search_resulsts and log_search_messages are truncated.
Now i search in my forum after "shutdownpro" = 1 Result (all works fine)
search after "nvidia" = 8 pages of results (all works fine)
search again after "shutdownpro" = 4 pages of results
-> the correct entry is on position 41 of 50 (on page 1) results per page
Are you safe mode on ?
Quote from: Eleglin on August 15, 2007, 08:21:37 AM
Are you safe mode on ?
Nope he doesn't have safe mode on
Quotesafe_mode Off Off
@fca07, Eleglin:
Solution
http://www.simplemachines.org/community/index.php?topic=189110.0
I believe this will fix your problems.
- anderson
Thanks for the info wordzilla. I'll file an official bug report on it :)
Thanks Oldiesmann, I appreciate it. :)
Bumping this to give people a chance to see it.