Question for Mysql

[xAnGelx Toodlez]

Well here is the problem. for the WOTLK realm, when the Teleporter, When we try to execute it, we get this Error.


[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('x', 'y', 'z', 'o', 'datalong') values ('647.150635', '-324.323486', '25.766462' at line 1



Our mysql we are using is.


UPDATE quest_end_scripts set ('x', 'y', 'z', 'o', 'datalong') values ('647.150635', '-324.323486', '25.766462', '0.349177', '571') WHERE id=91211 and delay=0 and command=6 and datalong=1 and datalong2=0 and datatext=NULL and x=-2881.32 and y=1886.94 and z=526001 and o=2.71651 LIMIT 1


Any idea's? Any comments, Would be helpful.

[project anthrax]

it means that the script isnt writen out the correct way

[latruwski]

try:

UPDATE quest_end_scripts set x= 647.150635,y =-324.323486, z=25.766462,o=0.349177,datalong=571 WHERE id=91211 and delay=0 and command=6 and datalong=1 and datalong2=0 and datatext=NULL and x=-2881.32 and y=1886.94 and z=526001 and o=2.71651 LIMIT 1;

grtz