Question for Mysql menu

User Tag List

Results 1 to 3 of 3
  1. #1
    xAnGelx Toodlez's Avatar Member
    Reputation
    14
    Join Date
    Jan 2007
    Posts
    179
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question for Mysql

    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.

    Question for Mysql
  2. #2
    project anthrax's Avatar Contributor
    Reputation
    180
    Join Date
    Nov 2007
    Posts
    993
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    it means that the script isnt writen out the correct way
    removed by Unholy

  3. #3
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    try:
    Code:
    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

Similar Threads

  1. "Pointer" question for CE
    By vivec45 in forum World of Warcraft General
    Replies: 2
    Last Post: 08-13-2007, 02:31 AM
  2. Question for faces
    By Orcanos in forum WoW ME Questions and Requests
    Replies: 5
    Last Post: 05-29-2007, 04:45 AM
  3. A question for 1337-$p34k3R5
    By I8l33t in forum Community Chat
    Replies: 9
    Last Post: 04-10-2007, 12:37 PM
  4. a question for those rogues
    By former in forum World of Warcraft General
    Replies: 2
    Last Post: 03-10-2007, 03:00 PM
  5. Pet question for a noob
    By trinity_eck in forum World of Warcraft General
    Replies: 1
    Last Post: 12-27-2006, 06:24 PM
All times are GMT -5. The time now is 03:04 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search