• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Lua correct duplicate names

ADM24horas

ADM24horas

New Member
Joined
Oct 4, 2015
Messages
70
Reaction score
0
[VIP] Diego and name Diego

what?

http://prntscr.com/9psr3t


If I use the VIP gives error in query

mysql_real_query(): UPDATE `players` SET `name` = '[VIP] Diego' WHERE `id` = 40; - MYSQL ERROR: Duplicate entry '[VIP] Diego-0' for key 'name' (1062)
 
Sort by date Sort by votes
ADM24horas said:
[VIP] Diego and name Diego

what?

http://prntscr.com/9psr3t


If I use the VIP gives error in query

mysql_real_query(): UPDATE `players` SET `name` = '[VIP] Diego' WHERE `id` = 40; - MYSQL ERROR: Duplicate entry '[VIP] Diego-0' for key 'name' (1062)
Click to expand...
1. This isn't the 1st time you posted a question on these forums so stop being a lazy ass and post the server version.
2. Post the code you "created" or copied that is generating this error.
3. Get with the program or throw your computer out the window...
 
Upvote 0 Downvote
ADM24horas said:
so you can not solve it by creating a query in the database
Click to expand...
I think it means you can't duplicate name, maybe other person have the name?, Because I think this error happened with me before and solution was add "AUTO_INCREASMENT" for "primarykey(id)"

But it seems happens with "name" so check if the name is duplicated or not!
 
Upvote 0 Downvote
more like I can do this?

all the duplication problem is only on the site since at 1/1 on my server has no way to create char with the same name if [VIP] Oo and Oo is only possible to do this on the site


Milice said:
Change your accountcreator code to not allow creation of X if [VIP] X exists
Click to expand...
 
Last edited:
Upvote 0 Downvote
how can I do that?

all the duplication problem is only on the site since at 1/1 on my server has no way to create char with the same name if [VIP] Oo and Oo is only possible to do this on the site

Slavi Dodo said:
I think it means you can't duplicate name, maybe other person have the name?, Because I think this error happened with me before and solution was add "AUTO_INCREASMENT" for "primarykey(id)"

But it seems happens with "name" so check if the name is duplicated or not!
Click to expand...
Slavi Dodo said:
I think it means you can't duplicate name, maybe other person have the name?, Because I think this error happened with me before and solution was add "AUTO_INCREASMENT" for "primarykey(id)"
Click to expand...
 
Last edited:
Upvote 0 Downvote
Back
Top