1017 error.. tried all fixes I found
Been working on this for quite some time now... searched through MANY posts dealing with this problem, tried all suggestions I found, still not working... My file info is as follows:
db.ini [Database] host=localhost user=archivis password=****** database=eq compression=off loginserver.ini [LoginServer] loginserver=eqlogin1.eqemulator.net loginserver2=eqlogin2.eqemulator.net loginserver3=eqlogin3.eqemulator.net loginport=5997 loginport2=5997 loginport3=5997 worldname=Archivis' World worldaddress=external ip locked=false boot5.exe start zone . external ip 7995 internal ip start zone . external ip 7996 internal ip start zone . external ip 7997 internal ip start zone . external ip 7998 internal ip start zone . external ip 7999 internal ip exit cls I get as far as the server select screen, when I try to log into my, or any other server, I get booted back to login screen. When I started out, everything was fine up till this point. Then I tried the fixes and my server is coming up as locked, even though as you can see from my file, it shouldn't be. Yes all ip's are correct, edited them out for the post. Using a linksys router, and yes I followed the guide for it, turned off my win xp fire wall. All I can figure is that there must be more than one problem cause nothing is working. world.exe and boot5zones.exe both load up just fine with no errors. Thanks in advance for any help/suggestions. At this point I'll try anything, even putting on a head dress and shaking a dead chicken at my computer... Note: I tried the dead chicken all ready, all it did was get feathers everywhere, I dont suggest trying this... |
Make sure you have:
Quote:
If it still shows as locked, copy and paste the output of world.exe and one zone.exe process. |
Using a linksys router... did you DMZ?
|
still locked after adding said code to login.ini, here's the world and boot5 info:
World.exe [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,nodro p,size,slots,cost,icon,unknown018,unknown019,unkno wn020,tradeskills,cr,dr,pr,mr, fr,astr,asta,aagi,adex,acha,aint,awis,hp,mana,ac,d eity,skillmodvalue,skillmodtyp e,banedmgrace,banedmgamt,banedmgbody,magic,casttim e2,hasteproclvl,reqlevel,bardt ype,bardvalue,light,delay,reclevel,recskill,elemdm gtype,elemdmgamt,effecttype,ra nge,damage,color,classes,races,unknown061,spellid, maxcharges,itemtype,material,s ellrate,unknown067,casttime,unknown069,proc_rate_m od,focusid,combateffects,shiel ding,stunresist,strikethrough,combatskill,combatsk illdmg,spellshield,avoidance,a ccuracy,unknown081,factionmod1,factionmod2,faction mod3,factionmod4,factionamt1,f actionamt2,factionamt3,factionamt4,charmfile,augty pe,augslot1type,augslot2type,a ugslot3type,augslot4type,augslot5type,ldonpointthe me,ldonpointcost,ldonsold,bagt ype,bagslots,bagsize,bagwr,booktype,unknown105,fil ename,banedmgamt2,augmentrestr iction,loreflag,pendingloreflag,artifactflag,summo nedflag,tribute,gmflag,endur,d otshielding,attackbonus,hpregen,manaregen,hasteper cent,damageshield,minstatus FR OM 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.. [Error] Could not load EQTime file ./eqtime.cfg [Error] Unable to load ./eqtime.cfg [Status] Reboot zone modes ON [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: 68.192.165.95:9000 World server listening on: 68.192.165.95:9000 Connected to LoginServer: eqlogin3.eqemulator.net:5997 97850 New client from ip: 192.168.1.1 port: 3985 [Error] Expecting OP_SendLoginInfo, got 250 Removing client from ip:192.168.1.1 port:3985 (Note here that I've run eqemu 3 times before now over the span of the emu's life, and as long as I can remember I've seen the item error and it's still worked fine so I'm not worried about that) Boot5zones.exe [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 npc faction lists [Status] Loading loot tables [Status] Loading doors [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.100:9000 Now these seem to be running and working fine in and of themselves. Knowing me I've missed some mundane detail (insert Office Space quote here) But after looking at this for so long I just can't put my finger on it, and having tried so many suggested fixes, I'm not even sure at this point what was changed and what wasn't. Hope someone out there can make more sense of this than I can atm. :) |
Try sourcing itemtablechanges.sql that comes with the post 20th May source code from cvs.biosprite.net, that should add the fields you are missing.
|
Spike,
Yes, I followed the linksys walk through, though it seems a bit out of date, I was able to find the DMZ and update it to 100 (being my IP end number) sadly, unless I missed something in translating the older screen shots into what linksys currently uses, it didn't work. |
Thanks Derision, downloading it now and going to give it a shot... I'll be back ;)
|
You will probably still get a 1017
I use a linksys myself, to get it to work, I had to use my DNS name, not my external IP in LoginServer.ini and boot5zones, i.e. LoginServer.ini loginserver=eqlogin1.eqemulator.net loginserver2=eqlogin2.eqemulator.net loginserver3=eqlogin3.eqemulator.net loginserver4=eqlgin4.eqemulator.net loginport=5997 worldname=Your Server Name worldaddress=xyz.abc.co.uk locked=false boot5zones.bat start zone . xyz.abc.co.uk 7995 192.168.1.100 start zone . xyz.abc.co.uk 7996 192.168.1.100 start zone . xyz.abc.co.uk 7997 192.168.1.100 And finally, in c:\windows\system32\drivers\etc\hosts on the PC I use to connect to my server (both PCs are on my local LAN behind the same router) I had to add 192.168.1.100 xyz.abc.co.uk One final thing to note, the server you are creating is version 5.7DR3. You cannot connect to this if your EQ client is patched up to live. |
Interesting... I tried to source it and got this error:
mysql> source itemtablechanges.sql; ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist ERROR 1146: Table 'mysql.items' doesn't exist I'll be the first person to admit, I don't know too much about sourcing these things, but I do understand how to do it. I dropped all the files from the archive you sent me to into the mysql bin folder and sourced from there, that's what I got. |
You need to type
use eq ; or use <whatever you called your eq db> ; prior to source itemtablechanges.sql |
doh! See mundane detail.... rofl, ok that fixed the server locked, but yes, still 1017 error... going to give myself a little break then try doing what you suggested, thanks again Derision
|
by the by, where can I find my DNS name? lol N00B question I know... sorry in advance.
|
Quote:
To get your dns name, in XP, go to a command prompt and type nslookup <your external ip> If your ISP uses DHCP, your external IP and dns name may change from time to time. |
Ok got the DNS, going to try that next... but if YOU can log on my server... shouldn't I be able to? logically speaking at least... lol
|
Quote:
|
| All times are GMT -4. The time now is 11:25 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.