6 posts • Page 1 of 1
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?