Error in loading items from mysql
Hello all. I have been playing with this for a couple of days now, and still haven't been able to resolve this issue. I suspect that it is because of
the error that my server is not showing up on the server selection screen. I have deleted the eq database from mysql twice, and sourced it twice with no errors. I tried the item editor to delete the line that it drops at, with no luck. Any help you can provide me would be greatly appreciated. Thanks in advance, Mike World.exe output: [Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR3 [Status] Loading variables.. [Status] Loading zones.. [Status] Loading items.. [Status] EMuShareMem loaded [Status] Loading items from database: count=28731, max id=69304 [Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un known005,unknown006,unknown007,itemclass,name,lore ,idfile,id,weight,norent,nodrop,size,slots,cost,ic on,unknown018,unknown019,unknown020,tradeskills,cr ,dr,pr,mr,fr,astr,asta,aagi,adex,acha,aint,awis,hp ,mana,ac,deity,skillmodvalue,skillmodtype,banedmgr ace,banedmgamt,banedmgbody,magic,casttime2,hastepr oclvl,reqlevel,bardt ype,bardvalue,light,delay,reclevel,recskill,elemdm gtype,elemdmgamt,effecttype,range,damage,color,cla sses,races,unknown061,spellid,maxcharges,itemtype, material,sellrate,unknown067,casttime,unknown069,p roc_rate_mod,focusid,combateffects,shielding,stunr esist,strikethrough,combatskill,combatskilldmg,spe llshield,avoidance,a ccuracy,unknown081,factionmod1,factionmod2,faction mod3,factionmod4,factionamt1,factionamt2,factionam t3,factionamt4,charmfile,augtype,augslot1type,augs lot2type,augslot3type,augslot4type,augslot5type,ld onpointtheme,ldonpointcost,ldonsold,bagtype,bagslo ts,bagsize,bagwr,booktype,unknown105,filename,bane dmgamt2,augmentrestriction,loreflag,pendinglorefla g,artifactflag,summonedflag,tribute,gmflag,endur,d otshielding,attackbonus,hpregen,manaregen,hasteper cent,damageshield,minstatus FROM items ORDER BY id', #1054: Unknown column 'charges' in 'field list' Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems [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] Reboot zone modes ON [Status] Deleted 0 stale player corpses from database [Status] Deleted 0 stale player backups from database Assassinating people that whine about horses...done TCP listening on: 217.84.XXX.XXX:9000 World server listening on: 217.84.XXX.XXX:9000 Connected to LoginServer: eqlogin2.eqemulator.net:5997 356563 New TCP connection: 192.168.1.102:2662 356563 New TCP connection: 192.168.1.102:2663 356563 New TCP connection: 192.168.1.102:2664 356563 New TCP connection: 192.168.1.102:2665 356563 New TCP connection: 192.168.1.102:2666 New zoneserver: #1 192.168.1.102:2666 New zoneserver: #2 192.168.1.102:2665 New zoneserver: #3 192.168.1.102:2664 New zoneserver: #4 192.168.1.102:2663 New zoneserver: #5 192.168.1.102:2662 Zoneserver SetConnectInfo: 192.168.1.102:2662: 217.84.XXX.XXX:7999 Zoneserver SetConnectInfo: 192.168.1.102:2663: 217.84.XXX.XXX:7995 Zoneserver SetConnectInfo: 192.168.1.102:2664: 217.84.XXX.XXX:7998 Zoneserver SetConnectInfo: 192.168.1.102:2665: 217.84.XXX.XXX:7996 Zoneserver SetConnectInfo: 192.168.1.102:2666: 217.84.XXX.XXX:7997 Boot5zones.bat output: [Status] CURRENT_ZONE_VERSION: EQEMu 0.5.7-DR3 [Status] Loading Variables [Status] Loading zone names [Status] Loading items [Status] EMuShareMem loaded Error: EMuShareMem: DLLLoadItems: !ItemsMMF.IsLoaded() (timeout) [Error] Loading items FAILED! Failed. But ignoring error and going on... [Status] Loading npcs [Status] Loading NPCTypes from database... NPCs loaded - using old database format [Status] Loading npc faction lists [Status] Loading NPC Faction Lists from database... [Status] Loading loot tables [Status] Loading doors [Status] FileLoadSPDat() Loading spells from ./spells_us.txt [Status] FileLoadSPDat() spells loaded: 5426 [Status] Loading guilds [Status] Loading factions [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] 161 commands loaded [Status] Entering sleep mode Connected to worldserver: 192.168.1.102:9000 Boot5zones.bat: 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_us.txt goto NOSPELL start zone . 217.84.XXX.XXX 7995 192.168.1.102 start zone . 217.84.XXX.XXX 7996 192.168.1.102 start zone . 217.84.XXX.XXX 7997 192.168.1.102 start zone . 217.84.XXX.XXX 7998 192.168.1.102 start zone . 217.84.XXX.XXX 7999 192.168.1.102 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------------------------ |
ok yes this is something in your database
Try going to http://cvs.biosprite.net/ Downloading the latest file that is on the list. Extract it. And source in "itemtablechanges.sql" to your eq database. That should most likely fix your problem Remember doing forget to type "use eq;" (or whatever your eq db name is) in sql. it can be a common mistake. |
That fixed that problem...Thank you!
I still don't see my server on the the select screen though...any suggestions? Thanks :-) |
There are some walkthroughs for some routers around this forum somewhere.
If you have a linksys router, go to 192.168.1.1. Look around, and try puting the eqemu server computer in the DMZ. That will put your server computer outside of the routers firewall, and no port forwarding is needed. Just makes it alot easier. If not. Then post your configuration for me. I'll see what i can do! |
Okay, things must be up and runing, but I still can't see my server
on the world selection list. Any ideas? Check the sample from world.exe below..... Thx again, Mike World.exe output: 3611094 New client from ip: 68.109.112.18 port: 62847 Account Attempting to be created:Krazac 0 Logged in: FirstLogin LS#54203: Krazac Received unknown opcode: 0x02ee size:0 bytes World: processing ZTZ from egress zone (155) client: Sunny World (155): Successfully booted a zone for Sunny Zoneserver SetZone: 217.237.86.229:7997 shadeweaver (165) Broadcasting a world time update World: processing ZTZ from ingress zone (165) client: Sunny 3704063 New client from ip: 69.148.69.255 port: 1413 Logged in: FirstLogin LS#53364: frogger Logged in: FirstLogin LS#53364: frogger Zoneserver SetZone: 217.237.86.229:7998 (0) Zoneserver SetZone: 217.237.86.229:7998 (0) Enter world: Sunny: shadeweaver (165) Zoneserver SetZone: 217.237.86.229:7997 shadeweaver (165) Client disconnected Removing client from ip:69.148.69.255 port:1413 Name approval request for:Krazac race:11 class:2 Character creation request from Krazac LS#54203 (68.109.112.18:62847) : Name: Krazac Race: 11 Class: 2 Gender: 0 Deity: 205 Start zone: 3 STR STA AGI DEX WIS INT CHA Total 80 85 95 90 110 67 50 577 Face: 4 Eye colors: 2 2 Hairstyle: 0 Haircolor: 255 Beard: 255 Beardcolor: 0 Validating char creation info... Found 0 errors in character creation request [Status] Found starting location in start_zones Current location: rivervale -228.00, -369.00, -17.00 Bind location: rivervale -228.00, -369.00, -17.00 Character creation successful: Krazac Attempting autobootup of rivervale (19) for Krazac Zoneserver SetZone: 217.237.86.229:7998 rivervale (19) Enter world: Krazac: rivervale (19) Broadcasting a world time update Zoneserver SetZone: 217.237.86.229:7998 rivervale (19) Client disconnected Removing client from ip:68.109.112.18 port:62847 World: processing ZTZ from egress zone (165) client: Sunny World (165): Successfully booted a zone for Sunny Zoneserver SetZone: 217.237.86.229:7999 paludal (156) Broadcasting a world time update World: processing ZTZ from ingress zone (156) client: Sunny 4372391 New client from ip: 69.148.69.255 port: 1445 Logged in: FirstLogin LS#53364: frogger Enter world: Sunny: paludal (156) Zoneserver SetZone: 217.237.86.229:7997 (0) Zoneserver SetZone: 217.237.86.229:7997 (0) Zoneserver SetZone: 217.237.86.229:7999 paludal (156) Client disconnected Removing client from ip:69.148.69.255 port:1445 4513360 New client from ip: 81.62.249.18 port: 14015 Account Attempting to be created:Raph 0 Logged in: FirstLogin LS#54430: Raph Received unknown opcode: 0x02ee size:0 bytes Name approval request for:Gree race:130 class:16 Character creation request from Raph LS#54430 (81.62.249.18:14015) : Name: Gree Race: 130 Class: 16 Gender: 1 Deity: 396 Start zone: 13 STR STA AGI DEX WIS INT CHA Total 100 105 90 80 70 65 65 575 Face: 6 Eye colors: 8 8 Hairstyle: 255 Haircolor: 255 Beard: 255 Beardcolor: 255 Validating char creation info... Found 0 errors in character creation request No start_zones entry in database, using defaults Current location: sharvahl 85.00, -1135.00, -188.00 Bind location: sharvahl 85.00, -1135.00, -188.00 Character creation successful: Gree Attempting autobootup of sharvahl (155) for Gree Zoneserver SetZone: 217.237.86.229:7997 sharvahl (155) Enter world: Gree: sharvahl (155) Zoneserver SetZone: 217.237.86.229:7997 sharvahl (155) Client disconnected Removing client from ip:81.62.249.18 port:14015 5049594 New client from ip: 68.109.112.18 port: 63121 Logged in: FirstLogin LS#54203: Krazac Zoneserver SetZone: 217.237.86.229:7998 (0) Zoneserver SetZone: 217.237.86.229:7998 (0) Received unknown opcode: 0x02ee size:0 bytes Zoneserver SetZone: 217.237.86.229:7997 (0) Zoneserver SetZone: 217.237.86.229:7997 (0) Received unknown opcode: 0x00f0 size:0 bytes Client disconnected Removing client from ip:68.109.112.18 port:63121 5684969 New client from ip: 69.148.69.255 port: 1503 Logged in: FirstLogin LS#53364: frogger Received unknown opcode: 0x02ee size:0 bytes Zoneserver SetZone: 217.237.86.229:7999 (0) Zoneserver SetZone: 217.237.86.229:7999 (0) Attempting autobootup of paludal (156) for Sunny Zoneserver SetZone: 217.237.86.229:7998 paludal (156) Enter world: Sunny: paludal (156) Broadcasting a world time update Zoneserver SetZone: 217.237.86.229:7998 paludal (156) Client disconnected Removing client from ip:69.148.69.255 port:1503 6267672 New client from ip: 69.148.69.255 port: 1588 Logged in: FirstLogin LS#53364: frogger Enter world: Sunny: paludal (156) Zoneserver SetZone: 217.237.86.229:7998 paludal (156) Client disconnected Removing client from ip:69.148.69.255 port:1588 Zoneserver SetZone: 217.237.86.229:7998 (0) Zoneserver SetZone: 217.237.86.229:7998 (0) 7798196 New client from ip: 68.109.112.18 port: 63688 Logged in: FirstLogin LS#54203: Krazac Received unknown opcode: 0x02ee size:0 bytes Name approval request for:Shizara race:130 class:16 Character creation request from Krazac LS#54203 (68.109.112.18:63688) : Name: Shizara Race: 130 Class: 16 Gender: 0 Deity: 396 Start zone: 13 STR STA AGI DEX WIS INT CHA Total 100 85 95 95 70 65 65 575 Face: 1 Eye colors: 3 3 Hairstyle: 255 Haircolor: 255 Beard: 255 Beardcolor: 255 Validating char creation info... Found 0 errors in character creation request No start_zones entry in database, using defaults Current location: sharvahl 85.00, -1135.00, -188.00 Bind location: sharvahl 85.00, -1135.00, -188.00 Character creation successful: Shizara Attempting autobootup of sharvahl (155) for Shizara Zoneserver SetZone: 217.237.86.229:7998 sharvahl (155) Enter world: Shizara: sharvahl (155) Broadcasting a world time update Zoneserver SetZone: 217.237.86.229:7998 sharvahl (155) Client disconnected Removing client from ip:68.109.112.18 port:63688 8103805 New client from ip: 24.210.36.7 port: 1161 Account Attempting to be created:servaiout 0 Logged in: FirstLogin LS#53418: servaiout Logged in: FirstLogin LS#53418: servaiout 8144383 New client from ip: 69.170.44.158 port: 1103 Account Attempting to be created:ragingtoboggan2 0 Logged in: FirstLogin LS#53526: ragingtoboggan2 Logged in: FirstLogin LS#53526: ragingtoboggan2 Received unknown opcode: 0x02ee size:0 bytes Name approval request for:Drew race:7 class:8 Character creation request from servaiout LS#53418 (24.210.36.7:1161) : Name: Drew Race: 7 Class: 8 Gender: 0 Deity: 396 Start zone: 1 STR STA AGI DEX WIS INT CHA Total 95 70 90 100 60 75 85 575 Face: 1 Eye colors: 4 4 Hairstyle: 0 Haircolor: 6 Beard: 255 Beardcolor: 6 Validating char creation info... Found 0 errors in character creation request No start_zones entry in database, using defaults Current location: qeynos2 114.00, 678.00, 4.00 Bind location: qeynos2 114.00, 678.00, 4.00 Character creation successful: Drew Attempting autobootup of qeynos2 (2) for Drew Zoneserver SetZone: 217.237.86.229:7997 qeynos2 (2) Enter world: Drew: qeynos2 (2) Broadcasting a world time update Zoneserver SetZone: 217.237.86.229:7997 qeynos2 (2) Client disconnected Removing client from ip:24.210.36.7 port:1161 Client disconnected Removing client from ip:69.170.44.158 port:1103 8433665 New client from ip: 69.164.90.226 port: 3317 Account Attempting to be created:patriott19 0 Logged in: FirstLogin LS#54135: patriott19 Logged in: FirstLogin LS#54135: patriott19 Received unknown opcode: 0x02ee size:0 bytes Name approval request for:Dakkil race:11 class:1 Character creation request from patriott19 LS#54135 (69.164.90.226:3317) : Name: Dakkil Race: 11 Class: 1 Gender: 0 Deity: 211 Start zone: 3 STR STA AGI DEX WIS INT CHA Total 80 85 100 115 80 67 50 577 Face: 7 Eye colors: 7 7 Hairstyle: 0 Haircolor: 255 Beard: 255 Beardcolor: 18 Validating char creation info... Found 0 errors in character creation request [Status] Found starting location in start_zones Current location: rivervale -152.00, 100.00, 46.00 Bind location: rivervale -152.00, 100.00, 46.00 Character creation successful: Dakkil Zoneserver SetZone: 217.237.86.229:7998 (0) Zoneserver SetZone: 217.237.86.229:7998 (0) Attempting autobootup of rivervale (19) for Dakkil Zoneserver SetZone: 217.237.86.229:7998 rivervale (19) Enter world: Dakkil: rivervale (19) Broadcasting a world time update Zoneserver SetZone: 217.237.86.229:7998 rivervale (19) Client disconnected Removing client from ip:69.164.90.226 port:3317 Zoneserver SetZone: 217.237.86.229:7998 (0) Zoneserver SetZone: 217.237.86.229:7998 (0) 8849571 New client from ip: 69.164.90.226 port: 3551 Logged in: FirstLogin LS#54135: patriott19 Received unknown opcode: 0x02ee size:0 bytes Zoneserver SetZone: 217.237.86.229:7997 (0) Zoneserver SetZone: 217.237.86.229:7997 (0) Attempting autobootup of rivervale (19) for Dakkil Zoneserver SetZone: 217.237.86.229:7998 rivervale (19) Enter world: Dakkil: rivervale (19) Broadcasting a world time update Zoneserver SetZone: 217.237.86.229:7998 rivervale (19) Client disconnected Removing client from ip:69.164.90.226 port:3551 World: processing ZTZ from egress zone (19) client: Dakkil World (19): Successfully booted a zone for Dakkil Zoneserver SetZone: 217.237.86.229:7997 misty (33) Broadcasting a world time update World: processing ZTZ from ingress zone (33) client: Dakkil 9063743 New client from ip: 69.164.90.226 port: 3619 Logged in: FirstLogin LS#54135: patriott19 Zoneserver SetZone: 217.237.86.229:7998 (0) Zoneserver SetZone: 217.237.86.229:7998 (0) Enter world: Dakkil: misty (33) Zoneserver SetZone: 217.237.86.229:7997 misty (33) Client disconnected Removing client from ip:69.164.90.226 port:3619 192.168.1.102:1157: TCPConnection::RecvData(): Error: 10053 Removing zoneserver from ip:0.0.0.0 port:0 (217.237.86.229:7997) Hold Zones mode is ON - rebooting lost zone 9174915 New TCP connection: 192.168.1.102:1363 New zoneserver: #6 192.168.1.102:1363 Zoneserver SetConnectInfo: 192.168.1.102:1363: 217.237.86.229:7997 9236305 New TCP connection: 192.168.1.102:1364 New zoneserver: #7 192.168.1.102:1364 Zoneserver SetConnectInfo: 192.168.1.102:1364: 217.237.86.229:7997 Zoneserver SetZone: 217.237.86.229:7997 misty (33) World: processing ZTZ from egress zone (33) client: Dakkil World (33): Successfully booted a zone for Dakkil Zoneserver SetZone: 217.237.86.229:7997 (0) Zoneserver SetZone: 217.237.86.229:7997 (0) 9284055 New client from ip: 69.164.90.226 port: 3767 Logged in: FirstLogin LS#54135: patriott19 Logged in: FirstLogin LS#54135: patriott19 Zoneserver SetZone: 217.237.86.229:7997 (0) Zoneserver SetZone: 217.237.86.229:7997 (0) Attempting autobootup of poknowledge (202) for Dakkil Zoneserver SetZone: 217.237.86.229:7997 poknowledge (202) Enter world: Dakkil: poknowledge (202) Broadcasting a world time update Zoneserver SetZone: 217.237.86.229:7997 poknowledge (202) Client disconnected Removing client from ip:69.164.90.226 port:3767 World: processing ZTZ from egress zone (202) client: Dakkil World (202): Successfully booted a zone for Dakkil Zoneserver SetZone: 217.237.86.229:7997 (0) Zoneserver SetZone: 217.237.86.229:7997 (0) World: processing ZTZ from egress zone (202) client: Dakkil World (202): Successfully booted a zone for Dakkil Zoneserver SetZone: 217.237.86.229:7997 (0) Zoneserver SetZone: 217.237.86.229:7997 (0) Zoneserver SetZone: 217.237.86.229:7997 (0) Zoneserver SetZone: 217.237.86.229:7997 (0) 9841118 New client from ip: 69.164.90.226 port: 3950 Logged in: FirstLogin LS#54135: patriott19 Logged in: FirstLogin LS#54135: patriott19 Attempting autobootup of tox (38) for Dakkil Zoneserver SetZone: 217.237.86.229:7997 tox (38) Enter world: Dakkil: tox (38) Broadcasting a world time update Client disconnected Removing client from ip:69.164.90.226 port:3950 Zoneserver SetZone: 217.237.86.229:7997 tox (38) Zoneserver SetZone: 217.237.86.229:7997 (0) Zoneserver SetZone: 217.237.86.229:7997 (0) 12417188 New client from ip: 217.43.95.225 port: 3575 [Error] Expecting OP_SendLoginInfo, got 241 Removing client from ip:217.43.95.225 port:3575 13960227 New client from ip: 4.11.200.243 port: 1967 Account Attempting to be created:sakebomb 0 Logged in: FirstLogin LS#35099: sakebomb Received unknown opcode: 0x02ee size:0 bytes Name approval request for:Sean race:6 class:12 Character creation request from sakebomb LS#35099 (4.11.200.243:1967) : Name: Sean Race: 6 Class: 12 Gender: 0 Deity: 396 Start zone: 5 STR STA AGI DEX WIS INT CHA Total 60 80 90 75 83 134 60 582 Face: 2 Eye colors: 4 4 Hairstyle: 1 Haircolor: 11 Beard: 255 Beardcolor: 11 Validating char creation info... Found 0 errors in character creation request No start_zones entry in database, using defaults Current location: neriaka 156.92, -2.94, 31.75 Bind location: nektulos -258.77, -1198.27, -5.67 Character creation successful: Sean Attempting autobootup of neriaka (40) for Sean Zoneserver SetZone: 217.237.86.229:7997 neriaka (40) Enter world: Sean: neriaka (40) Broadcasting a world time update Zoneserver SetZone: 217.237.86.229:7997 neriaka (40) Client disconnected Removing client from ip:4.11.200.243 port:1967 |
Well Apperantly somone can see your server.
Try Disabling software firewalls. like Zonealarm, etc. Also if you are using windows xp. Then Disable the windows firewall. Code:
1: Go to "My Network Places" on the desktop. If you are playing on the same machine you are serving, Then check out this post http://www.eqemulator.net/forums/vie...highlight=play[/code] |
I think i found your problem.
You are using DR3. And if i am not mistaken the new login server only takes DR4.. If you have your EQ patched to the latest, Then it is required that you use DR4 to play. There is something else for you. There is another walkthrough that shows you how to compile the latest releases. Check out this post http://www.eqemulator.net/forums/vie...ighlight=trial Also. This is going to show you DR2. When you get down to the step that says Quote:
This Release works a hell of a lot better than the last release DR4, its quite playable Sidenote: Cvs.biosprite.net gets swamped at times. it may take a few mins for the page to popup. But be patient, its there! |
Thanks for all the help
Thanks! You are a lifesaver. I have spent a lot of time reading the boards, but there is just so much information here. I did download all the files listed in the how to set up a server as of 6-1.
Thanks again for your time, patience and knowledge :-) Mike |
| All times are GMT -4. The time now is 06:51 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.