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
  #25  
Old 05-27-2002, 02:33 PM
bot403
Sarnak
 
Join Date: May 2002
Posts: 52
Default not to bash your hard work....

but it doesnt work. THere i said it, now let me be more descriptive. I am using Linux and MySQL 3.23.47 and i get errors that are rampant and they go like this
ERROR 1062 at line 3812 in file: 'merchantlist.txt': Duplicate entry '246-29' fo
r key 1

I assume something is wrong with the way the tables are defined? i dont know enough to fix it. The faction list also had lots of errors and i tried removing the unique tag on the name key and that SEEMED to work, i have yet to find a database that will fully import. Are you all using MS Sql or what? cause i have yet to find a database file that is compatible with my mysql database. If you give me some pointers on whats wrong maybe i can be of assistance for correcting these databases.

*EDIT*
P.S. some of it seems to be tpyos, like this

INSERT INTO merchantlist VALUES (244,24,131; # bone gloves
INSERT INTO merchantlist VALUES (244,25,4317); # dark scale greaves
INSERT INTO merchantlist VALUES (244,26,6404); # staff of writhing
INSERT INTO merchantlist VALUES (244,27,1355); # robe of enshroudment
INSERT INTO merchantlist VALUES (244,28,11666); # bone girdle
INSERT INTO merchantlist VALUES (246,29,10357); # ring of shadows

I assume that last 246 meant to be a 244 because they all seem to be grouped like that

also some appear like this

INSERT INTO merchantlist VALUES (252,12,2703); # griffon wing spaulders
INSERT INTO merchantlist VALUES (252,13,29063); # ring of the chameleon
INSERT INTO merchantlist VALUES (252,14,10336); # platinum armband
INSERT INTO merchantlist VALUES (252,13,1981; # symbol of Rodcet
INSERT INTO merchantlist VALUES (252,14,5366); # Kilij

where that second identifier is repeated(13 in this case) ive been trying to shift the whole group down to look like this

INSERT INTO merchantlist VALUES (252,12,2703); # griffon wing spaulders
INSERT INTO merchantlist VALUES (252,13,29063); # ring of the chameleon
INSERT INTO merchantlist VALUES (252,14,10336); # platinum armband
INSERT INTO merchantlist VALUES (252,15,1981; # symbol of Rodcet
INSERT INTO merchantlist VALUES (252,16,5366); # Kilij

etc. etc...
can anyone tell me if this will break some sort of identifier dependency somewhere else in the database. I am only 7 hours new to eqemu and dont quite know how the database tables are supposed to relate to one another.
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 04:42 PM.


 

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