EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)
-   -   dbs.. (https://www.eqemulator.org/forums/showthread.php?t=10345)

Freshmaster17uk 11-18-2003 10:42 AM

dbs..
 
hi im using eqemu 5.0 having some probs with dbs ect can anybody post what dbs will work with 5.0 and what order i have to source them into mysql.. thanks

Kgaul 11-18-2003 11:15 AM

source this and watch for udates.

http://www.everquestserver.com/forum...=10890&start=0


Kgaul

arkaria 11-18-2003 11:26 AM

Once you download and source the DB that Kgaul pointed you tovards.

Source this as well http://www.everquestserver.com/forum...ic.php?t=11161

This is an update for that DB

Freshmaster17uk 11-18-2003 01:11 PM

ok
 
before all that do i have to source db.sql too and all them other files , sometimes i keep getting item errors and no spawns

Freshmaster17uk 11-18-2003 01:29 PM

did what u guys said
 
ok i sourced them files created a charactor when i try login its saying zone not avaiable i get following errors :

world.exe says

Logged in: Local: eqemu
Received unknown opcode: 0x02d2 size:0 bytes
Name approval request for:Master race:1 class:4
Choice:1
[Error] Database: could not find start_zones entry in database. Using Defaults..

Char create:Master
Attempting autobootup of qeynos2 (2) for Master
Zoneserver SetZone: localhost:7995 (0)
Zoneserver SetZone: localhost:7995 (0)
Received unknown opcode: 0x02d2 size:0 bytes
Attempting autobootup of qeynos2 (2) for Master
Zoneserver SetZone: localhost:7998 (0)
Zoneserver SetZone: localhost:7998 (0)
Received unknown opcode: 0x02d2 size:0 bytes
Received unknown opcode: 0x00e7 size:0 bytes
Client disconnected
Removing client from ip:127.0.0.1 port:3199

one of the boot5zones.exe says

Logged in: Local: eqemu
Received unknown opcode: 0x02d2 size:0 bytes
Name approval request for:Master race:1 class:4
Choice:1
[Error] Database: could not find start_zones entry in database. Using Defaults..

Char create:Master
Attempting autobootup of qeynos2 (2) for Master
Zoneserver SetZone: localhost:7995 (0)
Zoneserver SetZone: localhost:7995 (0)
Received unknown opcode: 0x02d2 size:0 bytes
Attempting autobootup of qeynos2 (2) for Master
Zoneserver SetZone: localhost:7998 (0)
Zoneserver SetZone: localhost:7998 (0)
Received unknown opcode: 0x02d2 size:0 bytes
Received unknown opcode: 0x00e7 size:0 bytes
Client disconnected
Removing client from ip:127.0.0.1 port:3199

Freshmaster17uk 11-18-2003 01:31 PM

on and
 
and another says

[Status] Weather should change in 12058 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

rest are all fine seems like a db problem ?

Chrysm 11-18-2003 03:34 PM

No, you don't source the db.sql at all. You start out with a blank databse named eq and source those two files into it. I learned that hard way till hours of searching lead me to a post where the maker of the db asys do not source db.sql... just those two.

Freshmaster17uk 11-18-2003 04:26 PM

...
 
now i just gotta figure out them errors im getting

CoDown 11-18-2003 10:14 PM

Re: ...
 
Quote:

Originally Posted by Freshmaster17uk
now i just gotta figure out them errors im getting


Am having the same prob and know not what to do to get past it.

Freshmaster17uk 11-19-2003 08:16 AM

......
 
surely somebody knows! come on post post post we need ya helpz

CoDown 11-19-2003 08:24 AM

After Reading a few posts in other topics, it looks as tho we will have to wait for the next for the next DB Update from TCS

arkaria 11-19-2003 08:58 AM

TCS' alph3_3 DB + the update works fine for me. The 2 links up at the begining of this thread.

Freshmaster17uk 11-19-2003 09:00 AM

......
 
mayby just the one i downloaded before could be corrupt ? ill re download see wat happens ..... wish me luck

CoDown 11-19-2003 10:37 AM

I tried the db's from the links on this page and they worked perfectly.
Thanks for the help

Kgaul 11-19-2003 02:37 PM

You might be having a NAT error. there is a post somewhere about NAT config...

Made all the difference in my server.

Kgaul


All times are GMT -4. The time now is 03:12 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.