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? |
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.
|
Re: SQLx
yeah... i dont really like the "problem sometimes fixes it self" solution...
|
Re: SQLx
Why not check to see if the database connection is still active before you call the querys?
|
Re: SQLx
Well.. i created a fresh connection before i queryed.
|
Re: SQLx
Show us your code.
|
Re: SQLx
The problem is the query handle is empty before it's executed.
|
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.