i keep getting this problem #1062 - Duplicate entry 'Land_HBarrier_large' for key 'uq1_building'

[zombiekillerdave666 0]

thanks for your help guys

[zombiekillerdave666 0]

how do i fix it ???

[Steak and Potatoes 13480]

If you have access to your database navigate to the table 'building' and type this query: SELECT * FROM `building` WHERE `class_name` = 'Land_HBarrier_large'; there should be more then one result. If you can modify this table remove all indexes for this table, you can do this by executing this query "DROP INDEX uq1_building ON `building`" it is a useless index and wont cause any harm when removed.

Rgds

Steak.

[zombiekillerdave666 0]

i dont uderstand ;s sorry but i made a base y-day and and add loads of other stuff but now its not letting me

[zombiekillerdave666 0]

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

can anyone help me and talk me through how to fix it thank you

Edited June 25, 2013 by Inception.
Font fix

[applejaxc 2500]

Check your file integrity? There's a key-item inconsistency, could be a .pbo registry error. Or I could be blowing smoke and not know what the hell I'm talking about. I never got custom crap to work, besides 3 AI A10s that fly around bombing Cherno.

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

So it's a mySql error not a .bikey error. So I was blowing smoke.

Your game doesn't like your tables being edited with new buildings.

Scrap your custom mission file, youtube it, and try again.