Duplicate entry '27172' for key 'PRIMARY'

[sergbot]

okay so I know how to fix this.

Duplicate entry '27172' for key 'PRIMARY'


you go to vdata and search for that vref and delete this.

but it keeps happening over and over again,

how do you prevent it from happening?

 

[FINTravian]

This whole community with all the creators of the Travian clones don't know the answer to this question.

 

[bob9994]

okay so I know how to fix this.

Duplicate entry '27172' for key 'PRIMARY'


you go to vdata and search for that vref and delete this.

but it keeps happening over and over again,

how do you prevent it from happening?

Dude... if you go into vdata and do that it deletes a village.

The duplicate entry is in movement. Search in movement and delete all results.

 

[RenaCido]

you can fix it... try search on mo0vement table and delete the "1"

 

[ETTETT]

Develop a code so it doesn't try to duplicate a primary key which is identifier.