Navicat Execute problem menu

User Tag List

Results 1 to 6 of 6
  1. #1
    Xx Killjoy xX's Avatar Member
    Reputation
    17
    Join Date
    Feb 2007
    Posts
    64
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Navicat Execute problem

    Ok so ive been having some problems lately with Navicat, Everytime I try to add a item vendor or watevar says that it has an error the error is


    [Err] 1054 - Unknown column 'name1' in 'field list'
    [Msg] Finished - Unsuccessfully

    Never had any probs with Navicat before and I wouldnt know how to fix it.

    Navicat Execute problem
  2. #2
    Equ1N0X's Avatar Contributor
    Reputation
    148
    Join Date
    Mar 2007
    Posts
    1,197
    Thanks G/R
    1/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Navicat Execute problem

    i forgot this in my FAQ., thanks

    What this means is that your rev uses a different column than most older databases, WoW-V uses an odler version, just find out where in your SQL file it says "name1" and change it to "name"

    or vice versa depending on the server age

  3. #3
    Xx Killjoy xX's Avatar Member
    Reputation
    17
    Join Date
    Feb 2007
    Posts
    64
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Navicat Execute problem

    Worked! Thanks man but is there any way to just make it work all the time instead of having to open it change it and so on? but thanks any way +rep

  4. #4
    Equ1N0X's Avatar Contributor
    Reputation
    148
    Join Date
    Mar 2007
    Posts
    1,197
    Thanks G/R
    1/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Navicat Execute problem

    yes, use an item creator which is set up to create batch files with your rev.

  5. #5
    Illidan1's Avatar Banned
    Reputation
    244
    Join Date
    Jul 2007
    Posts
    2,251
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Navicat Execute problem

    You can use HeidiSQL And chanage it in there Easy

  6. #6
    weaselking1973's Avatar Member
    Reputation
    30
    Join Date
    Oct 2007
    Posts
    332
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Navicat Execute problem

    Originally Posted by Xx Killjoy xX View Post
    Worked! Thanks man but is there any way to just make it work all the time instead of having to open it change it and so on? but thanks any way +rep

    if your using wow-v it now has teh option for the new builds of ascent/antrix and includes the name1 line like it should
    "In the event of an emergency, dont ask me, I crashed my server a few hundered times before I realized kicking the CPU wont make it work"


    pet mod guide Maps For Blondes creating weapons Hunter set

Similar Threads

  1. Navicat/MySQL Problems
    By foamysquirl in forum WoW EMU Questions & Requests
    Replies: 4
    Last Post: 06-22-2009, 05:12 PM
  2. Navicat/MySQL Problem
    By coolkid1 in forum WoW EMU Guides & Tutorials
    Replies: 9
    Last Post: 01-27-2008, 06:39 AM
  3. Navicat execution tip.
    By sassafrass686 in forum WoW EMU Guides & Tutorials
    Replies: 0
    Last Post: 01-03-2008, 12:51 AM
  4. Navicat problems
    By Wombatwally in forum World of Warcraft Emulator Servers
    Replies: 4
    Last Post: 10-14-2007, 05:44 AM
  5. About several navicat and mysql problems
    By Ryuk in forum World of Warcraft Emulator Servers
    Replies: 0
    Last Post: 10-12-2007, 04:31 PM
All times are GMT -5. The time now is 05:31 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