Raised This Month: $ Target: $400
 0% 

MySQL Error


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
tripc
Senior Member
Join Date: Aug 2006
Old 12-29-2008 , 08:06   MySQL Error
Reply With Quote #1

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...

Last edited by tripc; 09-06-2009 at 09:24.
tripc is offline
Hawk552
AMX Mod X Moderator
Join Date: Aug 2005
Old 12-29-2008 , 14:43   Re: MySQL Error
Reply With Quote #2

You'll need to give us more code. My guess is that you forgot to free the query using SQL_FreeHandle.
__________________
Hawk552 is offline
Send a message via AIM to Hawk552
danielkza
AMX Mod X Plugin Approver
Join Date: May 2007
Location: São Paulo - Brasil
Old 12-29-2008 , 15:57   Re: MySQL Error
Reply With Quote #3

Quote:
Originally Posted by Hawk552 View Post
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.
__________________

Community / No support through PM
danielkza is offline
Spunky
Senior Member
Join Date: May 2008
Location: Orlando, Fl.
Old 12-29-2008 , 21:30   Re: MySQL Error
Reply With Quote #4

Quote:
Originally Posted by danielkza View Post
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
Spunky is offline
Send a message via AIM to Spunky
tripc
Senior Member
Join Date: Aug 2006
Old 12-30-2008 , 05:56   Re: MySQL Error
Reply With Quote #5

Thanks.

Last edited by tripc; 09-06-2009 at 09:24.
tripc is offline
Old 12-30-2008, 13:19
tripc
This message has been deleted by YamiKaitou. Reason: bump
Hawk552
AMX Mod X Moderator
Join Date: Aug 2005
Old 12-30-2008 , 14:22   Re: MySQL Error
Reply With Quote #6

Show us the full code.
__________________
Hawk552 is offline
Send a message via AIM to Hawk552
tripc
Senior Member
Join Date: Aug 2006
Old 12-30-2008 , 17:49   Re: MySQL Error
Reply With Quote #7

Thanks.

Last edited by tripc; 09-06-2009 at 09:23.
tripc is offline
Hawk552
AMX Mod X Moderator
Join Date: Aug 2005
Old 12-30-2008 , 18:37   Re: MySQL Error
Reply With Quote #8

Getting their authid on client_authorized has given me grief in the past. You should try getting it only on client_putinserver.
__________________
Hawk552 is offline
Send a message via AIM to Hawk552
tripc
Senior Member
Join Date: Aug 2006
Old 12-31-2008 , 06:50   Re: MySQL Error
Reply With Quote #9

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?

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

Last edited by tripc; 12-31-2008 at 11:11.
tripc is offline
Old 01-01-2009, 09:13
tripc
This message has been deleted by YamiKaitou. Reason: bump
Reply


Thread Tools
Display Modes

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 09:17.


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