AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   SQLx (https://forums.alliedmods.net/showthread.php?t=55177)

Major__ 05-15-2007 17:38

SQLx
 
Hi!

Is there any known problem with the SQLx-module?

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

Bad_Bud 05-16-2007 00:13

Re: SQLx
 
I don't know, I seem to have problems with it sometimes, and the problems will fix themselves without even resetting the server sometimes.

Major__ 05-16-2007 13:48

Re: SQLx
 
yeah... i dont really like the "problem sometimes fixes it self" solution...

YamiKaitou 05-16-2007 13:51

Re: SQLx
 
Why not check to see if the database connection is still active before you call the querys?

Major__ 05-16-2007 18:59

Re: SQLx
 
Well.. i created a fresh connection before i queryed.

Zenith77 05-16-2007 22:40

Re: SQLx
 
Show us your code.

Podunk 09-20-2007 20:18

Re: SQLx
 
The problem is the query handle is empty before it's executed.

X-Script 09-20-2007 20:23

Re: SQLx
 
Way to bump an old thread.


All times are GMT -4. The time now is 10:34.

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