erros in MySql

Code:

---

npc data couldnt be stored in db, query is :UPDATE npc SET patk='7580' mdef='217
0' atkspd='500' matk='4700' pdef='2350' WHERE id=12372 :java.sql.SQLException: Y
ou have an error in your SQL syntax; check the manual that corresponds to your M
ySQL server version for the right syntax to use near 'mdef='2170' atkspd='500' m
atk='4700' pdef='2350' WHERE id=12372' at line 1
NpcTable: Loaded 3751 Npc Templates.

---

why? how can i resolve the problem???
thanks for help

hmm have you tried change one parametr at once ?

Quote:

---

Originally Posted by Peter_PL

hmm have you tried change one parametr at once ?

---

i try to change with a gm char....

Are you using a script to do this? if yes lemme see it apparantly something is wrong with it.

there was a problem with //edit_npc eariler now should be fixed with updated revision, if u didn't update just edit the first in-game then reboot the server the changes will apply after reboot