dbs.. - Page 2

Tinv · #16 11-20-2003, 06:02 AM

Having the exact same problem.

if I :
create database eq;
use eq;
source db.sql
then
everything works fine. No mobs, loot, spawns.... obviously. But i can get in and walk around.

if i:
create database eqtcm;
use eqtcm;
source MWnpcmovDB_050_alpha0_3_3.sql
source 050_item_object_update.sql
"optional next line, i've tried it with and without"
source dumpeditems.sql
then
I can get up to the char select screen create a character but when i try to get that character in i immediatly get "That zone is not Available"

The output in World.exe and the Zone.exe handling the character are pretty much identical to what the other poster recieved.

Am i going about this wrong? I've trolled here for a few hours and tried everything i came acrossed.

Any ideas?

Kgaul · #17 11-20-2003, 10:31 AM

please post your .ini's, might be in the IP config or in the Batzone... If your set up right you might also be having a NAT error. There is a wonderful No-name.org trick that shortcuts the NAT error...

http://www.everquestserver.com/forum...pic.php?t=4177

Kgaul

Tinv · #18 11-20-2003, 10:41 AM

db.ini :

[Database]
host=localhost
user=tinv
password=tinv
database=eq
compression=off

loginserver.ini :

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginport=5997
worldname=menzoberranzan
locked=false
worldaddress=68.36.223.6

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

boot5zone.bat :

@echo off

if NOT exist spells_en.txt goto NOSPELL

start zone . 68.36.223.6 7995 68.36.223.6
start zone . 68.36.223.6 7996 68.36.223.6
start zone . 68.36.223.6 7997 68.36.223.6
start zone . 68.36.223.6 7998 68.36.223.6
start zone . 68.36.223.6 7999 68.36.223.6
exit
cls

The only thing i change is the database name from eq to eqtcm depending on what one i want to try.

Chrysm · #19 11-20-2003, 10:46 AM

did you world adduser eqemu eqemu 200?
I had the same problems and I think that fixed it

Tinv · #20 11-20-2003, 10:59 AM

Will give that a shot right away......
That zone is not available
:twisted:

Chrysm · #21 11-20-2003, 11:05 AM

If that doesn't work, I forgot how to fix it.
Be sure that when you add that account, it's to the new one that you make "DWMnpc_blah.sql" one

Chrysm · #22 11-20-2003, 11:06 AM

Try downloading the database directly from his website and sourcing the update then add the account and try. I am almost positive that's the problem.

Tinv · #23 11-20-2003, 11:08 AM

Am doin that sa i type am currently sourcing =)

Tinv · #24 11-20-2003, 11:22 AM

No Go =/

Heres the World.exe window :

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=25924, max id=68199
[Status] LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Please don't make me a levelme server. :(
TCP listening on: 68.36.223.6:9000
World server listening on: 68.36.223.6:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997
7981 New TCP connection: 68.36.223.6:2513
7981 New TCP connection: 68.36.223.6:2514
7981 New TCP connection: 68.36.223.6:2515
7981 New TCP connection: 68.36.223.6:2516
New zoneserver: #1 68.36.223.6:2516
New zoneserver: #2 68.36.223.6:2515
New zoneserver: #3 68.36.223.6:2514
New zoneserver: #4 68.36.223.6:2513
Zoneserver SetConnectInfo: 68.36.223.6:2513: 68.36.223.6:7995
Zoneserver SetConnectInfo: 68.36.223.6:2514: 68.36.223.6:7998
Zoneserver SetConnectInfo: 68.36.223.6:2515: 68.36.223.6:7997
Zoneserver SetConnectInfo: 68.36.223.6:2516: 68.36.223.6:7999
8031 New TCP connection: 68.36.223.6:2517
New zoneserver: #5 68.36.223.6:2517
Zoneserver SetConnectInfo: 68.36.223.6:2517: 68.36.223.6:7996
66085 New client from ip: 68.36.223.6 port: 2520
Account Attempting to be created:Tinv 0
Logged in: FirstLogin LS#38090: Tinv
Received unknown opcode: 0x02d2 size:0 bytes
Name approval request for:Tinvarien race:7 class:4
Choice:1
[Error] Database: could not find start_zones table in database. Using Defaults..

Char create:Tinvarien
Attempting autobootup of qeynos2 (2) for Tinvarien
Zoneserver SetZone: 68.36.223.6:7995 (0)
Zoneserver SetZone: 68.36.223.6:7995 (0)
Received unknown opcode: 0x02d2 size:0 bytes

Heres the zone window that took the call :

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.0
[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] FileLoadSPDat() Loading spells from spells_us.txt
[Status] FileLoadSPDat() spells loaded: 4352
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 148 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 68.36.223.6:9000
[Status] Weather should change in 5432 seconds
Init: Loading zone listsError1 in PopulateZoneLists query 'SELECT x,y,z,target_x
,target_y,target_z,target_zone,heading,target_head ing,number FROM zone_points WH
ERE zone='qeynos2' order by number' #1054: Unknown column 'heading' in 'field li
st'
ERROR: Couldn't load zone lists.
Zone->Init failed

So to recap.

create database eqtest;
use eqtest;
source DWMnpc_blah.sql
source DWMnpc_update_050..blah.sql
exit

edit db.ini
changed the database line to
database=eqtest
go to command prompt to eqemu directory

world adduser eqemu eqemu 200

close command prompt.

click on world
click on boot5zone.bat

open eq and....

after creating newbie 1 ranger
and clicking on enter
That zone is not available =/

Did i miss anything?

Again. if i follow these exact steps but only source the db.sql from eqemu i enter the world fine.

/boggle

arkaria · #25 11-20-2003, 11:25 AM

Did you grant the proper mysql permisions to the database eqtest for the user tinv@localhost?

Tinv · #26 11-20-2003, 11:37 AM

ruh roh i think ya got me.. that one went soaring over my skullcap.. let me go search around for exactly what you are talking about

#27 11-20-2003, 11:40 AM

Quote:

[Error] Database: could not find start_zones table in database. Using Defaults..

Thats what cought my attention, Ma be a bad DB. In the past when i had DB issues i re-downloaded the DB and reinstalled. It is a common error for the SQL file to become currupted when unzipping, i know of many cases of this.

EDIT

Quote:

Init: Loading zone listsError1 in PopulateZoneLists query 'SELECT x,y,z,target_x
,target_y,target_z,target_zone,heading,target_head ing,number FROM zone_points WH
ERE zone='qeynos2' order by number' #1054: Unknown column 'heading' in 'field li
st'
ERROR: Couldn't load zone lists.
Zone->Init failed

that would be the result of the first error i pointed out.

arkaria · #28 11-20-2003, 11:44 AM

Not sure what guide you've been following. The following guide is out dated but the commands you need to configure mysql are still valid.

http://www.eqemu.net/Guide.htm

Tinv · #29 11-20-2003, 11:54 AM

ok redownloaded both archives by following post # 2 and 3 from this thread.

and am following http://www.eqemu.net/Guide.htm
to the "T".

arkaria · #30 11-20-2003, 12:13 PM

Just make sure not to use the eqhost.txt specified in that guide as it is for v4.4 servers. Everything else pretty much should still aplly.