Raised This Month: $ Target: $400
 0% 

SQLx


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Major__
Junior Member
Join Date: Jan 2007
Old 05-15-2007 , 17:38   SQLx
Reply With Quote #1

Hi!

Is there any known problem with the SQLx-module?

I keep getting lines like this:
L 05/14/2007 - 23:056: Info (map "de_inferno") (logfile "error_051407.log")
L 05/14/2007 - 23:056: [MySQL] Thread worker was unable to start.
L 05/14/2007 - 23:056: [AMXX] Displaying debug trace (plugin "gather.amxx")
L 05/14/2007 - 23:056: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
L 05/14/2007 - 23:056: [AMXX] [0] gather.sma::create_gather (line 405)
L 05/14/2007 - 23:056: [AMXX] [1] gather.sma::abort_gather (line 277)
L 05/14/2007 - 23:056: [AMXX] [2] gather.sma::check_player (line 152)

in the error-logs... the same problem with the SQL_SimpleQuery:
L 05/15/2007 - 17:48:59: Start of error session.
L 05/15/2007 - 17:48:59: Info (map "de_nuke") (logfile "error_051507.log")
L 05/15/2007 - 17:48:59: [MySQL] Invalid database handle: 0
L 05/15/2007 - 17:48:59: [AMXX] Displaying debug trace (plugin "gather.amxx")
L 05/15/2007 - 17:48:59: [AMXX] Run time error 10: native error (native "SQL_PrepareQuery")
L 05/15/2007 - 17:48:59: [AMXX] [0] sqlx.inc::SQL_SimpleQuery (line 243)
L 05/15/2007 - 17:48:59: [AMXX] [1] gather.sma::finish_gather (line 443)


The thing is.. it works perfectly for some hours, then suddenly it crashes.
And it crashed like 3-4 time a day.
Nothing in the Lxxx.log's

Is this a known problem? is there a fix? is there a workaround?
Major__ is offline
Bad_Bud
Senior Member
Join Date: Oct 2006
Location: The internet
Old 05-16-2007 , 00:13   Re: SQLx
Reply With Quote #2

I don't know, I seem to have problems with it sometimes, and the problems will fix themselves without even resetting the server sometimes.
__________________
Bad_Bud is offline
Major__
Junior Member
Join Date: Jan 2007
Old 05-16-2007 , 13:48   Re: SQLx
Reply With Quote #3

yeah... i dont really like the "problem sometimes fixes it self" solution...
Major__ is offline
YamiKaitou
Has a lovely bunch of coconuts
Join Date: Apr 2006
Location: Texas
Old 05-16-2007 , 13:51   Re: SQLx
Reply With Quote #4

Why not check to see if the database connection is still active before you call the querys?
__________________
ProjectYami Laboratories

I do not browse the forums regularly anymore. If you need me for anything (asking questions or anything else), then PM me (be descriptive in your PM, message containing only a link to a thread will be ignored).
YamiKaitou is offline
Major__
Junior Member
Join Date: Jan 2007
Old 05-16-2007 , 18:59   Re: SQLx
Reply With Quote #5

Well.. i created a fresh connection before i queryed.
Major__ is offline
Zenith77
Veteran Member
Join Date: Aug 2005
Old 05-16-2007 , 22:40   Re: SQLx
Reply With Quote #6

Show us your code.
__________________
Quote:
Originally Posted by phorelyph View Post
your retatred
Zenith77 is offline
Podunk
Senior Member
Join Date: Nov 2005
Location: Florida
Old 09-20-2007 , 20:18   Re: SQLx
Reply With Quote #7

The problem is the query handle is empty before it's executed.
__________________
Check out my website at http://matthewmiller.info
Podunk is offline
Send a message via MSN to Podunk
X-Script
BANNED
Join Date: Jul 2007
Location: (#504434)
Old 09-20-2007 , 20:23   Re: SQLx
Reply With Quote #8

Way to bump an old thread.
X-Script is offline
Reply



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 -4. The time now is 10:34.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode