L2JMobius

Free Users => General Discussion => Topic started by: khngoanh on August 04, 2020, 05:20:46 PM

Title: Error : MySQL Server has gone away !
Post by: khngoanh on August 04, 2020, 05:20:46 PM

Excuse me!
I have a problem. When i run the GameServer console, the website has a error 'mysql has gone away'. Turn off the GameServer, website run ok. So, could you let me know how to fix it? Thanks alot.

Ps: Prelude of war client

Title: Re: Error : MySQL Server has gone away !
Post by: G-hamsteR on August 04, 2020, 09:47:48 PM

Maybe the mysql has used the max connections. Are you using xampp?

Title: Re: Error : MySQL Server has gone away !
Post by: Trance on August 04, 2020, 10:22:37 PM

Thar's a funny error.

Title: Re: Error : MySQL Server has gone away !
Post by: anarki on August 04, 2020, 10:49:01 PM

Just edit on server.ini
# Default: 100
MaximumDbConnections = 50

Title: Re: Error : MySQL Server has gone away !
Post by: khngoanh on August 05, 2020, 03:21:13 AM

Quote from: G-hamsteR on August 04, 2020, 09:47:48 PM

Maybe the mysql has used the max connections. Are you using xampp?

Yes. I using xampp.

Title: Re: Error : MySQL Server has gone away !
Post by: bctey on August 05, 2020, 07:21:13 AM

C:\Program Files\MySQL\MySQL Server 5.5\my.ini
max_connections=1000

Title: Re: Error : MySQL Server has gone away !
Post by: G-hamsteR on August 05, 2020, 06:45:45 PM

Quote from: khngoanh on August 05, 2020, 03:21:13 AM

Quote from: G-hamsteR on August 04, 2020, 09:47:48 PM

Maybe the mysql has used the max connections. Are you using xampp?

Yes. I using xampp.

Decrease the number of your connection, just like anarki said. This should fix your problem.

If you want to make your server live, you will need to make few optimizations and configurations to mariadb.

Title: Re: Error : MySQL Server has gone away !
Post by: khngoanh on August 06, 2020, 10:59:09 AM

Thanks alot. I got it. So may be im not run the xampp as administrator.

And where can i find the item list? Include the id and name.

Title: Re: Error : MySQL Server has gone away !
Post by: G-hamsteR on August 06, 2020, 12:16:10 PM

Quote from: khngoanh on August 06, 2020, 10:59:09 AM

Thanks alot. I got it. So may be im not run the xampp as administrator.

And where can i find the item list? Include the id and name.

Can you be more specific? I didn't understand what you mean. Since the MySQL problem is fixed, you can start a new topic for your new question.