Jump to content
  • 0
Jackson

playerdata.db why can delete user

Question

hello, need help. i open playerdata.db and cant delete 1 users some time programm send - error or can delete user
I can't understand how it is correct to delete users, let's say I want to delete the account of the violator from the server database
sorry for bad English
7d2b1faaec720a590c891cb7b00a7c7b.png

Share this post


Link to post
Share on other sites

5 answers to this question

Recommended Posts

  • 0

Go on navicat
Log into your database and double click on " users " table.
At the top-left of navicat you will find " Query " button, press it.
put this DELETE FROM `playerdata`.`users` WHERE `Name` = 'simsim'
I have put the name of simsim if it's this one you would like to delete.

Share this post


Link to post
Share on other sites
  • 0

Hello, 
Wish user are you trying to delete ?
Make sure your server is off for doing this step, Jcnider sayed me, modify data during server up can cause some unstability.
Select all your row ( the little arrow " > " at the left of ID collumn ) and press DEL or Click right on it, Delete Record

Share this post


Link to post
Share on other sites
  • 0
1 minute ago, AriusII said:

Hello, 
Wish user are you trying to delete ?
Make sure your server is off for doing this step, Jcnider sayed me, modify data during server up can cause some unstability.
Select all your row ( the little arrow " > " at the left of ID collumn ) and press DEL or Click right on it, Delete Record

I did, it's too simple to understand, it gives an error with some sort of KEY and even deleting data can not close the program writes again the problem

Share this post


Link to post
Share on other sites
  • 0

Hum try with SQL QUERY to delete the user
something like this : 
DELETE FROM `playerdata`.`users` WHERE `Name` = '<TheNameOfFuturDelete>'

Cause as I could see you have some problems with your Id collumn, the delete record from navicat, delete from ID.

Share this post


Link to post
Share on other sites
  • 0
1 hour ago, AriusII said:

Hum try with SQL QUERY to delete the user
something like this : 
DELETE FROM `playerdata`.`users` WHERE `Name` = '<TheNameOfFuturDelete>'

Cause as I could see you have some problems with your Id collumn, the delete record from navicat, delete from ID.

thanks, i go test it 

Share this post


Link to post
Share on other sites

×