EQEmulator Forums - Zone server disconnect

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)

- - Zone server disconnect (https://www.eqemulator.org/forums/showthread.php?t=12357)

hmm any idea on how to take that last part off?

you need to edit it, since your notepad.exe is trashed try opening command prompt and typing edit

hmm my ip is set to localhost and thanks for the tip i forgot about edit command I am just getting the hang of dos again. I will change it from localhost to 127.0.0.1 and see how it works

You don't need to do that, localhost and 127.0.0.1 are basically the same thing.

I don't think you understand what I am saying.

Inside your boot5zones.bat it should look like this

Code:

start zone . 127.0.0.1 7995 127.0.0.1

not like this:

Code:

start zone . 127.0.0.1 7995 YourIP

ahah it looks like this your ip 7995 127.0.0.1 gonna try again thanks

well now my problam matchs my thread title *sigh* thankfully what you said got me past the error messages to the load screen then it crashed and this is what the zone server said

Quote:

[Status] Using database 'eq' at localhost
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.5-DR1
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] Loading Doors from database...
[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] 157 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000
[Status] Weather should change in 3994 seconds
Init: Loading zone lists, zone state or spawn list, player corpses
Zonepoints loaded into memory
, timezone data - Done. ZoneID = 9; Time Offset = 0
Reading zhdr file './cfg/freportw.cfg'
Using database for safe coords.
Zone safe coords are x = 181; y = 335; z= -248
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for freportw ...
[Status] Done loading doors for freportw ...
[Status] Zone Bootup: freportw (9)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [10:08 am]
[Status] 191906 New client from ip:127.0.0.1 port:3272
Error in FinishConnState2(): !dbaq[1]->GetAnswer(): #1054: Unknown column 'revok
ed' in 'field list'
Client disconnected (cs=e): Sark
Dropping client: Process=false, ip=127.0.0.1, port=3272
[Status] Zone Shutdown: freportw (9)

that looks like a database error, looks like all your .ini and .exe files are ok now though. Sorry i don't know much about MySQL :)

Maybe someone else will post a possible solution to this, one thing you might try is to delete your "eq" database and recreate it again.

*sigh* ok I will give it a try so all I need to do is repeat the steps of setting up a server but just the database right?
Or do I just need to recreate the mysql db that I made with the cmd line?

(Arg guess I will have to recreate my items, oh well)

Go into c:\mysql\data and delete the "eq" folder, then follow the steps here http://www.eqemulator.net/forums/viewtopic.php?t=13403 from where it says:

Code:

create database eq;

for creating the database

sorry for asking so many questions but I know there are alot of Dbs out there to create the mysql one with which do you use?

now I am getting a 1017 error, I believe this is a problem with loading the db I just loaded but before I try loading the one you gave me maybe you could confirm it for me here is what happens that I believe causes the 1017 [Status] Using database 'eq' at localhost

Quote:

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.5-DR1
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=26679, max id=68199
[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
Screwing up windows compiles...
TCP listening on: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
Connected to LoginServer: 127.0.0.1 :5997
4985 New TCP connection: 127.0.0.1:4006
New zoneserver: #1 127.0.0.1:4006
5047 New TCP connection: 127.0.0.1:4007
5047 New TCP connection: 127.0.0.1:4008
New zoneserver: #2 127.0.0.1:4008
New zoneserver: #3 127.0.0.1:4007
Zoneserver SetConnectInfo: 127.0.0.1:4006: 127.0.0.1:7996
Zoneserver SetConnectInfo: 127.0.0.1:4007: 127.0.0.1:7997
Zoneserver SetConnectInfo: 127.0.0.1:4008: 127.0.0.1:7995
5141 New TCP connection: 127.0.0.1:4009
5141 New TCP connection: 127.0.0.1:4010
New zoneserver: #4 127.0.0.1:4010
New zoneserver: #5 127.0.0.1:4009
Zoneserver SetConnectInfo: 127.0.0.1:4009: 127.0.0.1:7999
Zoneserver SetConnectInfo: 127.0.0.1:4010: 127.0.0.1:7998
39985 New client from ip: 127.0.0.1 port: 4013
Error in CheckLogin query 'SELECT id, status FROM account WHERE name='eqemu' AND
(password='eqemu' or password=MD5('eqemu'))' #1146: Table 'eq.account' doesn't
exist
127.0.0.1: Wrong name/pass: name='eqemu'
Removing client from ip:127.0.0.1 port:4013
error

I would try manually adding your account into the db if it is not in there and if it is then delete your account.

um I wouldnt know how to do that so i am trying the Db you gave me, do you have any Idea where that thread is that lists the best Dbs for now? I am looking for 1 that has items on merchants and other such things, I know some servers have that and some dont does this one have that in it?

The one she gave you is the best one you will find at the moment