Import Failed

Results 1 to 2 of 2
  1. #1
    Apprentice 4iriks is offline
    MemberRank
    Mar 2009 Join Date
    7Posts

    Import Failed

    Hello , i want to know what is wrong in these files ! I want to import wings in my server , but it gives me error !

    SQL =

    Code:
    INSERT INTO `armor` VALUES ('40013', 'Valakas Wings', 'face', 'false', 'none', '10', 'wood', 'none', '0', '-1', '-1', '0', '0', '0', '500000', '0', 'true', 'true', 'true', 'true', '0-0;');
    INSERT INTO `armor` VALUES ('40014', 'Angel Wings', 'face', 'false', 'none', '10', 'wood', 'none', '0', '-1', '-1', '0', '0', '0', '500000', '0', 'true', 'true', 'true', 'true', '0-0;');
    INSERT INTO `armor` VALUES ('40015', 'Fallen Wings', 'face', 'false', 'none', '10', 'wood', 'none', '0', '-1', '-1', '0', '0', '0', '500000', '0', 'true', 'true', 'true', 'true', '0-0;');
    INSERT INTO `armor` VALUES ('40016', 'Gargoyle Wings', 'face', 'false', 'none', '10', 'wood', 'none', '0', '-1', '-1', '0', '0', '0', '500000', '0', 'true', 'true', 'true', 'true', '0-0;');
    INSERT INTO `armor` VALUES ('40017', 'Chaos Wings', 'face', 'false', 'none', '10', 'wood', 'none', '0', '-1', '-1', '0', '0', '0', '500000', '0', 'true', 'true', 'true', 'true', '0-0;');
    INSERT INTO `armor` VALUES ('40018', 'Eva Wings', 'face', 'false', 'none', '10', 'wood', 'none', '0', '-1', '-1', '0', '0', '0', '500000', '0', 'true', 'true', 'true', 'true', '0-0;');
    INSERT INTO `armor` VALUES ('40019', 'Netherworld Wings', 'face', 'false', 'none', '10', 'wood', 'none', '0', '-1', '-1', '0', '0', '0', '500000', '0', 'true', 'true', 'true', 'true', '0-0;');
    INSERT INTO `armor` VALUES ('40020', 'Succubus Wings', 'face', 'false', 'none', '10', 'wood', 'none', '0', '-1', '-1', '0', '0', '0', '500000', '0', 'true', 'true', 'true', 'true', '0-0;');
    INSERT INTO `armor` VALUES ('40021', 'Pixie Wings', 'face', 'false', 'none', '10', 'wood', 'none', '0', '-1', '-1', '0', '0', '0', '500000', '0', 'true', 'true', 'true', 'true', '0-0;');
    INSERT INTO `armor` VALUES ('40022', 'Kamael Wings', 'face', 'false', 'none', '10', 'wood', 'none', '0', '-1', '-1', '0', '0', '0', '500000', '0', 'true', 'true', 'true', 'true', '0-0;');
    INSERT INTO `armor` VALUES ('40023', 'War Wings', 'face', 'false', 'none', '10', 'wood', 'none', '0', '-1', '-1', '0', '0', '0', '500000', '0', 'true', 'true', 'true', 'true', '0-0;');
    And error =
    Code:
    [Err] 1136 - Column count doesn't match value count at row 1
    [Err] INSERT INTO `armor` VALUES ('40013', 'Valakas Wings', 'face', 'false', 'none', '10', 'wood', 'none', '0', '-1', '-1', '0', '0', '0', '500000', '0', 'true', 'true', 'true', 'true', '0-0;');
    [Msg] Finished - Unsuccessfully
    --------------------------------------------------

    I am using latest l2j server !


  2. #2
    ~ksemer~ DaRkAnGeL is offline
    MemberRank
    Oct 2006 Join Date
    Java_HomeLocation
    5,115Posts

    Re: Import Failed

    the columns are not right. you need to compare you armor.sqls with your wings. add them manualy



Advertisement