SQL Error Plz Help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: SQL Error Plz Help (/showthread.php?tid=184671)

---

SQL Error Plz Help - xinix000 - 21.10.2010

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 ??

---

Re: SQL Error Plz Help - Slice - 21.10.2010

I'm guessing means you have two users with ID 21873. Did you add/change anything in the MySQL database that caused this?

---

Re: SQL Error Plz Help - xinix000 - 21.10.2010

In my server it has only 1817 user

---

Re: SQL Error Plz Help - whitedragon - 21.10.2010

But where it show? when user connect?

---

Re: SQL Error Plz Help - xinix000 - 21.10.2010

[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

---

Re: SQL Error Plz Help - xinix000 - 21.10.2010

anyone can help

---

Re: SQL Error Plz Help - whitedragon - 21.10.2010

hmm maybe SQL is bugged?

---

Re: SQL Error Plz Help - JaTochNietDan - 21.10.2010

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.

---