Batch Problem menu

Shout-Out

User Tag List

Results 1 to 12 of 12
  1. #1
    Strupantwn's Avatar Contributor
    Reputation
    115
    Join Date
    Apr 2007
    Posts
    1,045
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Batch Problem

    When I tried to batch my GameObject_Spawns SQL from the backup
    I got this error


    Code:
    [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 '"gameobject_spawns" ("id", "Entry", "map", "position_x", "position_y", "position' at line 1
    [Err] INSERT INTO "gameobject_spawns" ("id", "Entry", "map", "position_x", "position_y", "position_z", "Facing", "orientation1", "orientation2", "orientation3", "orientation4", "State", "Flags", "Faction", "Scale", "stateNpcLink") VALUES
        ('1','31','0','-9253.08','-3404.9','104.348','0.547548','0.014522','-0.044873','0.27015','0.961662','1','0','0','0.63','0');
    [Msg] Finished - Unsuccessfully
    --------------------------------------------------

    Here is the SQL file


    GameObject_Spawns.SQL

    What I am thinking is that the batch file colums does not match the
    ones in my table? if that is the problem, will someone make a table that I
    can execute this Batch file into?

    WILL REP ofc.

    Batch Problem
  2. #2
    lilbdiablo12's Avatar Active Member
    Reputation
    40
    Join Date
    Feb 2008
    Posts
    535
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try putting spaces after the comas, that worked for me lol... not sure why though, other then that i dont see a problem, count your contents and see if it matchs

  3. #3
    Strupantwn's Avatar Contributor
    Reputation
    115
    Join Date
    Apr 2007
    Posts
    1,045
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It matches I think but putting comas on everyone of them? there is over like 10000 lines in there for me to do then =_=

  4. #4
    Aznex's Avatar Contributor
    Reputation
    128
    Join Date
    Feb 2008
    Posts
    770
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    or do a change all ," to , "

  5. #5
    Strupantwn's Avatar Contributor
    Reputation
    115
    Join Date
    Apr 2007
    Posts
    1,045
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    How do I do that?
    But the problem is we don't know it yet (The Batch error)

  6. #6
    lilbdiablo12's Avatar Active Member
    Reputation
    40
    Join Date
    Feb 2008
    Posts
    535
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Im still with the comas, do the spaces see if that works, as for the 1000 lines, thats gatta suck lol

  7. #7
    Strupantwn's Avatar Contributor
    Reputation
    115
    Join Date
    Apr 2007
    Posts
    1,045
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I don't think I will try the comas because uhh there are 10000 lines lol

    I ma see if another people here know what the problem is.

  8. #8
    Strupantwn's Avatar Contributor
    Reputation
    115
    Join Date
    Apr 2007
    Posts
    1,045
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    BuMP?
    Filler

  9. #9
    Aznex's Avatar Contributor
    Reputation
    128
    Join Date
    Feb 2008
    Posts
    770
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Change the commas by opening your sql file in for example notepad, and press ctrl + h

  10. #10
    Strupantwn's Avatar Contributor
    Reputation
    115
    Join Date
    Apr 2007
    Posts
    1,045
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Mind changing it real quick for me then upload it? I am a true dumbass when it comes to these kind of things, don't want to **** it up.

    I have uploaded the SQL in the first post.

    Thanks aznex

  11. #11
    Strupantwn's Avatar Contributor
    Reputation
    115
    Join Date
    Apr 2007
    Posts
    1,045
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Bump
    filler

  12. #12
    Aznex's Avatar Contributor
    Reputation
    128
    Join Date
    Feb 2008
    Posts
    770
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Meh theres just alot of stuff wrong with it, not even worth changing it all >_<
    takes forever with such a big file

Similar Threads

  1. Problem with CE.
    By Eldretch in forum World of Warcraft General
    Replies: 1
    Last Post: 08-08-2006, 06:49 PM
  2. realm list problem
    By robtuner in forum World of Warcraft General
    Replies: 2
    Last Post: 07-21-2006, 09:08 AM
  3. I have problem with BHW 3.0
    By sunrize1 in forum World of Warcraft General
    Replies: 1
    Last Post: 07-17-2006, 08:49 AM
  4. wow emu problem
    By bezike in forum World of Warcraft General
    Replies: 0
    Last Post: 07-09-2006, 04:45 PM
  5. Site problems
    By Shanaar in forum Community Chat
    Replies: 10
    Last Post: 05-14-2006, 01:15 AM
All times are GMT -5. The time now is 12:02 AM. 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