Re: "Forum Search" up the sprout?

Posts: 16,932

Thanks: 5,024

Fixes: 317

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

Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵

Posts: 19,757

Thanks: 3

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?

Posts: 26,785

Thanks: 965

Fixes: 10

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.

jelv (a.k.a Spoon Whittler)
Why I have left Plusnet (warning: long post!)
Broadband: Andrews & Arnold Home::1 (FTTC 80/20)
Line rental: Pulse 8 Home Line Rental (£14.40/month)
Mobile: iD mobile (£4/month)

Posts: 26,785

Thanks: 965

Fixes: 10

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.

jelv (a.k.a Spoon Whittler)
Why I have left Plusnet (warning: long post!)
Broadband: Andrews & Arnold Home::1 (FTTC 80/20)
Line rental: Pulse 8 Home Line Rental (£14.40/month)
Mobile: iD mobile (£4/month)

Posts: 486

Thanks: 2

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...

Posts: 3,793

Thanks: 4

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.

Posts: 26,785

Thanks: 965

Fixes: 10

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

jelv (a.k.a Spoon Whittler)
Why I have left Plusnet (warning: long post!)
Broadband: Andrews & Arnold Home::1 (FTTC 80/20)
Line rental: Pulse 8 Home Line Rental (£14.40/month)
Mobile: iD mobile (£4/month)

Posts: 1,264

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

Posts: 3,793

Thanks: 4

Read those pesky PMs!
B.

Posts: 1,264

What Barry suggested has been implemented...

Posts: 3,793

Thanks: 4

Woot!
Search seems to work!
B.

Posts: 26,785

Thanks: 965

Fixes: 10

It most certainly is!

jelv (a.k.a Spoon Whittler)
Why I have left Plusnet (warning: long post!)
Broadband: Andrews & Arnold Home::1 (FTTC 80/20)
Line rental: Pulse 8 Home Line Rental (£14.40/month)
Mobile: iD mobile (£4/month)

Posts: 31,320

Thanks: 1,589

Fixes: 565

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

Windows 10 Firefox 109.0 (64-bit)
To argue with someone who has renounced the use of reason is like administering medicine to the dead - Thomas Paine

Posts: 486

Thanks: 2

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?}

Posts: 26,785

Thanks: 965

Fixes: 10

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!

jelv (a.k.a Spoon Whittler)
Why I have left Plusnet (warning: long post!)
Broadband: Andrews & Arnold Home::1 (FTTC 80/20)
Line rental: Pulse 8 Home Line Rental (£14.40/month)
Mobile: iD mobile (£4/month)