PDA

View Full Version : npc_faction_update.sql and npc_types_update.sql Errors


stclairguy
06-18-2004, 11:47 AM
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.