Zone server disconnect

[Sarkamen]

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

[Jezebell]

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

[Sarkamen]

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

[Jezebell]

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

start zone . 127.0.0.1 7995 127.0.0.1

not like this:

start zone . 127.0.0.1 7995 YourIP

[Sarkamen]

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

[Sarkamen]

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

[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)

[Jezebell]

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.

[Sarkamen]

*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)

[Jezebell]

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:

 create database eq;

for creating the database

[Sarkamen]

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?

[Jezebell]

This is the one I use.

http://mwnpcmovdb.myftp.org/MW055_alpha_02.zip

[Sarkamen]

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

[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

[Jezebell]

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

[Sarkamen]

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?

[nilar]

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