madbeanpedals::forum

General => Open Discussion => Topic started by: madbean on October 24, 2018, 04:56:12 PM

Title: Searching - for an answer
Post by: madbean on October 24, 2018, 04:56:12 PM
The search function continues to crash every few days so I have been repairing it every so often. Anyone here know enough about PHP or SQL to guess as to what would make the log_search_results table crash so easily? I've looked a bit on smf support but haven't really found an answer.
Title: Re: Searching - for an answer
Post by: Aentons on October 24, 2018, 05:56:03 PM
What version of SMF? What database are you using? MySQL, PostgreSQL, or SQLite. I have seen issues like that with PostgreSQL.

How do you repair it?...restore from backup?


edit: I see at the bottom it's SMF 2.0.12
Title: Re: Searching - for an answer
Post by: thesmokingman on October 24, 2018, 06:10:01 PM
admin>search>search method .... set it to not index
Title: Re: Searching - for an answer
Post by: EBRAddict on October 24, 2018, 06:28:53 PM
I've never had one of these SMF sites, so I'm ignorant of how it is laid out. Is the search part of the built-in functionality or is it an add-on module?
Title: Re: Searching - for an answer
Post by: Aentons on November 07, 2018, 06:27:35 PM
Looks like the Search function is down again
Title: Re: Searching - for an answer
Post by: madbean on November 07, 2018, 06:34:10 PM
Looks like the Search function is down again

II have smf working on building a custom search index but it will take some time. It might fix the issue.
Title: Re: Searching - for an answer
Post by: Ekimneets on November 07, 2018, 07:36:53 PM
Brian, I know itís a PITB, but when the search function is working it helps me to ask a lot less stupid questions.

-Mike
Title: Re: Searching - for an answer
Post by: jimilee on November 07, 2018, 07:52:59 PM
Brian, I know itís a PITB, but when the search function is working it helps me to ask a lot less stupid questions.

-Mike
Go to google and enter this
Site:www.madbeanpedals.com stuff youíre searching for


Sent from my iPhone using Tapatalk
Title: Re: Searching - for an answer
Post by: madbean on November 07, 2018, 07:59:07 PM
The new search index should actually be even better and pretty fast (and with no crashes). It just takes a long time to build. Luckily it's automatic. I had it running for about 6 hours today and it was up to 40% completion. But, it was timing out the forum so I'll probably try and run it in the wee hours.
Title: Re: Searching - for an answer
Post by: thesmokingman on November 07, 2018, 08:48:43 PM
yeah reindexing is an off-hours event
Title: Re: Searching - for an answer
Post by: Ekimneets on November 07, 2018, 09:36:47 PM
Wow, jimilee that works great.

Thx,

it really does cut down on an enormous amount of dumb questions.

-Mike
Title: Re: Searching - for an answer
Post by: cresconio on November 08, 2018, 03:32:43 AM
I'd be happy to take a closer look.
Title: Re: Searching - for an answer
Post by: movinginslomo on November 08, 2018, 04:37:36 PM
Can this be stickied until the search function is restored? Especially if someone were to go "did you use the.. oh wait.. hmm" to someone's question
Title: Re: Searching - for an answer
Post by: madbean on November 08, 2018, 04:51:01 PM
Can this be stickied until the search function is restored? Especially if someone were to go "did you use the.. oh wait.. hmm" to someone's question

Stickied, and guaranteed to be ignored by someone :)

I'll run some more of the indexing tonight. Maybe it can be ready by tomorrow.
Title: Re: Searching - for an answer
Post by: madbean on November 11, 2018, 05:20:32 AM
So, the custom index basically ended up crashing so I ditched it. Search in re-enabled again this time with the standard index. Hopefully that will help the situation. Please post here if you find search crashed again.