AlliedModders

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

tripc 12-29-2008 08:06

MySQL Error
 
In the first time when I get in to the server the result is "Match found"
But when I quit from the game and try get in back I get that error(quit from game, not disconnect):
"MySQL server has gone away"

There is my code below:

Thanks.

Please someone tell me what is worng...

Hawk552 12-29-2008 14:43

Re: MySQL Error
 
You'll need to give us more code. My guess is that you forgot to free the query using SQL_FreeHandle.

danielkza 12-29-2008 15:57

Re: MySQL Error
 
Quote:

Originally Posted by Hawk552 (Post 735109)
You'll need to give us more code. My guess is that you forgot to free the query using SQL_FreeHandle.

Actually I've got this error before: Because threaded queries create their own connections, the global connection is never used, and times out. Try setting the timeout higher, or connecting whenever you need.

Spunky 12-29-2008 21:30

Re: MySQL Error
 
Quote:

Originally Posted by danielkza (Post 735153)
Actually I've got this error before: Because threaded queries create their own connections, the global connection is never used, and times out. Try setting the timeout higher, or connecting whenever you need.

Wait, what? I don't think he's using threaded querying. O_o

tripc 12-30-2008 05:56

Re: MySQL Error
 
Thanks.

Hawk552 12-30-2008 14:22

Re: MySQL Error
 
Show us the full code.

tripc 12-30-2008 17:49

Re: MySQL Error
 
Thanks.

Hawk552 12-30-2008 18:37

Re: MySQL Error
 
Getting their authid on client_authorized has given me grief in the past. You should try getting it only on client_putinserver.

tripc 12-31-2008 06:50

Re: MySQL Error
 
I still get the error "MySQL server has gone away" after I quit from the game and try get in back again.

There is anything else worng with my code? :cry:

Edit:
I have to disconnect the server from the database and reconnect everytime? =\


All times are GMT -4. The time now is 09:17.

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