Search database...

**Mike Irwin** · November 8, 2005, 11:21 AM

Any word on when it's going to be reconstructed back to full functionality?

**tyme** · November 9, 2005, 01:08 PM

It's not? The max results are limited to a few hundred because mysql fulltext searches can be a real problem otherwise. Otherwise, it should be fully functional.

**Mal H** · November 9, 2005, 03:40 PM

There's still something wrong with the search engine. Pax contacted me a few days ago to see if I knew anything about it. She can't find her name in any posts using "pax" or "pax*". I tried it with my name as well - no joy. I physically searched and found several example posts which should have been found by the automated searches.

I was going to ask you about it, but when I saw Mike's question, which I thought was based on the same problem, I waited to see what the answer was.

As a test, search for "pax" in this forum (S/Q/T Support, within last month) - no hits. Then search for "tyme". You'll find several hits; among them are posts which contain the word "pax".

(I checked the 3 character limit in the options; it's still in effect.)

BTW, everything is WAD on THR.

AndrewTB · November 9, 2005, 03:49 PM

These things can take time to fix especially after the outage TFL had. Ive had a few forums in the old day nowhere near the size of this one. Its not easy to fix and reconstruct everything. Even if your coming from backups.

**tyme** · November 9, 2005, 05:31 PM

Your usernames are too short.

The configuration is fixed, but mysql has to rebuild the index before it'll work. That takes a while, so it's best left until tonight.

Those settings don't apply anymore, since vbulletin now uses mysql fulltext searching rather than the vbulletin search system.

**Mal H** · November 9, 2005, 07:02 PM

Thanks!

"Those settings don't apply anymore, since vbulletin now uses mysql fulltext searching rather than the vbulletin search system."

Good, that explains why it still wouldn't work when I added "pax" to the search-no-matter-how-short-it-is word list in the options.

**Mike Irwin** · November 10, 2005, 12:26 AM

OK, here's the funny thing I noticed, and it's still happening...

If I type my last name in the quick search window, it returns 182 thread hits for threads where my last name appears somewhere in the thread.

That's well and good, except that IIRC it should be a lot more than that, and several threads that I know should be included in that list are nowhere to be found...

pax · November 10, 2005, 03:47 PM

Ummm, so should it be working now?

('cuz it's still not...)

pax

jimpeel · November 12, 2005, 12:20 AM

I have tried several times to search for something I know to be out there and all I get is a "Server Not Found" message.

Harley Quinn · November 13, 2005, 12:42 PM

As in when you click on 'new posts' it sends you to a page that says they are having problems.

But you can work around it. It will take sometime relax, they are probably working on it as we write...

Harley

WhoKnowsWho · November 13, 2005, 03:35 PM

Of course, I buy a new gun and need to check something on it and the search is down, and I will not post 'cause I know it has already been asked!

pax · November 18, 2005, 01:02 PM

Okay, I'm a nag and you guys are probably working furiously on this behind the scenes, but just in case you aren't, well ... it's still not working properly.

pax

TheBluesMan · November 18, 2005, 01:32 PM

We don't mind the reminders, pax.

Justin has been spending A LOT of time just keeping the forums up and running lately. Problems with connections and the database are taking up most of his time. I'm sure this is next on his list.

-Dave

FirstFreedom · November 22, 2005, 10:15 PM

Just tested it. The search function is definitely, completely broken.

No matter what you type in, you get a "sorry no matches" result. Try it. Type in "gun", search entire posts, any date, any forum, no restrictions at all - sorry, no matches....

**tyme** · November 23, 2005, 12:22 PM

It is not working. Mysql fulltext searches are supposed to be nigh on instantaneous. When they were enabled on the backup server, some searches caused huge delays thanks to mysql's table-level locking... so I changed the limit back to 4 characters. That means that any searches with three-letter (or less) words won't work. I haven't had time to investigate why some searches are so slow. I'll switch back to vbulletin's search mechanism until I can sort out what the problem is.

November 8, 2005, 11:21 AM	#1
Mike Irwin Staff Join Date: April 13, 2000 Location: Northern Virginia Posts: 41,389	Search database... Any word on when it's going to be reconstructed back to full functionality? __________________ "The gift which I am sending you is called a dog, and is in fact the most precious and valuable possession of mankind" -Theodorus Gaza Baby Jesus cries when the fat redneck doesn't have military-grade firepower.

November 9, 2005, 01:08 PM	#2
tyme Staff Join Date: October 13, 2001 Posts: 3,355	It's not? The max results are limited to a few hundred because mysql fulltext searches can be a real problem otherwise. Otherwise, it should be fully functional. __________________ “The egg hatched...” “...the egg hatched... and a hundred baby spiders came out...” (blade runner) “Who are you?” “A friend. I'm here to prevent you from making a mistake.” “You have no idea what I'm doing here, friend.” “In specific terms, no, but I swore an oath to protect the world...” (continuum) “It's a goal you won't understand until later. Your job is to make sure he doesn't achieve the goal.” (bsg)

November 9, 2005, 05:31 PM	#5
tyme Staff Join Date: October 13, 2001 Posts: 3,355	Your usernames are too short. The configuration is fixed, but mysql has to rebuild the index before it'll work. That takes a while, so it's best left until tonight. Those settings don't apply anymore, since vbulletin now uses mysql fulltext searching rather than the vbulletin search system. __________________ “The egg hatched...” “...the egg hatched... and a hundred baby spiders came out...” (blade runner) “Who are you?” “A friend. I'm here to prevent you from making a mistake.” “You have no idea what I'm doing here, friend.” “In specific terms, no, but I swore an oath to protect the world...” (continuum) “It's a goal you won't understand until later. Your job is to make sure he doesn't achieve the goal.” (bsg)

November 10, 2005, 12:26 AM	#7
Mike Irwin Staff Join Date: April 13, 2000 Location: Northern Virginia Posts: 41,389	OK, here's the funny thing I noticed, and it's still happening... If I type my last name in the quick search window, it returns 182 thread hits for threads where my last name appears somewhere in the thread. That's well and good, except that IIRC it should be a lot more than that, and several threads that I know should be included in that list are nowhere to be found... __________________ "The gift which I am sending you is called a dog, and is in fact the most precious and valuable possession of mankind" -Theodorus Gaza Baby Jesus cries when the fat redneck doesn't have military-grade firepower.

November 10, 2005, 03:47 PM	#8
pax Senior Member Join Date: May 16, 2000 Location: In a state of flux Posts: 7,520	Ummm, so should it be working now? ('cuz it's still not...) pax __________________ Kathy Jackson My personal website: Cornered Cat

November 9, 2005, 03:40 PM	#3
Mal H Staff Join Date: March 20, 1999 Location: Somewhere in the woods of Northern Virginia Posts: 16,955	There's still something wrong with the search engine. Pax contacted me a few days ago to see if I knew anything about it. She can't find her name in any posts using "pax" or "pax*". I tried it with my name as well - no joy. I physically searched and found several example posts which should have been found by the automated searches. I was going to ask you about it, but when I saw Mike's question, which I thought was based on the same problem, I waited to see what the answer was. As a test, search for "pax" in this forum (S/Q/T Support, within last month) - no hits. Then search for "tyme". You'll find several hits; among them are posts which contain the word "pax". (I checked the 3 character limit in the options; it's still in effect.) BTW, everything is WAD on THR.

November 9, 2005, 03:49 PM	#4
AndrewTB Junior member Join Date: January 11, 2005 Posts: 677	These things can take time to fix especially after the outage TFL had. Ive had a few forums in the old day nowhere near the size of this one. Its not easy to fix and reconstruct everything. Even if your coming from backups.

November 9, 2005, 07:02 PM	#6
Mal H Staff Join Date: March 20, 1999 Location: Somewhere in the woods of Northern Virginia Posts: 16,955	Thanks! "Those settings don't apply anymore, since vbulletin now uses mysql fulltext searching rather than the vbulletin search system." Good, that explains why it still wouldn't work when I added "pax" to the search-no-matter-how-short-it-is word list in the options.

November 12, 2005, 12:20 AM	#9
jimpeel Senior Member Join Date: October 11, 1999 Location: Longmont, CO, USA Posts: 4,530	I get nothing I have tried several times to search for something I know to be out there and all I get is a "Server Not Found" message. __________________ Gun Control: The premise that a woman found in an alley, raped and strangled with her own pantyhose, is morally superior to allowing that same woman to defend her life with a firearm. "Science is built up with facts, as a house is with stones. But a collection of facts is no more a science than a heap of stones is a house." - Jules Henri Poincare "Three thousand people died on Sept. 11 because eight pilots were killed" -- former Northwest Airlines pilot Stephen Luckey

November 13, 2005, 12:42 PM	#10
Harley Quinn Junior member Join Date: August 30, 2005 Location: State of KALI Posts: 1,531	Yep it is still making some mistakes. As in when you click on 'new posts' it sends you to a page that says they are having problems. But you can work around it. It will take sometime relax, they are probably working on it as we write... Harley

November 13, 2005, 03:35 PM	#11
WhoKnowsWho Senior Member Join Date: December 3, 2002 Location: Maricopa, AZ Posts: 193	Of course, I buy a new gun and need to check something on it and the search is down, and I will not post 'cause I know it has already been asked!

November 18, 2005, 01:02 PM	#12
pax Senior Member Join Date: May 16, 2000 Location: In a state of flux Posts: 7,520	Okay, I'm a nag and you guys are probably working furiously on this behind the scenes, but just in case you aren't, well ... it's still not working properly. pax __________________ Kathy Jackson My personal website: Cornered Cat

November 18, 2005, 01:32 PM	#13
TheBluesMan Moderator Emeritus Join Date: June 15, 1999 Location: Ohio Posts: 7,558	We don't mind the reminders, pax. Justin has been spending A LOT of time just keeping the forums up and running lately. Problems with connections and the database are taking up most of his time. I'm sure this is next on his list. -Dave

November 22, 2005, 10:15 PM	#14
FirstFreedom Junior member Join Date: May 31, 2004 Location: The Toll Road State, U.S.A. Posts: 12,451	Just tested it. The search function is definitely, completely broken. No matter what you type in, you get a "sorry no matches" result. Try it. Type in "gun", search entire posts, any date, any forum, no restrictions at all - sorry, no matches....

November 23, 2005, 12:22 PM	#15
tyme Staff Join Date: October 13, 2001 Posts: 3,355	It is not working. Mysql fulltext searches are supposed to be nigh on instantaneous. When they were enabled on the backup server, some searches caused huge delays thanks to mysql's table-level locking... so I changed the limit back to 4 characters. That means that any searches with three-letter (or less) words won't work. I haven't had time to investigate why some searches are so slow. I'll switch back to vbulletin's search mechanism until I can sort out what the problem is. __________________ “The egg hatched...” “...the egg hatched... and a hundred baby spiders came out...” (blade runner) “Who are you?” “A friend. I'm here to prevent you from making a mistake.” “You have no idea what I'm doing here, friend.” “In specific terms, no, but I swore an oath to protect the world...” (continuum) “It's a goal you won't understand until later. Your job is to make sure he doesn't achieve the goal.” (bsg)