"Forum Search" up the sprout?

[#1]

Still seem ropey for me jelv. Searching for "IWF" returned all sorts of nonsense!

[#2]

found the answer to your IWF search  http://www.aldi.co.uk/uk/html/offers/2867_5041.htm

Tried editing this using the edit button, I am on firefox, had to use the Modify bottom at the top
IWF - is that International Wildlife Fund?

[#3]

See what you mean.
I did find that a search which failed totally and only gave results from yonks back gave me proper results when repeated with a day range.
I must have hit lucky with the search terms I used.

[#4]

Looking more closely, the spurious results that I'm getting seem to contain results from previous searches I've performed - IWF returned results with iPlayer and Postini which were both searches I'd performed earlier. I'm wondering if there are some temporary tables involved which are not being cleared correctly and my first attempts worked because no-one else had been doing searches recently.

[#5]

Quote from: jelv

I'm wondering if there are some temporary tables involved which are not being cleared correctly

I agree. Sometimes, the number of results seemed to relate to a previous search, while the highlighted text seemed to relate to the current search...
And sometimes the number of results seemed to relate to an earlier search...

[#6]

The problem is relating to the DB user that the forums use not having permissions to create temporary tables.
Bug was raised in http://www.simplemachines.org/community/index.php?topic=189110.0 and the fix is fairly simple.  Colin is aware.
B.

[#7]

Is that information that has only recently gone Colin's way?
Edit: http://custom.simplemachines.org/mods/index.php?mod=887 looks interesting

[#8]

I  am aware? If I am, I don't know it

[#9]

Read those pesky PMs!
B.

[#10]

What Barry suggested has been implemented...

[#11]

Woot!
Search seems to work!
B.

[#12]

It most certainly is!

[#13]

Brilliant.....I'm off to search for.......Anything

[#14]

Very nice to see.
_{However, is the sequence of the results when "Most recent topics first" (my preferred default) is chosen in advanced search, a little different from the expected?}

[#15]

Most recent first appears more understandable to me if you also select Show results as messages.
I wish there was a way I could set those as my defaults!