Search only works after "Clear Logs"

[drumsage]

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.

[metallica48423]

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

[drumsage]

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.

[metallica48423]

and does it happen with the bridge disabled and when accessing just the forum itself?

[drumsage]

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.

[mkress]

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

[Eleglin]

Are you safe mode on ?

[ioszilla]

Are you safe mode on ?

Nope he doesn't have safe mode on

safe_mode   Off   Off

[ioszilla]

@fca07, Eleglin:

Solution

http://www.simplemachines.org/community/index.php?topic=189110.0

I believe this will fix your problems.

- anderson

[Oldiesmann]

Thanks for the info wordzilla. I'll file an official bug report on it

[ioszilla]

Thanks Oldiesmann, I appreciate it.

[KGIII]

Bumping this to give people a chance to see it.