| Author |
 Topic  |
|
|
apl4eris
~ Abstract Brain ~
USA
4800 Posts |
 Posted - 12/04/2003 : 19:13:05
|
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
|
| I used to be able to get results with a narrow date range, but lately I haven't had any success at all. |
 |
|
|
Dave Noisy
Minister of Chaos
Canada
4496 Posts |
Posted - 12/04/2003 : 20:34:26
|
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.. |
|
|
|
apl4eris
~ Abstract Brain ~
USA
4800 Posts |
Posted - 12/05/2003 : 08:39:08
|
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? |
|
|
|
El Barto
= Song DB Master =
USA
4020 Posts |
Posted - 12/05/2003 : 10:35:57
|
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." |
|
|
|
Dave Noisy
Minister of Chaos
Canada
4496 Posts |
Posted - 12/05/2003 : 11:15:39
|
| It's on the server. You guys have chatted up a real storm! |
|
|
|
TOTIPOTENT
- Master of Differentiation -
USA
247 Posts |
Posted - 12/05/2003 : 14:10:16
|
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" |
|
|
|
apl4eris
~ Abstract Brain ~
USA
4800 Posts |
Posted - 12/05/2003 : 16:24:37
|
| 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 :) |
|
|
|
Dave Noisy
Minister of Chaos
Canada
4496 Posts |
Posted - 12/05/2003 : 23:34:42
|
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! |
|
|
|
TOTIPOTENT
- Master of Differentiation -
USA
247 Posts |
Posted - 12/05/2003 : 23:51:11
|
| 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. |
|
|
|
BLT
> Teenager of the Year <
South Sandwich Islands
4204 Posts |
Posted - 12/09/2003 : 21:53:58
|
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" |
|
|
|
apl4eris
~ Abstract Brain ~
USA
4800 Posts |
Posted - 12/09/2003 : 22:35:30
|
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. |
|
|
|
Dave Noisy
Minister of Chaos
Canada
4496 Posts |
Posted - 12/09/2003 : 22:53:03
|
Oh yeah..heh..maybe i should add a second box with that.. ;)
How up-to-date is it tho? |
|
|
|
mdisanto
* Dog in the Sand *
USA
1140 Posts |
Posted - 12/10/2003 : 07:48:38
|
it seems like sql should be able to handle the search, how exactly do you have it searching?
-miked |
|
|
|
BLT
> Teenager of the Year <
South Sandwich Islands
4204 Posts |
|
|
Thomas
* Dog in the Sand *
USA
1615 Posts |
Posted - 12/10/2003 : 09:53:19
|
That search thing is pretty cool.
Thomas
"Our love is rice and beans and horses lard" |
|
|
|
Thomas
* Dog in the Sand *
USA
1615 Posts |
Posted - 12/10/2003 : 11:31:06
|
test
|
Edited by - Thomas on 12/10/2003 11:35:55 |
|
|
|
Thomas
* Dog in the Sand *
USA
1615 Posts |
Posted - 12/10/2003 : 11:33:57
|
| . |
Edited by - Thomas on 12/10/2003 11:34:36 |
|
|
|
Dave Noisy
Minister of Chaos
Canada
4496 Posts |
|
|
apl4eris
~ Abstract Brain ~
USA
4800 Posts |
Posted - 02/02/2004 : 14:35:37
|
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." |
|
|
|
Cult_Of_Frank
= Black Noise Maker =
Canada
11687 Posts |
Posted - 02/02/2004 : 14:57:00
|
I've got the same problem...
 "Join the Cult of Frank / And you'll be enlightened" |
|
|
|
Dave Noisy
Minister of Chaos
Canada
4496 Posts |
Posted - 02/02/2004 : 15:29:45
|
| It needs help...i'll try and look into it soon. |
|
|
| |
Topic |
|
Topic Locked
