Plz Help, mysql 2006 problem

dnk · #1 01-16-2005, 02:12 AM

This 2006 almost kill me.
I have been reading thread and trying all kinds of solutions mentioned in them, but it still does't work.

When I start world.exe, it gives me this:

Code:

[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[Status] Loading variables..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #2006: MySQL server has gone away
[Status] Loading zones..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL s
erver has gone away
[Status] Clearing groups..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Unable to clear groups: #2006: MySQL server has gone away
[Status] Loading items..
[Status] EMuShareMem loaded
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in GetItemsCount query 'SELECT MAX(id),count(*) FROM items' #2006: MySQL s
erver has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data.  But ignoring
Invalid worldname, please edit LoginServer.ini.  Server name must be at least 10
 characters.
Invalid worldshortname, please edit LoginServer.ini.  Short server name must be
at least 3 characters.
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title,
 rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, ran
k5, rank5title from guilds' #2006: MySQL server has gone away
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player corpses from database
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player backups from database
HELP I WORK IN THE EQEMU SWEATSHOP, YOU'RE MY ONLY HOPE!
TCP listening on: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
Connected to LoginServer: 127.0.0.1:5999
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: 'Login server responded with
FatalError. Disabling reconnect.#2006: MySQL server has gone away
Error message: 'Bad server name. Unknown reason.'
'
127.0.0.1:5999: TCPConnection::RecvData(): Error: 10053

Some info:
1, System: Windows XP
2, mysql version: 4.1

I have tried these:
1, add a space after host, user, password in db.ini
2, start mysql with --max_allowed_packet=16M
3, tried change host in db.ini, localhost, 127.0.0.1, 192.168.0.6(this is my ip)
4, All kinds of the grant staff

Please help me, Thanks a lot