I recently did a fresh db creation using the latest compatible db for the .6.0-DR1 .. (PEQ classic 058, aa_levels, altadv_vars,wr_update)
Everything sourced fine, and permissions were added to the db as well.
(I am attempting to run the server on the local network, using minilog)
Edit: using winxp SP1
-- The problem starts at char creation... i can create a char, but every starting city gives the message: the zone is unavailable.
Here are my files:
Db.ini
[Database]
host=localhost
user=username
password=******
database=eq
Loginserver.ini
[LoginServer]
loginserver=66.253.xxx.xxx
loginport=5999
worldname=my test eqemu
worldaddress=66.253.xxx.xxx
locked=false
account=username
password=*****
[WorldServer]
Defaultstatus=20
Unavailzone=
[ChatChannelServer]
worldshortname=
chataddress=
chatport=
[LoginConfig]
ServerMode=Minilogin
ServerPort=5999
Boot5zones.bat
REM:--------------Start-----------------------
@echo off
if NOT exist spells_us.txt goto NOSPELL
start zone . 66.253.xxx.xxx 8780 127.0.0.1
start zone . 66.253.xxx.xxx 8781 127.0.0.1
start zone . 66.253.xxx.xxx 8782 127.0.0.1
start zone . 66.253.xxx.xxx 8783 127.0.0.1
start zone . 66.253.xxx.xxx 8784 127.0.0.1
exit
cls
***********************************************
Output windows -- output after creating a char
***********************************************
Minilog.exe
LoginServer.ini read.
Server mode: Standalone
Login server listening on port:5999
4297 New Server connection: 66.253.xxx.xxx port: 44808
40703 New client from ip: 127.0.0.1 port: 2229
354656 New client from ip: 127.0.0.1 port: 2243
World.exe
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR1
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=34229, max id=77505
[Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un
known005,unknown006,unknown007,SpellCharges,itemcl ass,name,lore,idfile,id,weight
,norent,nodrop,attuneable,size,slots,cost,icon,unk nown018,unknown019,unknown020,
tradeskills,cr,dr,pr,mr,fr,astr,asta,aagi,adex,ach a,aint,awis,hp,mana,ac,deity,s
killmodvalue,skillmodtype,banedmgrace,banedmgamt,b anedmgbody,magic,casttime2,has
teproclvl,reqlevel,bardtype,bardvalue,light,delay, reclevel,recskill,elemdmgtype,
elemdmgamt,effecttype,range,damage,color,classes,r aces,unknown061,spellid,maxcha
rges,itemtype,material,sellrate,unknown067,casttim e,unknown069,proc_rate_mod,foc
usid,combateffects,shielding,stunresist,strikethro ugh,combatskill,combatskilldmg
,spellshield,avoidance,accuracy,unknown081,faction mod1,factionmod2,factionmod3,f
actionmod4,factionamt1,factionamt2,factionamt3,fac tionamt4,charmfile,augtype,aug
slot1type,augslot2type,augslot3type,augslot4type,a ugslot5type,ldonpointtheme,ldo
npointcost,ldonsold,bagtype,bagslots,bagsize,bagwr ,unknown105,booktype,filename,
banedmgamt2,augmentrestriction,loreflag,pendinglor eflag,artifactflag,summonedfla
g,tribute,gmflag,endur,dotshielding,attackbonus,hp regen,manaregen,hastepercent,d
amageshield,minstatus FROM items ORDER BY id', #1054: Unknown column 'SpellCharg
es' in 'field list'
[Error] If you got an error related to the 'SpellCharges' field, run the followi
ng SQL Query: ALTER TABLE `items` CHANGE `unknown008` `SpellCharges` INT(11) DE
FAULT "0" NOT NULL;
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems <<--- NOTE
[Error] Error: Could not load item data. But ignoring
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
HELP I WORK IN THE EQEMU SWEATSHOP, YOU'RE MY ONLY HOPE!
TCP listening on: 66.253.xxx.xxx:9000
World server listening on: 66.253.xxx.xxx:9000
Connected to LoginServer: 66.253.xxx.xxx:5999
62843 New client from ip: 66.253.xxx.xxx port: 2230
Account Attempting to be created:Twƒ0î??(??c??`¡??úä,µw 20
Logged in: FirstLogin Account #2: Twƒ0î??(??c??`¡??úä,µw
Received unknown opcode: 0x02eb size:0 bytes
Name approval request for
eath race:6 class:11
Character creation request from Twƒ0î??(??c??`¡??úä,µw LS#0 (66.253.xxx.xxx:2230
) :
Name: Death
Race: 6 Class: 11 Gender: 0 Deity: 206 Start zone: 5
STR STA AGI DEX WIS INT CHA Total
60 75 90 85 83 129 60 582
Face: 6 Eye colors: 7 7
Hairstyle: 0 Haircolor: 255
Beard: 255 Beardcolor: 17
Validating char creation info...
Found 0 errors in character creation request
[Status] Start zone query: SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE p
layer_choice=5 AND player_class=11 AND player_deity=206 AND player_race=6
[Status] Found starting location in start_zones
Current location: neriakc 1255.00, -1253.00, -80.00
Bind location: neriakc 1255.00, -1253.00, -80.00
Starting Items Query: SELECT itemid, item_charges FROM starting_items WHERE (rac
e = 6 or race = 0) AND (class = 11 or class = 0) AND (deityid = 206 or deityid=0
) AND (zoneid = 42 or zoneid = 0) AND gm <= 20 ORDER BY id
Character creation successful: Death
Read group ID for 'Death': 0
0: 2C 30 2C 2E 44 65 61 74 - 68 2C 30 36 37 61 37 39 | ,0,.Death,067a79
16: 64 34 00 | d4.
Attempting autobootup of neriakc (42) for Death
Error: No zoneserver to bootup neriakc (42) for Death
Received unknown opcode: 0x02eb size:0 bytes
0: 2C 30 2C 2E 44 65 61 74 - 68 2C 30 36 37 61 37 39 | ,0,.Death,067a79
16: 64 34 00 | d4.
Attempting autobootup of neriakc (42) for Death
Error: No zoneserver to bootup neriakc (42) for Death
Received unknown opcode: 0x02eb size:0 bytes
0: 2C 30 2C 2E 44 65 61 74 - 68 2C 30 36 37 61 37 39 | ,0,.Death,067a79
16: 64 34 00 | d4.
Attempting autobootup of neriakc (42) for Death
Error: No zoneserver to bootup neriakc (42) for Death
Received unknown opcode: 0x02eb size:0 bytes
0: 2C 30 2C 2E 44 65 61 74 - 68 2C 30 36 37 61 37 39 | ,0,.Death,067a79
16: 64 34 00 | d4.
Attempting autobootup of neriakc (42) for Death
Error: No zoneserver to bootup neriakc (42) for Death
Received unknown opcode: 0x02eb size:0 bytes
0: 2C 30 2C 2E 44 65 61 74 - 68 2C 30 36 37 61 37 39 | ,0,.Death,067a79
16: 64 34 00 | d4.
Attempting autobootup of neriakc (42) for Death
Error: No zoneserver to bootup neriakc (42) for Death
Received unknown opcode: 0x02eb size:0 bytes
0: 2C 30 2C 2E 44 65 61 74 - 68 2C 30 36 37 61 37 39 | ,0,.Death,067a79
16: 64 34 00 | d4.
Attempting autobootup of neriakc (42) for Death
Error: No zoneserver to bootup neriakc (42) for Death
Received unknown opcode: 0x02eb size:0 bytes
0: 2C 30 2C 2E 44 65 61 74 - 68 2C 30 36 37 61 37 39 | ,0,.Death,067a79
16: 64 34 00 | d4.
Attempting autobootup of neriakc (42) for Death
Error: No zoneserver to bootup neriakc (42) for Death
Received unknown opcode: 0x02eb size:0 bytes
Received unknown opcode: 0x00ee size:0 bytes
Client disconnected
Removing client from ip:66.253.xxx.xxx port:2230
350562 New TCP connection: 127.0.0.1:2244
350562 New TCP connection: 127.0.0.1:2245
350562 New TCP connection: 127.0.0.1:2246
350562 New TCP connection: 127.0.0.1:2247
350562 New TCP connection: 127.0.0.1:2248
New zoneserver: #1 127.0.0.1:2248
New zoneserver: #2 127.0.0.1:2247
New zoneserver: #3 127.0.0.1:2246
New zoneserver: #4 127.0.0.1:2245
New zoneserver: #5 127.0.0.1:2244
Zoneserver SetConnectInfo: 127.0.0.1:2244: 66.253.xxx.xxx:8783
Zoneserver SetConnectInfo: 127.0.0.1:2245: 66.253.xxx.xxx:8784
Zoneserver SetConnectInfo: 127.0.0.1:2246: 66.253.xxx.xxx:8780
Zoneserver SetConnectInfo: 127.0.0.1:2247: 66.253.xxx.xxx:8781
Zoneserver SetConnectInfo: 127.0.0.1:2248: 66.253.xxx.xxx:8782
1 of 5 Boot5zone windows:
[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR1
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
Error: EMuShareMem: DLLLoadItems: !ItemsMMF.IsLoaded() (timeout)
[Error] Loading items FAILED! <<-- EmuShareMem error again
Failed. But ignoring error and going on...
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 6290
[Status] Loading guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] command_init(): Warning: Command 'help' defaulting to access level 0!
[Status] command_init(): Warning: Command 'version' defaulting to access level 0
!
[Status] command_init(): Warning: Command 'serversidename' defaulting to access
level 0!
[Status] command_init(): Warning: Command 'loc' defaulting to access level 0!
[Status] command_init(): Warning: Command 'flag' defaulting to access level 0!
[Status] command_init(): Warning: Command 'si' defaulting to access level 0!
[Status] command_init(): Warning: Command 'hp' defaulting to access level 0!
[Status] command_init(): Warning: Command 'pf' defaulting to access level 0!
[Status] command_init(): Warning: Command 'bestz' defaulting to access level 0!
[Status] command_init(): Warning: Command 'ginfo' defaulting to access level 0!
[Status] 170 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000
**********************************************
My client was patched to live as of 1:45am 10/18
If anyone has any idea how this can be fixed, it would be greatly appreciated.