SQL Quick fix +Rep to who fixes menu

User Tag List

Results 1 to 10 of 10
  1. #1
    Namor's Avatar Knight-Lieutenant
    Reputation
    27
    Join Date
    Jul 2008
    Posts
    311
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Quick fix +Rep to who fixes

    [SQL] Delete FROM item_template
    WHERE Quality=2 and
    WHERE Flags IN (2048,4, and
    WHERE InventoryType IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,20,21,22)

    [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 'WHERE Flags IN (2048,4, and
    WHERE InventoryType IN (1,2,3,4,5,6,7,8,9,10,11,1' at line 3
    <......<
    Fix pl0x?
    Last edited by Ground Zero; 06-27-2010 at 06:04 AM.

    Editable signature, at last!

    These ads disappear when you log in.

  2. #2
    Namor's Avatar Knight-Lieutenant
    Reputation
    27
    Join Date
    Jul 2008
    Posts
    311
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    4chan helped more than you guys did.
    Fix was...
    Can't have multiple WHERE clauses.

    Editable signature, at last!

  3. #3
    stoneharry's Avatar Moderator Harry


    Reputation
    1550
    Join Date
    Sep 2007
    Posts
    4,484
    Thanks G/R
    132/122
    Trade Feedback
    0 (0%)
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    You expect everyone to be online and help in less than 4 hours? Unfortunately some of us have more important things to do than help you instantly.

  4. #4
    Namor's Avatar Knight-Lieutenant
    Reputation
    27
    Join Date
    Jul 2008
    Posts
    311
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    4 hours, that's 1/6th of the day, and the majority of you are European. <.<

    Editable signature, at last!

  5. #5
    stoneharry's Avatar Moderator Harry


    Reputation
    1550
    Join Date
    Sep 2007
    Posts
    4,484
    Thanks G/R
    132/122
    Trade Feedback
    0 (0%)
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Namor View Post
    4 hours, that's 1/6th of the day, and the majority of you are European. <.<
    When the world cup (England vs Germany) is currently on and the summer holidays for a lot of us have just started. Yes, were really going to be online at the moment and free.

  6. #6
    Namor's Avatar Knight-Lieutenant
    Reputation
    27
    Join Date
    Jul 2008
    Posts
    311
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You aren't free on holidays? :O
    And the game is at 8:30pm, here. o.o

    Editable signature, at last!

  7. #7
    stoneharry's Avatar Moderator Harry


    Reputation
    1550
    Join Date
    Sep 2007
    Posts
    4,484
    Thanks G/R
    132/122
    Trade Feedback
    0 (0%)
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Namor View Post
    You aren't free on holidays? :O
    And the game is at 8:30pm, here. o.o
    Score when I'm posing this is 4-1 to Germany (should be 4-2 but ref had a "uhh what's a goal" moment). Basically England are getting hammered. On live atm. And when the holidays have just started, you generally are out celebrating and having a good time that school is over rather than sitting inside on a boiling hot day.

  8. #8
    Namor's Avatar Knight-Lieutenant
    Reputation
    27
    Join Date
    Jul 2008
    Posts
    311
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Man, I should have put money on this game. <..<
    Well. Stoneharry, you have MSN? I must talk to you. ;D

    Editable signature, at last!

  9. #9
    stoneharry's Avatar Moderator Harry


    Reputation
    1550
    Join Date
    Sep 2007
    Posts
    4,484
    Thanks G/R
    132/122
    Trade Feedback
    0 (0%)
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Namor View Post
    Man, I should have put money on this game. <..<
    Well. Stoneharry, you have MSN? I must talk to you. ;D
    [email protected]

  10. #10
    vanoon's Avatar Private
    Reputation
    3
    Join Date
    Feb 2008
    Posts
    9
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Delete FROM item_template
    WHERE Quality=2 and
    WHERE Flags IN (2048,4, and
    WHERE InventoryType IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,20,21,22)
    should be:
    Delete FROM item_template
    WHERE Quality=2 and
    Flags IN (2048,4, and
    InventoryType IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,20,21,22) don't know if this works 100% but it should.
    Or just split the queue

Similar Threads

  1. "No pokestop Nearby..." IP ban or device ban? [Quick Fix]
    By WhatchuGunnaDo in forum Pokemon GO Hacks|Cheats
    Replies: 30
    Last Post: 08-30-2016, 08:34 AM
  2. Quick fix for mouse over 4.0.1 bug
    By Wish311 in forum WoW UI, Macros and Talent Specs
    Replies: 3
    Last Post: 10-20-2010, 12:30 PM
  3. [GUIDE] NPC appear as Boxes quick fix
    By Algorithm in forum WoW EMU Guides & Tutorials
    Replies: 1
    Last Post: 05-18-2008, 03:48 PM
  4. [GUIDE] NPC appear as Boxes quick fix
    By Algorithm in forum WoW EMU Guides & Tutorials
    Replies: 3
    Last Post: 05-18-2008, 09:29 AM
  5. +rep to who ever can fully translate this...
    By idusy-org in forum Community Chat
    Replies: 14
    Last Post: 09-25-2006, 04:05 PM
All times are GMT -5. The time now is 11:01 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2021 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search