L2JMobius

Prelude of War Error : MySQL Server has gone away !

khngoanh · 9 · 3051

Offline khngoanh

  • Vassal
  • *
    • Posts: 3
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


Online G-hamsteR

  • Viscount
  • *****
    • Posts: 333
Maybe the mysql has used the max connections. Are you using xampp?



Online anarki

  • Knight
  • ***
    • Posts: 62
Just edit on server.ini
# Default: 100
MaximumDbConnections = 50


Offline khngoanh

  • Vassal
  • *
    • Posts: 3

Online bctey

  • Knight
  • ***
    • Posts: 96
C:\Program Files\MySQL\MySQL Server 5.5\my.ini
max_connections=1000


Online G-hamsteR

  • Viscount
  • *****
    • Posts: 333
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.


Offline khngoanh

  • Vassal
  • *
    • Posts: 3
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.


Online G-hamsteR

  • Viscount
  • *****
    • Posts: 333
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.