mysql problem - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql problem (/showthread.php?tid=423036)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql problem (/showthread.php?tid=423036)
mysql problem - Erase - 16.03.2013
So... I created db tables for my mysql script, but when i turn it on it shows this:
Quote:
|
[14:29:52] CMySQLHandler::Connect() - Connection was successful. [14:29:52] CMySQLHandler::Connect() - Auto-Reconnect has been enabled. [14:30:28] >> mysql_real_escape_string( Connection handle: 1 ) [14:30:28] CMySQLHandler::EscapeString(George_Gee); - Escaped 10 characters to George_Gee. [14:30:28] >> mysql_query( Connection handle: 1 ) [14:30:28] CMySQLHandler::Query(SELECT * FROM `Accounts` WHERE `Username` = 'George_Gee' LIMIT 1) - An error has occured. (Error ID: 2013, Lost connection to MySQL server during query) [14:30:28] >> mysql_store_result( Connection handle: 1 ) [14:30:28] CMySQLHandler::StoreResult() - No data to store. [14:30:28] >> mysql_num_rows( Connection handle: 1 ) [14:30:28] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection) [14:30:28] >> mysql_free_result( Connection handle: 1 ) |
Re: mysql problem - Djole1337 - 16.03.2013
Is that database hosted on localhost ?
Re: mysql problem - Erase - 16.03.2013
I bought a host from one website.
Re: mysql problem - Erase - 16.03.2013
Quote:
|
Error ID: 2006, MySQL server has gone away |
Re: mysql problem - Erase - 16.03.2013
Can someone help me please?
Re: mysql problem - 3ventic - 16.03.2013
The reason is probably one of the following
- Someone KILLed the query
- Network problems caused the connection to die
- The server crashed/died
- Your connection was idle for wait_timeout and was killed
- The client wasn't pulling data fast enough for net_wait_timeout and was killed
Re: mysql problem - Erase - 16.03.2013
Then how can i change wait_timeout?
Re: mysql problem - Erase - 16.03.2013
bump. Please help me.