PDA

View Full Version : "Enter World" Problem


McFox666
11-03-2004, 03:24 PM
Hi there,
I'm new and trying to make my own server.
I have installed everything needed (DB 6.0RD1), and first I try to make the server working in local, with the minilogin.

Here it is my LocalServer.ini :

[LoginServer]
loginserver=127.0.0.1
#loginserver2=eqlogin1.eqemulator.net
loginport=5999
#loginport2=5994
worldname=Chevaliers du Dragon Blanc - WIP
worldaddress=127.0.0.1
locked=false
account=
password=

[LoginConfig]
ServerMode=MiniLogin
ServerPort=5999

[WorldServer]
Defaultstatus=0
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

And here is my Boot5zones.bat :
REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "localhost" 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 . 127.0.0.1 8780 127.0.0.1
start zone . 127.0.0.1 8781 127.0.0.1
start zone . 127.0.0.1 8782 127.0.0.1
start zone . 127.0.0.1 8783 127.0.0.1
start zone . 127.0.0.1 8784 127.0.0.1
exit
cls

:NOSPELL
echo You did not copy the spells_us.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------

The Minilogin ran, World.exe ran, the five Zone.exe ran...
Everything seems to be OK.

I log, I see my server on the server screen and log on, I make my caracter (Paladin, Human, Karana so @ Qeyenos)

But when I try to Enter World and play... it crash and return to the Server Select Screen...

WTF :s ?

Oh... the world.exe say that :

[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=36965
[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
Assassinating people that whine about horses...done
TCP listening on: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
Setting World to MiniLogin Server type
Connected to LoginServer: 127.0.0.1:5999
200484 New TCP connection: 127.0.0.1:4929
200484 New TCP connection: 127.0.0.1:4930
200484 New TCP connection: 127.0.0.1:4931
200484 New TCP connection: 127.0.0.1:4932
200484 New TCP connection: 127.0.0.1:4933
New zoneserver: #1 127.0.0.1:4933
New zoneserver: #2 127.0.0.1:4932
New zoneserver: #3 127.0.0.1:4931
New zoneserver: #4 127.0.0.1:4930
New zoneserver: #5 127.0.0.1:4929
Zoneserver SetConnectInfo: 127.0.0.1:4929: 127.0.0.1:8784
Zoneserver SetConnectInfo: 127.0.0.1:4930: 127.0.0.1:8781
Zoneserver SetConnectInfo: 127.0.0.1:4931: 127.0.0.1:8783
Zoneserver SetConnectInfo: 127.0.0.1:4932: 127.0.0.1:8782
Zoneserver SetConnectInfo: 127.0.0.1:4933: 127.0.0.1:8780
236953 New client from ip: 127.0.0.1 port: 4935
Logged in: FirstLogin Account #1: McFox
Received unknown opcode: 0x02eb size:0 bytes
Read group ID for 'Mcfox': 0
0: 2C 30 2C 2E 4D 63 66 6F - 78 2C 30 36 37 61 37 39 | ,0,.Mcfox,067a79
16: 64 34 00 | d4.
Attempting autobootup of Qeynos (1) for Mcfox
Zoneserver SetZone: 127.0.0.1:8784 Qeynos (1)
Enter world: Mcfox: Qeynos (1)
Zoneserver SetZone: 127.0.0.1:8784 Qeynos (1)
Received unknown opcode: 0x0376 size:0 bytes
Client disconnected
Removing client from ip:127.0.0.1 port:4935
Zoneserver SetZone: 127.0.0.1:8784 (0)
Zoneserver SetZone: 127.0.0.1:8784 (0)

and the Zone.exe which load the qeynos zone say that :

[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-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] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 6299
[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] 171 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000
Map ./Maps/qeynos.map not found.
[Status] Weather should change in 7632 seconds
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 1; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for qeynos ...
[Status] Done loading doors for qeynos ...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
[Status] Zone Bootup: Qeynos (1)
[Status] 97515 New client from ip:127.0.0.1 port:4938
Error in FinishConnState2(): !dbaq[1]->GetAnswer(): #1054: Unknown column 'revok
ed' in 'field list'
Client disconnected (cs=e): Mcfox
Dropping client: Process=false, ip=127.0.0.1, port=4938
[Status] Zone Shutdown: qeynos (1)

McFox666
11-03-2004, 10:15 PM
help :< :worship:

Derision
11-03-2004, 10:28 PM
Unknown column 'revoked' in 'field list'


Well, this may indicate that you do not have the 'revoked' field in your account table, which you can try to fix with:

ALTER TABLE `account` ADD `revoked` TINYINT(3) UNSIGNED DEFAULT "0" NOT NULL;

However, the revoked field has been in the database for a long time, so it is odd that it is missing in your DB.

McFox666
11-04-2004, 07:08 AM
Unknown column 'revoked' in 'field list'


Well, this may indicate that you do not have the 'revoked' field in your account table, which you can try to fix with:

ALTER TABLE `account` ADD `revoked` TINYINT(3) UNSIGNED DEFAULT "0" NOT NULL;

However, the revoked field has been in the database for a long time, so it is odd that it is missing in your DB.

Many thx ! It works ^^

RangerDown
11-04-2004, 09:59 AM
Curious, where'd you get your database from? Since revoked has been in there for some time, you might want to let your source know they need to update their db before they distribute any more :P