The Firing Line Forums

Go Back   The Firing Line Forums > Forum Support > Site Questions and Tech Support (NO FIREARMS QUESTIONS)

Reply
 
Thread Tools
Old November 8, 2005, 11:21 AM   #1
Mike Irwin
Staff
 
Join Date: April 13, 2000
Location: Northern Virginia
Posts: 36,321
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.
Mike Irwin is offline  
Old November 9, 2005, 01:08 PM   #2
tyme
Staff
 
Join Date: October 13, 2001
Posts: 3,185
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)
tyme is offline  
Old November 9, 2005, 03:40 PM   #3
Mal H
Staff
 
Join Date: March 20, 1999
Location: Somewhere in the woods of Northern Virginia
Posts: 14,564
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.
Mal H is offline  
Old 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.
AndrewTB is offline  
Old November 9, 2005, 05:31 PM   #5
tyme
Staff
 
Join Date: October 13, 2001
Posts: 3,185
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)
tyme is offline  
Old November 9, 2005, 07:02 PM   #6
Mal H
Staff
 
Join Date: March 20, 1999
Location: Somewhere in the woods of Northern Virginia
Posts: 14,564
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.
Mal H is offline  
Old November 10, 2005, 12:26 AM   #7
Mike Irwin
Staff
 
Join Date: April 13, 2000
Location: Northern Virginia
Posts: 36,321
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.
Mike Irwin is offline  
Old November 10, 2005, 03:47 PM   #8
pax
Staff
 
Join Date: May 16, 2000
Location: Washington state
Posts: 6,983
Ummm, so should it be working now?

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

pax
__________________
Kathy Jackson
My personal website: Cornered Cat
pax is offline  
Old November 12, 2005, 12:20 AM   #9
jimpeel
Senior Member
 
Join Date: October 11, 1999
Location: Longmont, CO, USA
Posts: 4,488
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
jimpeel is offline  
Old 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
Harley Quinn is offline  
Old 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!
WhoKnowsWho is offline  
Old November 18, 2005, 01:02 PM   #12
pax
Staff
 
Join Date: May 16, 2000
Location: Washington state
Posts: 6,983
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
pax is offline  
Old 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
TheBluesMan is offline  
Old 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....
FirstFreedom is offline  
Old November 23, 2005, 12:22 PM   #15
tyme
Staff
 
Join Date: October 13, 2001
Posts: 3,185
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)
tyme is offline  
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 08:51 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
This site and contents, including all posts, Copyright © 1998-2014 S.W.A.T. Magazine
Copyright Complaints: Please direct DMCA Takedown Notices to the registered agent: thefiringline.com
Contact Us
Page generated in 0.08888 seconds with 7 queries