SQL help

7

78043641

Well-Known Member
i get this message
#1062 - Duplicate entry 'Base_WarfareBBarrier10xTall' for key 'uq1_building'

Code: 
INSERT INTO `bliss_2978`.`building` (`id`, `class_name`) VALUES ('900','Land_Fregata'), ('901','US_WarfareBBarracks_EP1'), ('902','TK_GUE_WarfareBFieldhHospital_Base_EP1'), ('903','Land_Hangar_2'), ('904','ZavoraAnim'), ('905','WarfareBAirport'), ('906','RampConcrete'), ('907','HeliHRescue'), ('908','Base_WarfareBBarrier10xTall');
 
INSERT INTO `bliss_2978`.`instance_building` (`building_id`, `instance_id`, `worldspace`) VALUES ('900','2978','[-119.65,[5703.69,1817.98,0.01]]'), ('901','2978','[0,[7959.35,8447.72]]'), ('902','2978','[0,[7958.59,8471.21]]'), ('903','2978','[0,[7930.79,8472.96]]'), ('903','2978','[-9.16,[7897.65,8469.89,1.49]]'), ('904','2978','[0,[7917.58,8422.7]]'), ('905','2978','[0,[7866.12,8455.9,0.58]]'), ('906','2978','[169.59,[7909.41,8454.03,0.25]]'), ('907','2978','[0,[7890.79,8443.85]]'), ('907','2978','[0,[7939.28,8437.27]]'), ('908','2978','[0,[7852.18,8414.13]]'), ('908','2978','[0,[7867.12,8414.16]]'), ('908','2978','[0,[7882.29,8414.22]]'), ('908','2978','[0,[7897.31,8414.21]]'), ('908','2978','[0,[7903.4,8414.22]]'), ('908','2978','[-92.74,[7910.22,8413.74]]'), ('908','2978','[-89.99,[7916.3,8413.73]]'), ('908','2978','[0,[7924.34,8418.29]]'), ('908','2978','[0,[7938.67,8418.28]]'), ('908','2978','[0,[7953.48,8418.11]]'), ('908','2978','[0,[7968.37,8418.08]]'), ('908','2978','[-88.88,[7975.57,8425.69]]'), ('908','2978','[-90.25,[7975.76,8440.66]]'), ('908','2978','[-90.74,[7975.66,8455.96]]'), ('908','2978','[-89,[7975.7,8470.85]]'), ('908','2978','[-89.88,[7976.04,8486]]'), ('908','2978','[0,[7968.86,8493.12]]'), ('908','2978','[0,[7953.53,8492.98]]'), ('908','2978','[0,[7938.12,8492.89]]'), ('908','2978','[0,[7923,8493.03]]'), ('908','2978','[0,[7907.77,8492.94]]'), ('908','2978','[0,[7892.86,8492.87]]'), ('908','2978','[0,[7877.55,8492.99]]'), ('908','2978','[0,[7862.36,8492.99]]'), ('908','2978','[0,[7847.14,8493.13]]'), ('908','2978','[-81.63,[7839.62,8485.54]]'), ('908','2978','[90.14,[7838.58,8471.5]]'), ('908','2978','[-89.92,[7838.65,8456.62]]'), ('908','2978','[-94.6,[7839.28,8441.88]]'), ('908','2978','[-95.86,[7840.78,8426.9]]'), ('908','2978','[-122.84,[7844.69,8419.56]]');

please help
 
You can only have one of each building in the building table, Base_WarfareBBarrier10xTall must already be n there..
 
Code: 
INSERT INTO `bliss_3788`.`building` (`id`, `class_name`) VALUES ('200','Land_HBarrier_large'), ('201','Land_fortified_nest_big_EP1'), ('202','Land_Fort_Watchtower'), ('203','Land_Misc_Cargo2E_EP1'), ('204','Land_Barrack2_EP1'), ('205','Land_BarGate2'), ('206','Land_RedWhiteBarrier'), ('207','HeliHCivil'), ('208','Land_Hlidac_Budka_EP1'), ('209','Land_radar'), ('210','Land_Ind_TankSmall'), ('211','SignM_UN_Base_EP1'), ('212','Notebook'), ('213','Land_Climbing_Obstacle'), ('214','USMC_WarfareBFieldhHospital'), ('215','RU_WarfareBFieldhHospital'), ('216','CDF_WarfareBFieldhHospital'), ('217','INS_WarfareBFieldhHospital'), ('218','TargetEpopup'), ('219','AmmoBoxSmall_762'), ('220','AmmoBoxSmall_556'), ('221','AmmoBoxBig'), ('222','FoodBox1'), ('223','FoodBox2'), ('224','FoodBox0'), ('225','MedBox0'), ('226','Land_Misc_Well_C_EP1'), ('227','Hanged'), ('228','Hanged_MD'), ('229','CampEast'), ('230','Land_GuardShed'), ('231','Desk'), ('232','FoldChair'), ('233','Land_Water_pipe_EP1'), ('234',[...]
 
MySQL sa:
 
#1062 - Duplicate entry 'Land_Fort_Watchtower' for key 'uq1_building'
 
When i do that i get
Code: 
UPDATE  `bliss_3788`.`building` SET  `class_name` =  'uq1_building' WHERE  `building`.`id` =102
 
MySQL sa:
 
#1062 - Duplicate entry 'uq1_building' for key 'uq1_building'
 
You must log in or register to reply here.
Back
Top