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 06-18-2004, 11:47 AM
stclairguy
Fire Beetle
 
Join Date: Mar 2004
Posts: 28
Default npc_faction_update.sql and npc_types_update.sql Errors

Quote:
ERROR 1064: You have an error in your SQL syntax near ' spawn2, spaw
pc_types.loottable_id = 15303 WHERE npc_types.name like' at line 1
Posted this in its appropriate place, but got no reply or anything, so i'll post it here as well in case someone missed it. I'm getting the above error when sourcing these two SQL's when trying to add loot tables and faction tables to my DB. I'm using the newest MYSQL and just got those files fresh yesterday. Any solutions or ideas? From what i understand so far, this is an error with the sql. Hope someone can clear this up for me.
Reply With Quote
  #2  
Old 06-18-2004, 12:45 PM
nadr man
Sarnak
 
Join Date: Feb 2004
Posts: 37
Default

i get the same problem. Making a clean, seperate db i get the same errors (5 in total, 4 errors besides the one that's "ok"). I can't find a way to get around it. I would also appreciate any help on this.
Reply With Quote
  #3  
Old 06-18-2004, 12:47 PM
wize_one
Dragon
 
Join Date: Jan 2004
Location: LasShithole, NV
Posts: 520
Default

more then likely your trying to put govtcheezes addon over an older db.. and or your running someone elses sql that is not compatible..

databases are not plug and play.. no 2 are the same(well cept when ya first get it) everyone makes changes..
__________________
Perfect quote from another site: it's immature pricks who refuse to read the numerous stickies in every forum pointing out what to do and what not to do that get flamed. Grow up and learn to do your fucking homework before opening your cake hole, junior. EQEmu doesn't like you anymore, and that's why you're getting errors. So go away.
__________________
Reply With Quote
  #4  
Old 06-18-2004, 12:55 PM
nadr man
Sarnak
 
Join Date: Feb 2004
Posts: 37
Default

which db would you suggest?
Reply With Quote
  #5  
Old 06-18-2004, 01:41 PM
stclairguy
Fire Beetle
 
Join Date: Mar 2004
Posts: 28
Default

I have the newest DB release, and have also tried using it under a fresh un-sourced DB. DOesn't work.
Reply With Quote
  #6  
Old 06-18-2004, 06:07 PM
wize_one
Dragon
 
Join Date: Jan 2004
Location: LasShithole, NV
Posts: 520
Default

www.projecteq.net in the downloads section.. source that one only fire your emu and see how it goes.. then try govtcheeze's update on it.. not sure wich version he has up atm.. it might not be a compatible version
__________________
Perfect quote from another site: it's immature pricks who refuse to read the numerous stickies in every forum pointing out what to do and what not to do that get flamed. Grow up and learn to do your fucking homework before opening your cake hole, junior. EQEmu doesn't like you anymore, and that's why you're getting errors. So go away.
__________________
Reply With Quote
  #7  
Old 06-19-2004, 05:13 AM
monalin crusader
Hill Giant
 
Join Date: May 2004
Posts: 238
Default

What you have to do is save it to a file and source it or type it in just copying it wont do anything because the max amout of characters at a time is less than what needs to be copied so it cuts part of it off. Just save everything to faction_update.sql or something.
__________________
Ascending Dawn Server Op
Coder/Quester/Mysql
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 02:57 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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3