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.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 02-11-2004, 02:02 PM
Timothius
Fire Beetle
 
Join Date: Jan 2002
Posts: 5
Default

Quote:
Originally Posted by wize_one
need a little help here..(wanting to see the good work i keep hearing about)

following the readme
Quote:
To use this: (new installation for server)

source the db.sql file that came with eqemu, if you don't have it you can download it from my web site
source the items db from eqemu
source MyraDB.sql
source MyraItems.sql (you may see some duplicate entry errors with this, it is OK to ignore them)
i do the:
db.sql(no probs)
dumpeditems.sql(no probs)
myra(get errors)

looking at it,
Quote:
INSERT INTO npc_types VALUES (11312,'#an_apparition_of_dust',NULL,67,210,1,0,54 40,2,0,0,0,2,0,11900,0,0,0,75,249,'',0,65,0,0,0,0, 0,0,0,0,0,250,250,25,25,25,25,25,0,0,1,0);
there are 43 fields, standard db(without jan24 patch) has 40, with jan24 patch only 42. what needs to be added to fix the errors?

I didnt have this exact problem, but I did have a problem with the npc_types table, where 'lastname' was set to be not null, and mysql was freaking out on every npc. I just changed the column to allow for null and it works great! This is one of the best databases that I have used to date, GREAT work Myra!

Timothius the Ultra Lurker
Reply With Quote
 


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 01:06 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