For the last couple of days now, i've been experiencing a list of errors when I try to load up the Boot5zones file. My world.exe file has no problems at all. I've tried just about every solution that was presented on this forum, including reinstalling MySQL and EQEmu files. Here is the error message:
Quote:
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.3-DR3
[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 zone names
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] 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] Loading items FAILED!
Failed. But ignoring error and going on...
[Status] Loading npcs
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in GetNPCTypesCount query 'SELECT MAX(id), count(*) FROM npc_types' #2006:
MySQL server has gone away
Error: Database::LoadNPCTypes-ShareMem: GetNPCTypesCount() returned < 0
[Error] Loading npcs FAILED!
===============================
Runtime errors:
MySQL Error #2003 means you were unable to connect to the mysql server.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=2
Hit any key to exit
|
Now you're probably thinking that I didnt grant permission to myself, but in fact I did (redid it multiple times). I also have absolutely no white spaces in any files, and i've rewritten db.ini by hand multiple times (deleted old db.ini files). Here are the contents of my boot5zones.bat, db.ini and loginserver.ini files (they are in order as listed):
Quote:
REM: ****Read this first!!!****
REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.
REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1
REM: If you still get errors try using localhost instead of 127.0.0.1
REM:--------------Start-----------------------
@echo off
if NOT exist spells_en.txt goto NOSPELL
start Zone.exe . 67.80.233.16 7995 67.80.233.16
start Zone.exe . 67.80.233.16 7996 67.80.233.16
start Zone.exe . 67.80.233.16 7997 67.80.233.16
start Zone.exe . 67.80.233.16 7998 67.80.233.16
start Zone.exe . 67.80.233.16 7999 67.80.233.16
exit
cls
:NOSPELL
echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE
REM:---------------END------------------------
|
Quote:
# READ README.TXT!
[Database]
host=localhost
user=ajantiss
password=********
database=eq
compression=off
### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.
|
Quote:
### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.
### --- Public Login is un-supported as is LAN playing. We recommend using the eqemulator.net Loginserver ALWAYS.
### --- NOTE: You can NOT use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automatically.
# READ README.TXT
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginport=5997
worldname=Battlegrounds
worldaddress=67.80.233.16
locked=false
[WorldServer]
Defaultstatus=0
Unavailzone=
[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=
|
My other info is as follows:
OS: Windows XP
MySQL version: MySQLAdmin 4.0.17
EQEmu version: 0.5.3-DR3
Host Type: Public Server
I've tried my best not to pester those on this forum for help, but im to the point where I am just completely clueless as to the reason for this problem. Any help would be greatly appreciated.