For the love of god please someone help me. SQL Style

[SxyClutch 7]

Ok guys, I am in need of some help. I've been wracking my brain for days trying to figure out this out. I bought a Dayz.st server and trying to upload a custom map I made. It's chernaruas. I uploaded the BEIDI file to the Bliss Map Script website, http://dayz.wofjwof.com/map . Everytime I insert the code in the Bliss SQL panel, it gives me this error.

#1062 - Duplicate entry 'Land_Mil_Barracks_i_EP1' for key 'uq1_building'

I originally thought it was because the map I made was to big. I completed re did it, and it will NOT work. I am to much of a noob with SQL to understand what this means. Can anyone help me, or explain to me Why this error happens, and how to fix it. I can provide the code that I am uploading if needed.

[Zarmaka 22]

Quick google found this : http://stackoverflow.com/questions/6153552/mysql-error-1062-duplicate-entry-for-key-2 | I do not know wether it's relevant or not though.

[splinter2k 23]

SxyClutch,

I'm not familiar with custom servers, but I am familiar with SQL. Basically, whatever database file is being uploaded to, has a primary key defined for the field "uq1_building". Any data stored in a primary key field must be unique, so you cannot have duplicates. It would seem that the table your data is being inserted into, already has an entry for 'Land_Mil_Barracks_i_EP1'

Do you see any entries in your BEIDI file for that? If so, can you remove it?

Regards,

Splinter

[SxyClutch 7]

SxyClutch,

I'm not familiar with custom servers, but I am familiar with SQL. Basically, whatever database file is being uploaded to, has a primary key defined for the field "uq1_building". Any data stored in a primary key field must be unique, so you cannot have duplicates. It would seem that the table your data is being inserted into, already has an entry for 'Land_Mil_Barracks_i_EP1'

Do you see any entries in your BEIDI file for that? If so, can you remove it?

Regards,

Splinter

Well the two things it mentions are the Military barracks in DayZ. Which is tagged as uq1_building and Land_MIL_Barracks, those are actually in the game, I'm just adding more of them accross the map. But what I don't understand if thats what is creating the duplicate, how come others can upload the same editied map with the New barracks. Here is my code. I've tried changing the ID and the name in this file, but it doesn't seem to work.

INSERT INTO `bliss_1660`.`building` (`id`, `class_name`) VALUES ('1','Land_Mil_Barracks_i_EP1'), ('2','Land_Hangar_2'), ('3','Land_SS_hangar'), ('4','Land_A_Castle_Bastion'), ('5','Land_A_Castle_Bergfrit'), ('6','Land_A_Castle_Wall2_30'), ('7','Land_A_Castle_Donjon'), ('8','Land_A_Castle_Wall1_End_2'), ('9','Land_A_Castle_Wall2_End_2'), ('10','Land_A_Castle_Gate'), ('11','Land_A_Castle_Wall2_End'), ('12','Land_Mil_ControlTower_dam_EP1'), ('13','Land_Misc_Cargo2C_EP1'), ('14','Land_Misc_Cargo1D_EP1'), ('15','Land_Misc_Cargo1A_EP1'), ('16','Land_Misc_Cargo2A_EP1'), ('17','Misc_cargo_cont_small_EP1'), ('18','Land_Com_tower_ep1'), ('19','Land_A_Castle_Stairs_A'), ('20','Land_domek_rosa_ruins'), ('21','Land_A_Castle_WallS_10'), ('22','Land_A_Castle_WallS_End'), ('23','Land_A_Castle_Wall1_Corner_2'), ('24','Land_Fuel_tank_stairs_ep1'), ('25','C130J_wreck_EP1'), ('26','HMMWVWreck'), ('27','Mi8Wreck'), ('28','USMC_WarfareBAntiAirRadar'), ('29','Land_Misc_CargoMarket1a_EP1'), ('30','Land_Ind_Coltan_Main_ruins_EP1'), ('31','Land_Com_tower_ruins_EP1'), ('32','Land_a_stationhouse'), ('33','Misc_TyreHeapEP1'), ('34','hiluxWreck'), ('35','SKODAWreck'), ('36','UAZWreck'), ('37','datsun02Wreck'), ('38','LADAWreck'), ('39','SmallTV'), ('40','SkeetMachine'), ('41','Land_CamoNetVar_EAST_EP1'), ('42','Land_Misc_Cargo1Eo_EP1'), ('43','Misc_cargo_cont_tiny'), ('44','Misc_cargo_cont_net2'), ('45','PowGen_Big'), ('46','datsun01Wreck'), ('47','UralWreck'), ('48','Land_fortified_nest_small'), ('49','Land_Fort_Watchtower'), ('50','Land_Mil_House_EP1'), ('51','Land_Mil_ControlTower_EP1'), ('52','Land_Mil_Repair_center_EP1'), ('53','CDF_WarfareBAntiAirRadar'), ('54','Gue_WarfareBBarracks'), ('55','RU_WarfareBContructionSite'), ('56','INS_WarfareBFieldhHospital'), ('57','Land_Misc_Rubble_EP1'), ('58','Land_Mil_House_ruins_EP1'), ('59','Land_House_K_8_dam_EP1'), ('60','Land_House_K_8_ruins_EP1'), ('61','Land_House_K_5_EP1'), ('62','Land_House_L_4_EP1'), ('63','Base_WarfareBBarrier10xTall'), ('64','Base_WarfareBBarrier5x'), ('65','C130J_static_EP1'), ('66','Land_CamoNet_NATO_EP1'), ('67','Misc_cargo_cont_net3'), ('68','Misc_cargo_cont_net1'), ('69','Land_CamoNetB_NATO'), ('70','PowGen_Big_EP1'), ('71','Land_House_K_7_EP1'), ('72','Land_Barn_W_02'), ('73','Land_bouda2_vnitrek'), ('74','Land_NAV_Lighthouse2'), ('75','Land_pumpa'), ('76','Land_sara_domek_ruina'), ('77','Land_statek_brana_open'), ('78','Land_Nasypka'), ('79','76n6ClamShell_EP1'), ('80','Bunker_PMC'), ('81','Land_CamoNetVar_EAST'), ('82','Land_CamoNetB_NATO_EP1'), ('83','Barrack2'), ('84','Fort_Barracks_USMC'), ('85','Land_fortified_nest_big'), ('86','Land_Fort_Watchtower_EP1'), ('87','Fort_Nest_M240'), ('88','Hedgehog'), ('89','Land_Church_02a'), ('90','Land_Panelak2'), ('91','Land_A_Villa_EP1'), ('92','Land_House_L_8_EP1'), ('93','Land_House_K_8_EP1'), ('94','Land_covering_hut_big_EP1'), ('95','Land_transport_kiosk_EP1'), ('96','Land_Misc_Well_C_EP1'), ('97','Fort_Crate_wood'), ('98','Land_Misc_Garb_Heap_EP1'), ('99','Land_Ind_Coltan_Hopper_EP1'), ('100','Land_Ind_PowerStation_EP1'), ('101','Land_Ind_Oil_Pump_EP1'), ('102','Land_Ind_BoardsPack2'), ('103','Land_deutshe_mini'), ('104','Land_sunshade_EP1'), ('105','Mass_grave'), ('106','Land_Barrack2_EP1'), ('107','US_WarfareBBarracks_Base_EP1'), ('108','US_WarfareBContructionSite_Base_EP1'), ('109','WarfareBAirport'), ('110','GUE_WarfareBAntiAirRadar'), ('111','USMC_WarfareBArtilleryRadar'), ('112','CDF_WarfareBBarracks'), ('113','RU_WarfareBFieldhHospital'), ('114','Land_brana02nodoor_ruins'), ('115','Land_AFDum_mesto3_ruins'), ('116','Land_budova4_in_ruins'), ('117','Land_dum_istan3_hromada2_ruins'), ('118','Land_dum_olez_istan2_maly2_ruins'), ('119','Land_sara_domek_vilka_ruins'), ('120','TK_WarfareBFieldhHospital_Base_EP1'), ('121','Land_GuardShed'), ('122','Camp'), ('123','Land_tent_east'), ('124','Body2'), ('125','UH60_wreck_EP1'), ('126','Land_House_K_3_EP1'), ('127','Land_House_C_11_EP1'), ('128','UH1Wreck'), ('129','Misc_cargo_cont_small'), ('130','GraveCrossHelmet_EP1'), ('131','Hanged_MD'), ('132','Hanged'), ('133','Land_Ind_Shed_02_EP1'), ('134','Land_Ind_TankSmall2_EP1'), ('135','Land_Misc_Cargo1Bo_EP1'), ('136','AmmoCrates_NoInteractive_Large'), ('137','Hhedgehog_concrete'), ('138','Hedgehog_EP1'), ('139','Land_fort_rampart'), ('140','Barrel1'), ('141','Land_Ind_BoardsPack1'), ('142','Land_Misc_Cargo2E'), ('143','Land_Toilet'), ('144','FlagCarrierArmex_EP1'), ('145','FlagCarrierCDF_EP1'), ('146','Garbage_can'), ('147','ClutterCutter_EP1'), ('148','Land_Ind_IlluminantTower'), ('149','Notice_board_EP1'), ('150','Satelit'), ('151','Misc_TyreHeap'), ('152','ShootingRange_ACR'), ('153','Land_Ind_TankSmall'), ('154','Land_Ind_Timbers'), ('155','Land_Shed_wooden'), ('156','Land_Misc_deerstand'), ('157','Land_A_GeneralStore_01a'), ('158','Land_Fregata'), ('159','Park_bench2_noRoad'), ('160','Land_CamoNet_EAST'), ('161','Land_CamoNet_EAST_EP1'), ('162','Misc_Cargo1Bo_military'), ('163','CampEast'), ('164','76n6ClamShell'), ('165','Hhedgehog_concreteBig'), ('166','Land_Misc_Cargo2E_EP1'), ('167','Land_cages_EP1'), ('168','Land_bags_EP1'), ('169','Land_Dum_mesto3_ruins'), ('170','Land_Dumruina_mini_ruins'), ('171','Land_garaz'), ('172','Land_Nav_Boathouse_Pier'), ('173','Land_sara_domek_hospoda'), ('174','Land_stand_waterl_EP1'), ('175','Land_A_BuildingWIP'), ('176','Land_Mil_Guardhouse_EP1'), ('177','RU_WarfareBUAVterminal'), ('178','Land_HBarrier_large'), ('179','Land_Church_03'), ('180','Land_hospital'), ('181','Land_HouseV_3I2'), ('182','Land_Panelak'), ('183','Land_budova4'), ('184','Land_A_Office02'), ('185','ClutterCutter_small_EP1'), ('186','Land_repair_center'), ('187','Land_sara_domek_podhradi_1'), ('188','Land_Shed_W4'), ('189','Land_kulna'), ('190','Land_HouseV_3I3'), ('191','Land_HouseV_2L'), ('192','Land_HouseV_1I3'), ('193','Land_HouseV_2I'), ('194','US_WarfareBAntiAirRadar_Base_EP1'), ('195','Land_CamoNetB_EAST_EP1'), ('196','Land_Mil_Guardhouse'), ('197','FlagCarrierWhite_EP1'), ('198','Barrels'), ('199','Barrel4'), ('200','Barrel5'), ('201','US_WarfareBFieldhHospital_Base_EP1'), ('202','Land_KBud'), ('203','Land_Mil_Barracks_i'), ('204','Hedgehog_DZ'), ('205','Land_fort_bagfence_round'), ('206','Land_fort_bagfence_long'), ('207','Land_fortified_nest_small_EP1'), ('208','Fort_Barricade_EP1'), ('209','TK_WarfareBAntiAirRadar_EP1'), ('210','Land_Misc_Cable_EP1'), ('211','Land_Market_shelter_EP1'), ('212','Land_A_Mosque_big_hq_EP1'), ('213','Land_A_Mosque_big_minaret_1_EP1'), ('214','RU_WarfareBAntiAirRadar'), ('215','HeliH'), ('216','Haystack_small'), ('217','Land_Panelak3'), ('218','Land_HouseV_3I4'), ('219','Land_HouseV_3I1'), ('220','Land_dum_olezlina'), ('221','Land_dum_mesto3'), ('222','Land_AFHospoda_mesto_ruins'), ('223','Land_dum01_ruins'), ('224','Land_ruin_wall'), ('225','Land_Sara_domek_ruina_ruins'), ('226','MetalBucket'), ('227','Can_small'), ('228','Laptop_EP1'), ('229','FloorMop'), ('230','SkeetDisk'), ('231','Land_Antenna'), ('232','Misc_cargo_cont_small2'), ('233','Land_Misc_Cargo1E_EP1'), ('234','Misc_Cargo1B_military'), ('235','Land_A_Hospital'), ('236','Land_ruin_chimney'), ('237','Land_A_Mosque_big_minaret_2_EP1'), ('238','Base_WarfareBContructionSite'), ('239','CDF_WarfareBArtilleryRadar'), ('240','Land_CamoNet_NATO'), ('241','ACamp_EP1'), ('242','MASH'), ('243','Land_Misc_GContainer_Big'), ('244','Body1'), ('245','Camp_EP1'), ('246','MASH_EP1'), ('247','Land_Misc_Cargo2B'), ('248','Land_Misc_Cargo1D'), ('249','Land_Misc_Cargo2D'), ('250','Land_Misc_Cargo1C'), ('251','Land_Fuel_tank_big'), ('252','Paleta1'), ('253','Land_radar'), ('254','Land_fort_rampart_EP1'), ('255','FlagCarrierRU'), ('256','FlagCarrierINS'), ('257','Land_A_Castle_Wall1_End'), ('258','Land_A_Castle_Wall1_20'), ('259','Land_A_Castle_WallS_5_D'), ('260','Land_ruin_corner_2'), ('261','Land_Sara_domek_kovarna_ruins'), ('262','Land_Sara_Hasic_zbroj_ruins'), ('263','Land_stanice_ruins'), ('264','Land_tovarna2_ruins'), ('265','Land_trafostanica_velka_ruins'), ('266','Land_vez_ruins'), ('267','Land_leseni4x_ruins'), ('268','Land_hut06_ruins'), ('269','Land_dum_olez_istan2_maly_ruins'), ('270','Land_budova4_ruins'), ('271','Land_AFbarabizna_ruins'), ('272','BMP2Wreck'), ('273','Desk'), ('274','WoodChair'), ('275','Land_Fire_barrel'), ('276','Land_AFDum_mesto2_ruins'), ('277','Land_A_Castle_Wall1_20_Turn'), ('278','FlagCarrierTakistanKingdom_EP1'), ('279','FlagCarrierUSA_EP1'), ('280','Land_HouseBlock_B3'), ('281','Land_HouseBlock_B5'), ('282','Land_HouseV2_01B'), ('283','Land_HouseV2_04_interier_dam'), ('284','Land_R_Barn_W_01'), ('285','Land_R_HouseV2_04'), ('286','Land_Market_stalls_02_EP1'), ('287','Land_Destroyer'), ('288','US_WarfareBContructionSite1_EP1'), ('289','FlagCarrierIONblack_PMC'), ('290','Land_Nav_Boathouse'), ('291','TK_GUE_WarfareBVehicleServicePoint_Base_EP1'), ('292','Sign_DangerMines_ACR'), ('293','Sign_1L_Firstaid'), ('294','Sign_1L_Noentry_EP1'), ('295','Plastic_Pole_EP1'), ('296','Dirtmount_EP1'), ('297','Land_A_Office01_EP1'), ('298','Land_House_C_5_V3_EP1');

[splinter2k 23]

SxyClutch,

Take a look at this video. This person is also using Dayz.st and takes you through the whole process. Maybe you will be able to see what's going wrong for you.

Regards,

Splinter