Stefan1200's Forum

JTS3ServerMod Hosting Edition => JTS3ServerMod MySQL & WebInterface => Topic started by: Nate4ever on February 27, 2016, 07:21:40 AM

Title: Weird Error
Post by: Nate4ever on February 27, 2016, 07:21:40 AM
I got this weird error when i tried to create a bot...


Referer: http://ts3bot.thegamemonsters.com/index.php?page=botcreate&botcreateuserid=1
Page: /index.php?page=botcreate
SQL Statement: SELECT textmessage FROM jts3servermodwebui_translation WHERE textkey = 'webui_botlist' AND language_id = 1
SQL Error: MySQL server has gone away

If this web interface was not changed, please send this information to info@stefan1200.de and describe what you did to get this error. Thank you in advance!
Title: Re: Weird Error
Post by: Stefan1200 on February 27, 2016, 07:41:56 AM
The connection to the MySQL server was closed. That error should not happen on a second try.
Die Verbindung zum MySQL Server wurde geschlossen. Der Fehler sollte beim zweiten Versuch nicht mehr auftreten.

Long explanation: http://dev.mysql.com/doc/refman/5.7/en/gone-away.html
Title: Re: Weird Error
Post by: Nate4ever on February 27, 2016, 09:47:30 AM
English??
Title: Re: Weird Error
Post by: Stefan1200 on February 27, 2016, 09:56:01 AM
Quote from: Nate4ever on February 27, 2016, 09:47:30 AM
English??

Sorry, check updated post above.
Title: Re: Weird Error
Post by: Nate4ever on February 27, 2016, 04:37:15 PM
Tried it again and the same thing.
Title: Re: Weird Error
Post by: Nate4ever on February 27, 2016, 07:11:37 PM
I just looked at the bot error log and it says this..

2016-02-27 11:10:21   LOGGER_SQL_ERROR   Critical: Cannot connect to MySQL server for logging!


I tried diff MYSQL servers and still the same thing.
Title: Re: Weird Error
Post by: Stefan1200 on February 28, 2016, 12:41:29 AM
Please send me the output of:
java -version

Did you already checked everything from http://dev.mysql.com/doc/refman/5.7/en/gone-away.html ?
Title: Re: Weird Error
Post by: Nate4ever on February 28, 2016, 07:45:43 AM
Yea I tried that.

Java -version ? Are you asking what version is on the serveR?
Title: Re: Weird Error
Post by: Nate4ever on February 28, 2016, 07:52:16 AM
java version "1.8.0_60"
Java(TM) SE Runtime Environment (build 1.8.0_60-b27)
Java HotSpot(TM) Client VM (build 25.60-b23, mixed mode, sharing)
Title: Re: Weird Error
Post by: Stefan1200 on February 28, 2016, 09:47:58 AM
Yes, the Java version, which is executing the JTS3ServerMod. Your posted Java version is okay (but you should it update to 1.8.0_73/74).

Please check firewall, if the connection is maybe blocked. Also check the MySQL connection with the same account using the official MySQL client.