How to delete a user without deleting his files?
I want to delete a user only, but not his files, how can I do that?''
Thanks.
XFileSharing Pro - How to delete a user without deleting his files?
- PilgrimX182
- Posts: 2187
- Joined: Mar 22, 2006 1:39 pm
First need to reassing files to another user:
then you can delete this user from Admin Users with no problems I think.
Code: Select all
UPDATE Files SET usr_id=NewUserID WHERE usr_id=CurrentUserId
then you can delete this user from Admin Users with no problems I think.
-
- Posts: 90
- Joined: Nov 18, 2009 9:15 pm
-
- Posts: 90
- Joined: Nov 18, 2009 9:15 pm
PilgrimX182 wrote:First need to reassing files to another user:Code: Select all
UPDATE Files SET usr_id=NewUserID WHERE usr_id=CurrentUserId
then you can delete this user from Admin Users with no problems I think.
No doesn't work in myphp admin
ends in error #1054 - Unknown column 'testuser1' in 'where clause'
When running: UPDATE Files SET usr_id=testuser WHERE usr_id=testuser1
How do I get this to work?