Error in your SQL syntax menu

Shout-Out

User Tag List

Results 1 to 5 of 5
  1. #1
    berrz's Avatar Member
    Reputation
    1
    Join Date
    Oct 2008
    Posts
    47
    Thanks G/R
    0/0
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Error in your SQL syntax

    Hi, i expect i´m not so good at this but i decided to stop trying to try for myself.
    When im executing a batch file in my database i 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 '"creature_names" ("entry", "name", "subname", "info_str", "Flags1", "type", "fam' at line 1
    [Err] INSERT INTO "creature_names" ("entry", "name", "subname", "info_str", "Flags1", "type", "family", "rank", "unk4", "spelldataid", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "civilian", "leader") VALUES
    Anyone knows what to do? Please help, thank you.

    Error in your SQL syntax
  2. #2
    waymirec's Avatar Member
    Reputation
    49
    Join Date
    Jan 2008
    Posts
    155
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    you don't need quotes around the table name or the column names.

  3. #3
    berrz's Avatar Member
    Reputation
    1
    Join Date
    Oct 2008
    Posts
    47
    Thanks G/R
    0/0
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    There are no quotes in the batch file. It just became that when i copied the error message.

  4. #4
    waymirec's Avatar Member
    Reputation
    49
    Join Date
    Jan 2008
    Posts
    155
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The line that is in the error is the exact line that SQL is trying to execute. There are quotes in it. Go fix it.

  5. #5
    berrz's Avatar Member
    Reputation
    1
    Join Date
    Oct 2008
    Posts
    47
    Thanks G/R
    0/0
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Oh shit, yes you´re right. Thanks

Similar Threads

  1. SQL Syntax Error
    By DoxramosPS in forum Programming
    Replies: 5
    Last Post: 02-26-2013, 11:18 PM
  2. Replies: 1
    Last Post: 08-09-2010, 08:20 PM
  3. Sql syntax error c++ (help)
    By jmulhern345 in forum WoW EMU Questions & Requests
    Replies: 4
    Last Post: 08-10-2008, 09:22 PM
  4. Fatal error in my sql dont want to lose files! HELP
    By J-Dizzle in forum World of Warcraft Emulator Servers
    Replies: 7
    Last Post: 07-26-2008, 09:06 PM
  5. Error: Your login interface files are corrupt
    By Grtis in forum World of Warcraft General
    Replies: 0
    Last Post: 10-28-2006, 06:38 PM
All times are GMT -5. The time now is 09:52 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