Posts: 104
Threads: 40
Joined: May 2010
Reputation:
0
when player joined the server
it show in server_log
Error in mysql_query: Duplicate entry '21873' for key 1
what is this and how to fix it ??
Posts: 1,831
Threads: 69
Joined: Mar 2008
Reputation:
0
I'm guessing means you have two users with ID 21873. Did you add/change anything in the MySQL database that caused this?
Posts: 104
Threads: 40
Joined: May 2010
Reputation:
0
In my server it has only 1817 user
Posts: 516
Threads: 153
Joined: Sep 2009
Reputation:
0
But where it show? when user connect?
Posts: 104
Threads: 40
Joined: May 2010
Reputation:
0
[16:33:17] [join] BaBy_Mio has joined the server
[16:33:21] Error in mysql_query: Duplicate entry '21873' for key 1
[16:33:21] BaBy_Mio has logged in.
like this
Posts: 2,502
Threads: 26
Joined: Apr 2007
Reputation:
0
It means you have two rows with identical values in a column with the primary key set to it. Most probably the ID column.
To fix the issue, you need to change the duplicate ID or else remove it from the table.