New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[SQL]PRIMARY key duplicate #176

Open

Nerus87 opened this issue May 20, 2020 · 6 comments

Labels

bug hacktoberfest help wanted

Nerus87 commented May 20, 2020

Error occurred

[weapons.smx] Insert Query failed! query: "INSERT INTO weapons (steamid) VALUES ('STEAM_1:1:xxxxxx79')" error: "Duplicate entry 'STEAM_1:1:xxxxxx79' for key 'PRIMARY'".

Owner

kgns commented Jul 30, 2020

What problem did this cause? (shouldn't cause any)

Author

Nerus87 commented Aug 2, 2020

It's a common problem, exists in normal conditions.
I don't remember currently what happen, but I've solved it by changing Insert to https://www.mysqltutorial.org/mysql-insert-or-update-on-duplicate-key-update/

Contributor

crashzk commented Aug 6, 2020

I also noticed this error in my logs, but I didn't see if there is any direct BUG for the players.

Owner

kgns commented Oct 3, 2021

this seems like an unimportant bug, but if anyone wants to fix it and send a pull request, you're more than welcome

kgns added bug hacktoberfest help wanted labels

Ferks-FK mentioned this issue

Update database.sp #244

Closed

Ferks-FK commented Dec 8, 2021

this seems like an unimportant bug, but if anyone wants to fix it and send a pull request, you're more than welcome

Contributor

crashzk commented Dec 16, 2021

Fixed using this version: #244

So far no new errors registered.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment