-= Frank Black Forum =-
-= Frank Black Forum =-
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Off Topic!
 Suggestion Box / Website Discussion
 Search Function - pilot error?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

apl4eris
~ Abstract Brain ~

USA
4800 Posts

Posted - 12/04/2003 :  19:13:05  Show Profile  Visit apl4eris's Homepage
Sorry if this happens to be a hackneyed topic, but I wanted to see if it is just pilot error or if this is a known problem. I always either get a timeout error, a db error, or "no matches found" (even with a very specific search and a small timeframe).

Edited by - apl4eris on 12/04/2003 19:14:35

BLT
> Teenager of the Year <

South Sandwich Islands
4204 Posts

Posted - 12/04/2003 :  19:43:44  Show Profile
I used to be able to get results with a narrow date range, but lately I haven't had any success at all.
Go to Top of Page

Dave Noisy
Minister of Chaos

Canada
4496 Posts

Posted - 12/04/2003 :  20:34:26  Show Profile  Visit Dave Noisy's Homepage
The SQL (database) is over 300MB now...sickeningly huge..

There's a 45 second default time-out programmed into it..i can try upping that, but if it's say 120 seconds, and it's still timing out frequently, then i'll have to set it back (since it's wasting so much more of the server's time and CPU..)

I'll also archive all the forums in the near future, that should ease things up..
Go to Top of Page

apl4eris
~ Abstract Brain ~

USA
4800 Posts

Posted - 12/05/2003 :  08:39:08  Show Profile  Visit apl4eris's Homepage
Ok. Thank you, Dave. :) It's a little weird that "no results" are turning up for narrow keyword and timeframe search parameters.

Wow! Is that SQL db onsite, or are you having to pay for that storage?
Go to Top of Page

El Barto
= Song DB Master =

USA
4020 Posts

Posted - 12/05/2003 :  10:35:57  Show Profile  Visit El Barto's Homepage
The search function never, ever works, just to let you know Dave.


"I joined the Cult of Clops / If I were you, I'd sleep with one eye open."
Go to Top of Page

Dave Noisy
Minister of Chaos

Canada
4496 Posts

Posted - 12/05/2003 :  11:15:39  Show Profile  Visit Dave Noisy's Homepage
It's on the server. You guys have chatted up a real storm!
Go to Top of Page

TOTIPOTENT
- Master of Differentiation -

USA
247 Posts

Posted - 12/05/2003 :  14:10:16  Show Profile  Visit TOTIPOTENT's Homepage
Hey Dave is this something a little money can solve? I’ve been wanting to pay to change my status from "Dog in the Sand" to "Master of Differentiation" or something. Maybe I can do something for the site/cause. What does anybody that's anybody think?




"I joined the Cult of Frank / 'Cause those damn search engines didn't do my site justice"
Go to Top of Page

apl4eris
~ Abstract Brain ~

USA
4800 Posts

Posted - 12/05/2003 :  16:24:37  Show Profile  Visit apl4eris's Homepage
I was hinting at that very self-same thing TOTI....he still hasn't answered my question though. Is the server yours or is the db hosted on someone else's server, offsite? And do you need some money? hint hint nudge nudge <wink wink> heheh :)
Go to Top of Page

Dave Noisy
Minister of Chaos

Canada
4496 Posts

Posted - 12/05/2003 :  23:34:42  Show Profile  Visit Dave Noisy's Homepage
hehe - for you Toti, it's yours.

Hold those thoughts guys - i've got a little something in the works...

The server is run by a very generous friend, and the db is on there.. I dunno if there's any reasonable upgrades we can do to it now.. It's something like a Pentium Pro..ancient!
Go to Top of Page

TOTIPOTENT
- Master of Differentiation -

USA
247 Posts

Posted - 12/05/2003 :  23:51:11  Show Profile  Visit TOTIPOTENT's Homepage
Wow, I do not know how long it has been there but it took me reading this here thread to realize it. You’re awesome Dave! Anything; just let me know.
Go to Top of Page

BLT
> Teenager of the Year <

South Sandwich Islands
4204 Posts

Posted - 12/09/2003 :  21:53:58  Show Profile
FYI: Some searching of the forum can be done at Google. Just include the following in your search to limit the results to this forum:
site:forum.frankblack.net



"Join the Cult of Dustin / And vanish without a trace"
Go to Top of Page

apl4eris
~ Abstract Brain ~

USA
4800 Posts

Posted - 12/09/2003 :  22:35:30  Show Profile  Visit apl4eris's Homepage
Son of a gun - if it were a snake it woulda bit me on the nose. Thanks, BLT!


Join the Cult of Carl / Lisening him do bass for our power ballad 'Hypocrite of the Heart' is like lisening to angels play bass.
Go to Top of Page

Dave Noisy
Minister of Chaos

Canada
4496 Posts

Posted - 12/09/2003 :  22:53:03  Show Profile  Visit Dave Noisy's Homepage
Oh yeah..heh..maybe i should add a second box with that.. ;)

How up-to-date is it tho?
Go to Top of Page

mdisanto
* Dog in the Sand *

USA
1140 Posts

Posted - 12/10/2003 :  07:48:38  Show Profile  Visit mdisanto's Homepage
it seems like sql should be able to handle the search, how exactly do you have it searching?

-miked
Go to Top of Page

BLT
> Teenager of the Year <

South Sandwich Islands
4204 Posts

Posted - 12/10/2003 :  08:39:41  Show Profile
quote:
Originally posted by Dave Noisy

How up-to-date is it tho?



I searched for "song of the day" and it returned "Do You Feel Bad About It" from 12/4/03, so it's probably about a week behind. Try it y'self:
http://www.google.com/search?num=20&hl=en&lr=&ie=UTF-8&oe=utf-8&q=site%3Aforum.frankblack.net+%22song+of+the+day%22&btnG=Google+Search
Go to Top of Page

Thomas
* Dog in the Sand *

USA
1615 Posts

Posted - 12/10/2003 :  09:53:19  Show Profile  Click to see Thomas's MSN Messenger address
That search thing is pretty cool.

Thomas
"Our love is rice and beans and horses lard"
Go to Top of Page

Thomas
* Dog in the Sand *

USA
1615 Posts

Posted - 12/10/2003 :  11:31:06  Show Profile  Click to see Thomas's MSN Messenger address
test

Edited by - Thomas on 12/10/2003 11:35:55
Go to Top of Page

Thomas
* Dog in the Sand *

USA
1615 Posts

Posted - 12/10/2003 :  11:33:57  Show Profile  Click to see Thomas's MSN Messenger address
.

Edited by - Thomas on 12/10/2003 11:34:36
Go to Top of Page

Dave Noisy
Minister of Chaos

Canada
4496 Posts

Posted - 12/10/2003 :  12:11:13  Show Profile  Visit Dave Noisy's Homepage
I'm pretty sure i used the updated search page from here:

http://www.snitzbitz.com/mods/details.asp?Version=All&mid=65

Plus added the line:

server.timeout=240

But the default is 45 seconds (if memory serves), so it's weird that it craps out at 35 seconds....
Go to Top of Page

apl4eris
~ Abstract Brain ~

USA
4800 Posts

Posted - 02/02/2004 :  14:35:37  Show Profile  Visit apl4eris's Homepage
Hey Dave, I dunno, but I think I'm starting to lose it ;), but I can't ever get a result from the search function. It's always with the:

"Microsoft OLE DB Provider for ODBC Drivers error '80040e31'

[Microsoft][ODBC SQL Server Driver]Timeout expired

/search.asp, line 547"

Why does it hate me so?


"Wir müssen wissen. Wir werden wissen."/"Our house has seven doors, all are green...except one, which is yellow."
Go to Top of Page

Cult_Of_Frank
= Black Noise Maker =

Canada
11523 Posts

Posted - 02/02/2004 :  14:57:00  Show Profile  Visit Cult_Of_Frank's Homepage
I've got the same problem...


"Join the Cult of Frank / And you'll be enlightened"
Go to Top of Page

Dave Noisy
Minister of Chaos

Canada
4496 Posts

Posted - 02/02/2004 :  15:29:45  Show Profile  Visit Dave Noisy's Homepage
It needs help...i'll try and look into it soon.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
-= Frank Black Forum =- © 2002-2016 Frank Black Fans, Inc. Go To Top Of Page
Snitz Forums 2000