Jump to content
  • 0

playerdata.db why can delete user


Question

Posted

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

5 answers to this question

Recommended Posts

  • 0
Posted

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.

  • 0
Posted

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

  • 0
Posted
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

  • 0
Posted

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.

  • 0
Posted
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 

×
×
  • Create New...