SQL Error When Executing Quest File menu

Shout-Out

User Tag List

Results 1 to 5 of 5
  1. #1
    Convicted's Avatar Member
    Reputation
    1
    Join Date
    Aug 2009
    Posts
    8
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Error When Executing Quest File

    So I basically created a quest on WoW-V for my server. It's just a pickup & turn in quest that grants you 50,000 gold to spend in the mall. However, when I try to execute it in my DB (using WhyDB), I get this message:



    I'm pretty sure the values in that line are all correct, and putting 0's there is right. So what's wrong? Any help is appreciated guys, thank you.
    Last edited by Convicted; 05-17-2012 at 10:28 AM.

    SQL Error When Executing Quest File
  2. #2
    Harambeqt's Avatar Elite User CoreCoins Purchaser
    Reputation
    333
    Join Date
    Mar 2010
    Posts
    1,206
    Thanks G/R
    9/29
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Post the SQL file. [code] tag it.
    Support the #1 WoW Emulator:
    http://arcemu.org/
    https://github.com/arcemu/arcemu
    - - -

  3. #3
    Dombo's Avatar Banned
    Reputation
    622
    Join Date
    Nov 2008
    Posts
    1,421
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The apostrophe doesn't seem to be escaped, so the SQL file breaks because it believes you're ending a string, prematurely.

  4. #4
    Harambeqt's Avatar Elite User CoreCoins Purchaser
    Reputation
    333
    Join Date
    Mar 2010
    Posts
    1,206
    Thanks G/R
    9/29
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The whole text is Don't forget to speak to my assistant ?f
    Try replacing the ' with ` or ´ if the word is don't

    Edit: What Dombo said, didnt see the post :3

    //Dawn
    Last edited by Harambeqt; 05-17-2012 at 11:45 AM.
    Support the #1 WoW Emulator:
    http://arcemu.org/
    https://github.com/arcemu/arcemu
    - - -

  5. #5
    Convicted's Avatar Member
    Reputation
    1
    Join Date
    Aug 2009
    Posts
    8
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I figured it was something like that, I actually tried it before with no luck, but then I just realized I had 2 words in the quest line that had an apostrophe in them. Thank you for the help guys.

    +1

Similar Threads

  1. [SQL] OregonCore, SQL ERROR when starting Oregon-Core.exe
    By Henka44 in forum WoW EMU Questions & Requests
    Replies: 3
    Last Post: 12-10-2011, 09:54 PM
  2. [ArcEmu] Errors when executing...
    By Kirsebaer in forum WoW EMU Questions & Requests
    Replies: 7
    Last Post: 06-21-2010, 03:36 PM
  3. 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
  4. I Get This Error When I Run Execute Batch File On Navicat
    By BillyBob31 in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 03-01-2008, 07:28 AM
  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 01:54 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