Author Topic: Searching - for an answer  (Read 521 times)

madbean

  • Administrator
  • Electron Doctor
  • *****
  • Posts: 8576
  • Brian
    • View Profile
    • madbeanpedals
Searching - for an answer
« 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.
I own madbeanpedals (duh). I am part owner of Function F(X).

Aentons

  • Stompbox Star
  • ***
  • Posts: 180
    • View Profile
Re: Searching - for an answer
« Reply #1 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
« Last Edit: October 24, 2018, 06:21:08 PM by Aentons »

thesmokingman

  • Solder Ninja
  • ****
  • Posts: 484
    • View Profile
    • A Cult of ACK
Re: Searching - for an answer
« Reply #2 on: October 24, 2018, 06:10:01 PM »
admin>search>search method .... set it to not index
once upon a time I was Tornado Alley FX

EBRAddict

  • Solder Ninja
  • ****
  • Posts: 372
  • Strictly bush league
    • View Profile
Re: Searching - for an answer
« Reply #3 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?

Aentons

  • Stompbox Star
  • ***
  • Posts: 180
    • View Profile
Re: Searching - for an answer
« Reply #4 on: November 07, 2018, 06:27:35 PM »
Looks like the Search function is down again

madbean

  • Administrator
  • Electron Doctor
  • *****
  • Posts: 8576
  • Brian
    • View Profile
    • madbeanpedals
Re: Searching - for an answer
« Reply #5 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.
I own madbeanpedals (duh). I am part owner of Function F(X).

Ekimneets

  • Solder Ninja
  • ****
  • Posts: 284
  • I am a cook, you guys are Chefs. Iím Mike, btw.
    • View Profile
Re: Searching - for an answer
« Reply #6 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
Legion of one at Black Octopus Pedalworx.

jimilee

  • Electron Doctor
  • *****
  • Posts: 7032
  • Jimi Lee
    • View Profile
Re: Searching - for an answer
« Reply #7 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
Pedal building is like the opposite of sex.  All the fun stuff happens before you get in the box.

madbean

  • Administrator
  • Electron Doctor
  • *****
  • Posts: 8576
  • Brian
    • View Profile
    • madbeanpedals
Re: Searching - for an answer
« Reply #8 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.
I own madbeanpedals (duh). I am part owner of Function F(X).

thesmokingman

  • Solder Ninja
  • ****
  • Posts: 484
    • View Profile
    • A Cult of ACK
Re: Searching - for an answer
« Reply #9 on: November 07, 2018, 08:48:43 PM »
yeah reindexing is an off-hours event
once upon a time I was Tornado Alley FX

Ekimneets

  • Solder Ninja
  • ****
  • Posts: 284
  • I am a cook, you guys are Chefs. Iím Mike, btw.
    • View Profile
Re: Searching - for an answer
« Reply #10 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
Legion of one at Black Octopus Pedalworx.

cresconio

  • Transistor Tickler
  • **
  • Posts: 77
    • View Profile
Re: Searching - for an answer
« Reply #11 on: November 08, 2018, 03:32:43 AM »
I'd be happy to take a closer look.

movinginslomo

  • Transistor Tickler
  • **
  • Posts: 110
  • Chris
    • View Profile
Re: Searching - for an answer
« Reply #12 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

madbean

  • Administrator
  • Electron Doctor
  • *****
  • Posts: 8576
  • Brian
    • View Profile
    • madbeanpedals
Re: Searching - for an answer
« Reply #13 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.
I own madbeanpedals (duh). I am part owner of Function F(X).

madbean

  • Administrator
  • Electron Doctor
  • *****
  • Posts: 8576
  • Brian
    • View Profile
    • madbeanpedals
Re: Searching - for an answer
« Reply #14 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.
I own madbeanpedals (duh). I am part owner of Function F(X).