MMOCoin

Likes Likes:  0
Results 1 to 6 of 6

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Beginner

    Join Date
    May 2014
    Posts
    3
    Post Thanks / Like
    Rep Power
    12
    Reputation
    1
    i have a problem with this in creature_template:

    Query: INSERT INTO `creature_template` VALUES (999904, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'S11 PvP Weapons', 'Vendor', NULL, 0, 1, 1, 0, 0,...


    Error Code: 1136
    Column count doesn't match value count at row 1




    Execution Time : 0 sec
    Transfer Time : 0 sec
    Total Time : 0.001 sec



  2. Related Threads - Scroll Down after related threads if you are only interested to view replies for above post/thread

  3. #2
    Premium

    Join Date
    May 2011
    Posts
    222
    Post Thanks / Like
    Rep Power
    16
    Reputation
    100
    Quote Originally Posted by themagicfreak View Post
    i have a problem with this in creature_template:

    Query: INSERT INTO `creature_template` VALUES (999904, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'S11 PvP Weapons', 'Vendor', NULL, 0, 1, 1, 0, 0,...


    Error Code: 1136
    Column count doesn't match value count at row 1


    Execution Time : 0 sec
    Transfer Time : 0 sec
    Total Time : 0.001 sec
    The creature_template was change alot, like the merging of 'faction_A' and 'faction_h'. You'll have to just manually add it in.

  4. #3
    Beginner

    Join Date
    Jun 2014
    Posts
    1
    Post Thanks / Like
    Rep Power
    12
    Reputation
    1
    I have the TDB Update 355.53

    When I try batch the file I get the error!

    npc_vendor
    [Err] 1136 - Column count doesn't match value count at row 1
    [Err] INSERT INTO `npc_vendor` VALUES (999913, 9, 71720, 0, 0, 0, 1);

    creature_template.sql
    [Err] INSERT INTO `creature_template` VALUES (999904, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'S11 PvP Weapons', 'Vendor', NULL, 0, 1, 1, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
    [Msg] Finished - Unsuccessfully


    The TDB 4.3.4 5 Update is successful.
    But when i start the Server with TDB4.3.4 5 Update world become Error:
    DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at TrinityCore Home - TrinityCore - KPsN Collaboration Platform
    Cannot connect to world database localhost;3306;root;ascent;world

    What am I doing wrong?

    Sorry for my bad English, i from Germany!

 

 

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •