Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

Reply
 
Thread Tools Display Modes
  #1  
Old 11-03-2004, 03:24 PM
McFox666
Sarnak
 
Join Date: Nov 2004
Posts: 62
Default "Enter World" Problem

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 :

Code:
[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 :
Code:
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 :

Code:
[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 :

Code:
[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)
Reply With Quote
  #2  
Old 11-03-2004, 10:15 PM
McFox666
Sarnak
 
Join Date: Nov 2004
Posts: 62
Default

help :< :worship:
Reply With Quote
  #3  
Old 11-03-2004, 10:28 PM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default Re: "Enter World" Problem

Quote:
Originally Posted by McFox666
Code:
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:

Code:
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.
Reply With Quote
  #4  
Old 11-04-2004, 07:08 AM
McFox666
Sarnak
 
Join Date: Nov 2004
Posts: 62
Default Re: "Enter World" Problem

Quote:
Originally Posted by Derision
Quote:
Originally Posted by McFox666
Code:
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:

Code:
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 ^^
Reply With Quote
  #5  
Old 11-04-2004, 09:59 AM
RangerDown
Demi-God
 
Join Date: Mar 2004
Posts: 1,066
Default

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
__________________
<idleRPG> Rogean ate a plate of discounted, day-old sushi. This terrible calamity has slowed them 0 days, 15:13:51 from level 48.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 10:04 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3