The things you can do with search

That's exactly how I get the error as well

Yep that's how I get the error but it only seems to be within forums. If I do a global search not including the

+forumID=XXX

bit, it seems to work OK (see the pallet search a few posts back).
@Velocio any ideas?

Server Error

We're sorry, there was a temporary error when we tried to process your request.

The reason was: The search query took too long and has been cancelled

Click here to go back to the homepage.

This means what it says, the search took too long.

There are over 6 million comments (including private messages), and if your search is across the comments and you've been too vague, it will take too long (longer than 30 seconds).

Make your search more specific.

You can see the effect of specificity on searches that do work:

• 10 seconds = bottom bracket
  
• 1.5 seconds = sks bottom bracket
  
  

What are you searching for, and can you make it more specific.

The worst possible search is probably going to be for words like: bike, frame, ride.

I should add... once a search has been done, then it will be much faster in the minutes afterwards. Why? Because then all of the comments that matched a search would be pulled into memory, and subsequent searches will read from RAM and not the SSD... the difference is significant. Hours later, and the comments will have left RAM and the search for non-specific terms will be slower over all comments again.

Yep that's how I get the error but it only seems to be within forums. If I do a global search not including the +forumID=XXX bit, it seems to work OK (see the pallet search a few posts back).

That makes the search more specific... speeds it up.

Anything that makes the search look at fewer things will speed it up.

Shirley limiting things to one forum should be cutting the search time down though?
e.g.
http://www.lfgss.com/search/?q=crosstop&defaults=true works fine.
http://www.lfgss.com/search/?q=crosstop+forumId:549+sort:date doesn't work.

http://www.lfgss.com/search/?q=crosstop%20lever%2031.6+forumId:549+sort:date (increased specificity) doesn't work.
http://www.lfgss.com/search/?q=crosstop%20lever%2031.6+sort:date does work.

On that I concur.

It's a bug if it takes longer, I'll look into it.

Cool thanks :)

Yeah cheers. The problem only seems to occur when I do make it more specific.

All I want to do is search in the conversations rather than just the titles. Damned if I can work it out!

All I want to do is search in the conversations rather than just the titles. Damned if I can work it out!

Within a specific conversation?

Go to the conversation, use the search box in the right hand bar.

No within all conversations. For example I want to find out if anyone is selling some 105 shifters without trawling through all the for sale ads.

Is this not possible!?

Search for 105 shifters. Then in the right hand side bar uncheck "Title matched ..." and check "comments"

Then you will have to use some of the "forum number" magic to limit your search to just classifieds. More at the top o this thread...

#rep

Hmmmm ...

Hey @Velocio why has this stopped working?
https://www.lfgss.com/search/?forumId=523&forumId=531&forumId=538&forumId=543&forumId=547

This is still working. https://www.lfgss.com/search/?forumId=515

Hmm... is that the polo bookmark? Maybe it's multiple forums that is the bug...

Yup, multiple IDs break it.

I'll fix it now (or will at least start looking into it now).

On the upside, all of the polo forums are back together, going into the top one will show you all content and unread status of the ones below.

Cheers, just came back to say I'd read about sub forums in the bugs and hings thread and assumed it was because of that. Sub forums are great things, thanks for bringing them back.

Fixed, and yeah it was subforum related.

This query was wrong:

SELECT microcosm_id
  FROM microcosms
 WHERE path <@ (
           SELECT path
             FROM microcosms
            WHERE microcosm_id = ANY ($1::bigint[])
       );

Should've been:

WITH p AS (
    SELECT path
      FROM microcosms
     WHERE microcosm_id = ANY ($1::bigint[])
)
SELECT DISTINCT m.microcosm_id
  FROM microcosms m
      ,p
 WHERE m.path <@ p.path;

Thanks for letting me know. Now fixed.

How do I search for occurrences of people mentioning me? I can see comments I've made but it would be useful to see @sacredhart mentions so I can reply to people.

They appear in the following page linked at the bottom of every page.

Also here if it's too far to scroll down.
https://www.lfgss.com/updates/

Thanks I was aware of the 'following' page, but I wondered if I could specifically see just the times I'm mentioned.

I've never been able to do this. Can someone help me search for the term "mks gr9" in titles AND body copy in a certain forum. I can search for it in titles only (default setting?) and forumId:549 but when I get the results page and untick 'Title matched search terms' I get a server error. There can't be that many hits for that, surely?