Arcemu 3.3.5 SQL! Need Help! menu

User Tag List

Results 1 to 3 of 3
  1. #1
    Hyldran0's Avatar Contributor
    Reputation
    118
    Join Date
    Nov 2008
    Posts
    374
    Thanks G/R
    1/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Arcemu 3.3.5 SQL! Need Help!

    Hey! I'v made an sql to my vendor to import items there and it looks like:

    Code:
    INSERT INTO `vendors` (`entry`,`item`,`amount`,`max_amount`,`inctime`,`extended_cost`) VALUES 
    ('700000','51541','0','0','0','0'), 
    ('700000','51542','0','0','0','0'), 
    ('700000','51543','0','0','0','0'), 
    ('700000','51544','0','0','0','0'), 
    ('700000','51545','0','0','0','0'), 
    ('700000','51413','0','0','0','0'), 
    ('700000','51414','0','0','0','0'), 
    ('700000','51415','0','0','0','0'), 
    ('700000','51416','0','0','0','0'), 
    ('700000','51418','0','0','0','0'), 
    ('700000','51503','0','0','0','0'), 
    ('700000','51504','0','0','0','0'), 
    ('700000','51505','0','0','0','0'), 
    ('700000','51506','0','0','0','0'), 
    ('700000','51508','0','0','0','0'), 
    ('700000','51536','0','0','0','0'), 
    ('700000','51537','0','0','0','0'), 
    ('700000','51538','0','0','0','0'), 
    ('700000','51539','0','0','0','0'), 
    ('700000','51540','0','0','0','0'), 
    ('700000','51482','0','0','0','0'), 
    ('700000','51483','0','0','0','0'), 
    ('700000','51484','0','0','0','0'), 
    ('700000','51485','0','0','0','0'), 
    ('700000','51486','0','0','0','0'), 
    ('700000','51458','0','0','0','0'), 
    ('700000','51459','0','0','0','0'), 
    ('700000','51460','0','0','0','0'), 
    ('700000','51461','0','0','0','0'), 
    ('700000','51462','0','0','0','0'), 
    ('700000','51487','0','0','0','0'), 
    ('700000','51488','0','0','0','0'),
    ('700000','51489','0','0','0','0'),
    ('700000','51490','0','0','0','0'),
    ('700000','51491','0','0','0','0'),
    ('700000','51468','0','0','0','0'),
    ('700000','51469','0','0','0','0'),
    ('700000','51470','0','0','0','0'),
    ('700000','51471','0','0','0','0'),
    ('700000','51473','0','0','0','0'),
    ('700000','51419','0','0','0','0'),
    ('700000','51420','0','0','0','0'),
    ('700000','51421','0','0','0','0'),
    ('700000','51422','0','0','0','0'),
    ('700000','51424','0','0','0','0'),
    ('700000','51463','0','0','0','0'),
    ('700000','51464','0','0','0','0'),
    ('700000','51465','0','0','0','0'),
    ('700000','51466','0','0','0','0'),
    ('700000','51467','0','0','0','0'),
    ('700000','51425','0','0','0','0'),
    ('700000','51426','0','0','0','0'),
    ('700000','51427','0','0','0','0'),
    ('700000','51428','0','0','0','0'),
    ('700000','51430','0','0','0','0'),
    ('700000','51509','0','0','0','0'),
    ('700000','51509','0','0','0','0'),
    ('700000','51510','0','0','0','0'),
    ('700000','51511','0','0','0','0'),
    ('700000','51512','0','0','0','0'),
    ('700000','51514','0','0','0','0'),
    ('700000','51497','0','0','0','0'),
    ('700000','51498','0','0','0','0'),
    ('700000','51499','0','0','0','0'),
    ('700000','51450','0','0','0','0'),
    ('700000','51452','0','0','0','0'),
    ('700000','51492','0','0','0','0'),
    ('700000','51493','0','0','0','0'),
    ('700000','51494','0','0','0','0'),
    ('700000','51495','0','0','0','0'),
    ('700000','51496','0','0','0','0'),
    ('700000','51433','0','0','0','0'),
    ('700000','51434','0','0','0','0'),
    ('700000','51435','0','0','0','0'),
    ('700000','51436','0','0','0','0'),
    ('700000','51438','0','0','0','0'),
    ('700000','51474','0','0','0','0'),
    ('700000','51475','0','0','0','0'),
    ('700000','51476','0','0','0','0'),
    ('700000','51477','0','0','0','0'),
    ('700000','51479','0','0','0','0');
    But it seems to not work. cus i'v getting this error:

    Code:
    Query:
    ALTER TABLE db_version CHANGE COLUMN required_z1385_s0842_01_mangos_mangos_string required_z1385_s0842_02_mangos_command bit
    I'v got the latest Rev of Arcemu and Whydb..
    Ireally need help. Just started today learning some sql and made this. been looking how to fix it but don't really understand.
    I will sure give creditz to the one who can fix it!

    Thanks!
    Last edited by stoneharry; 03-12-2011 at 05:31 PM. Reason: Added Prefix.
    Shit's Gone Real

    Arcemu 3.3.5 SQL! Need Help!
  2. #2
    Hyldran0's Avatar Contributor
    Reputation
    118
    Join Date
    Nov 2008
    Posts
    374
    Thanks G/R
    1/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Bump! :P

    need help! all other theards getting replys xD but not mine :P
    Shit's Gone Real

  3. #3
    stoneharry's Avatar Moderator Harry


    Reputation
    1618
    Join Date
    Sep 2007
    Posts
    4,564
    Thanks G/R
    151/150
    Trade Feedback
    0 (0%)
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Search for "Alter" in your query your trying to execute.

    It's not in the error.

    Error trying to alter table?

    Logic.

    My advise, uninstall navicat, uninstall mysql server, install mysql server (fresh), install SQLyog Community edition.

    Now you can't go wrong!

    edit: My justification for this is that Mangos/Trinity comments thing in the DB is not compatible with Navicat and you'll get loads of conflicts and break the SQL server.
    Last edited by stoneharry; 03-15-2011 at 04:30 PM.

Similar Threads

  1. [ArcEmu] Account Creation Page Problem need help fast!
    By bader520 in forum WoW EMU Questions & Requests
    Replies: 6
    Last Post: 05-04-2010, 09:08 AM
  2. Need Help For ArcEmu Website
    By Nick_Da_Maco in forum WoW EMU Questions & Requests
    Replies: 31
    Last Post: 03-07-2009, 08:08 AM
  3. Need Help With two SQL Queries
    By BoP in forum Programming
    Replies: 3
    Last Post: 06-12-2008, 09:15 PM
  4. Need help with orginal sql file!
    By Ollox in forum WoW EMU Guides & Tutorials
    Replies: 3
    Last Post: 03-28-2008, 08:30 PM
All times are GMT -5. The time now is 04:29 PM. 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