November 8, 2005, 11:21 AM | #1 |
Staff
Join Date: April 13, 2000
Location: Northern Virginia
Posts: 41,390
|
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 |
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, 03:40 PM | #3 |
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 |
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, 05:31 PM | #5 |
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 9, 2005, 07:02 PM | #6 |
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 10, 2005, 12:26 AM | #7 |
Staff
Join Date: April 13, 2000
Location: Northern Virginia
Posts: 41,390
|
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 |
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 |
November 12, 2005, 12:20 AM | #9 |
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 |
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 |
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 |
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 |
November 18, 2005, 01:32 PM | #13 |
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 |
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 |
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) |
|
|