Adding SQL Game Objects error menu

User Tag List

Results 1 to 3 of 3
  1. #1
    bokou's Avatar Member
    Reputation
    1
    Join Date
    Aug 2006
    Posts
    19
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Adding SQL Game Objects error

    Was looking at this thread and was installing the SQL files provided in it (http://www.mmowned.com/forums/ascent...dvanced-2.html) and when I run the SQL batch it spouts out this error for every single entry:

    Code:
    [Err] 1136 - Column count doesn't match value count at row 1
    [Err] INSERT INTO `gameobject_names` VALUES ('70100', '5', '6815', 'Uther Statue', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
    [Msg] Finished - Unsuccessfully
    I know it means the column count isn't matching up. I'm using Navicat and have the "continue on errors" option checked but I see no other option to ignore additional columns or anything like that - any ideas?

    Adding SQL Game Objects error
  2. #2
    Sandile's Avatar Member
    Reputation
    32
    Join Date
    Aug 2008
    Posts
    314
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    First of all you need to make sure you use an arcemu core. Then you also need to make sure that your DB is updated, you can check that in the arcemu SVN. trunk/sql/world_updates , execute all the updates and try again. If it still don't work then I'm not really sure..
    "i downloaded it in "pirates bay", can you tell me how to download it in steam, pls"

  3. #3
    AngelSandy's Avatar Member
    Reputation
    19
    Join Date
    Jan 2009
    Posts
    330
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You have a 0 to much somewhere I believe.

Similar Threads

  1. How To: Add Game Objects anywhere, everywhere!
    By CSOM in forum WoW EMU Guides & Tutorials
    Replies: 5
    Last Post: 09-05-2024, 04:07 AM
  2. Adding Custom Game Objects to YOUR Server. (Needed HeidiSQL & ArcEmu))
    By zarrion11 in forum World of Warcraft General
    Replies: 2
    Last Post: 12-04-2009, 12:27 PM
  3. May someone give a simple analogy about Ascent Game Object Adding?
    By tyman2006 in forum World of Warcraft Emulator Servers
    Replies: 4
    Last Post: 12-16-2007, 02:13 PM
  4. How do I keep game objects forever. PLZ HELP!
    By chocodog in forum World of Warcraft Emulator Servers
    Replies: 6
    Last Post: 10-01-2007, 09:20 PM
  5. Custom Game objects
    By Possum in forum World of Warcraft Emulator Servers
    Replies: 1
    Last Post: 09-27-2007, 10:53 PM
All times are GMT -5. The time now is 06: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