EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)
-   -   npc_faction_update.sql and npc_types_update.sql Errors (https://www.eqemulator.org/forums/showthread.php?t=14418)

stclairguy 06-18-2004 11:47 AM

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.

nadr man 06-18-2004 12:45 PM

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.

wize_one 06-18-2004 12:47 PM

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..

nadr man 06-18-2004 12:55 PM

which db would you suggest?

stclairguy 06-18-2004 01:41 PM

I have the newest DB release, and have also tried using it under a fresh un-sourced DB. DOesn't work.

wize_one 06-18-2004 06:07 PM

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

monalin crusader 06-19-2004 05:13 AM

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.


All times are GMT -4. The time now is 10:18 PM.

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