Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Development > Archive::Database/World Building

Archive::Database/World Building Archive area for General Discussion's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 11-18-2003, 10:42 AM
Freshmaster17uk
Sarnak
 
Join Date: Mar 2003
Location: London UK
Posts: 36
Default 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
Reply With Quote
  #2  
Old 11-18-2003, 11:15 AM
Kgaul
Hill Giant
 
Join Date: Apr 2003
Posts: 225
Default

source this and watch for udates.

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


Kgaul
Reply With Quote
  #3  
Old 11-18-2003, 11:26 AM
arkaria's Avatar
arkaria
Discordant
 
Join Date: Oct 2003
Location: Victoria, BC
Posts: 253
Default

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
Reply With Quote
  #4  
Old 11-18-2003, 01:11 PM
Freshmaster17uk
Sarnak
 
Join Date: Mar 2003
Location: London UK
Posts: 36
Default 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
Reply With Quote
  #5  
Old 11-18-2003, 01:29 PM
Freshmaster17uk
Sarnak
 
Join Date: Mar 2003
Location: London UK
Posts: 36
Default 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
Reply With Quote
  #6  
Old 11-18-2003, 01:31 PM
Freshmaster17uk
Sarnak
 
Join Date: Mar 2003
Location: London UK
Posts: 36
Default 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 ?
Reply With Quote
  #7  
Old 11-18-2003, 03:34 PM
Chrysm
Sarnak
 
Join Date: Oct 2002
Location: New Orleans, LA
Posts: 71
Default

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.
Reply With Quote
  #8  
Old 11-18-2003, 04:26 PM
Freshmaster17uk
Sarnak
 
Join Date: Mar 2003
Location: London UK
Posts: 36
Default ...

now i just gotta figure out them errors im getting
Reply With Quote
  #9  
Old 11-18-2003, 10:14 PM
CoDown
Fire Beetle
 
Join Date: Oct 2002
Posts: 3
Default 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.
Reply With Quote
  #10  
Old 11-19-2003, 08:16 AM
Freshmaster17uk
Sarnak
 
Join Date: Mar 2003
Location: London UK
Posts: 36
Default ......

surely somebody knows! come on post post post we need ya helpz
Reply With Quote
  #11  
Old 11-19-2003, 08:24 AM
CoDown
Fire Beetle
 
Join Date: Oct 2002
Posts: 3
Default

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
Reply With Quote
  #12  
Old 11-19-2003, 08:58 AM
arkaria's Avatar
arkaria
Discordant
 
Join Date: Oct 2003
Location: Victoria, BC
Posts: 253
Default

TCS' alph3_3 DB + the update works fine for me. The 2 links up at the begining of this thread.
Reply With Quote
  #13  
Old 11-19-2003, 09:00 AM
Freshmaster17uk
Sarnak
 
Join Date: Mar 2003
Location: London UK
Posts: 36
Default ......

mayby just the one i downloaded before could be corrupt ? ill re download see wat happens ..... wish me luck
Reply With Quote
  #14  
Old 11-19-2003, 10:37 AM
CoDown
Fire Beetle
 
Join Date: Oct 2002
Posts: 3
Default

I tried the db's from the links on this page and they worked perfectly.
Thanks for the help
Reply With Quote
  #15  
Old 11-19-2003, 02:37 PM
Kgaul
Hill Giant
 
Join Date: Apr 2003
Posts: 225
Default

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

Made all the difference in my server.

Kgaul
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 11:03 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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3