View Single Post
  #3  
Old 02-22-2004, 04:45 AM
nogoodnix
Fire Beetle
 
Join Date: Feb 2004
Posts: 9
Default

I need you to:


1017 error
Posted by: Edgar1898 :: 0 Replies :: 172 Views :: View Thread

There is the possibility for a 1017 error if the following conditions are met:

3. Your account was deleted because it was never activated.

4. You created a new account with the same name as the old one.

5. You try to login to the same server you did before your account was deleted, only to get a 1017 error.

Because the world server checks the users login server id along with their account name, whenever you signed up for the second time and got a new login id, it wont match the one that the server has in its database, so it will reject the connection. The fix is pretty easy.

Note: This is for server admins with database access.
Say the persons account name was Bob.

Update account set name='OLDBob' where name='Bob';

Have the person login. To restore their characters and stuff:

Select lsaccount_id from account where name='Bob';
Write that down.

Delete from account where name='Bob';
Update account set lsaccount_id=(WHATEVER ID YOU GOT FROM THE ABOVE SELECT QUERY),name='Bob' where name='OLDBob';

Thats it, it should work fine after that.