Rejected Server (3) to all new registered.

[Gerome]

Hello Guys .. This is my Problem Goes.

All new registerd player are having Rejected from server(3). they can login and create a character but when they login that character they got that error. I mean they cant Login there character in Game.

But Old players can Login and Play.

Can somebody Help me about this ?

or Clue why they got this error..

Thnx n advance.

Edited December 13, 2011 by luvdistortion

[Cookies]

Check if their client date corresponds your your client date in your src/common/mmo.h.

[Gerome]

i check it sir and its correct..

i acctually have Accounts

4,332

Characters

5,876

in My Server.. and i notice that all player whos ID which compose of 9 Digit like 200000001 are having rejected.. what d u think sir?

[Emistry]

in My Server.. and i notice that all player whos ID which compose of 9 Digit like 200000001 are having rejected.. what d u think sir?

src/common/mmo.h

//Limits to avoid ID collision with other game objects
#define START_ACCOUNT_NUM 2000000
#define END_ACCOUNT_NUM 100000000
#define START_CHAR_NUM 150000

there is a Limit for it

[Gerome]

and also after the ID 2003996 is 20000313 and so on.. i think it is wrong right? why is it happen ?

[vBrenth]

check your database maybe you edit someones account id....

[Sneaky]

and also after the ID 2003996 is 20000313 and so on.. i think it is wrong right? why is it happen ?

Pretty sure you or someone editted the id values.

[Gerome]

THNX Emistry You solved my Problem and to you all Who replied thnx a lot.. and one last Question.. how should it back to normal flow of adding ID ?

Edited December 13, 2011 by luvdistortion

[KeiKun]

Hi TS

Default is

Account ID starts with 2000000 = 7 digits

Character ID starts with 150000 = 6 digits

as Emistry says

//Limits to avoid ID collision with other game objects
#define START_ACCOUNT_NUM 2000000
#define END_ACCOUNT_NUM 100000000
#define START_CHAR_NUM 150000

Here's the Restriction

src/login/account_sql.c

if( account_id > END_ACCOUNT_NUM )
return false;

EDIT:

SQL Automatically flows normally

if an Account_id is missing

the next registrant will use the missing account_id

same as character_id

if the character 150000 deleted

and there are 15 characters already on server

150000 will be used again as the 16th character made on your server

Edited December 13, 2011 by KeiKun

[Gerome]

sir.. this is about again the ID.. i deleted already the 9 digits ID but when there are new player will be registered the ID will be used is the 9 Digits ID..

for EX.

i have these ID on my database

Account_id | .......

2003996

2003997

2003998

200000313

200000314... and so on..

200000313 and 200000314 are the new Registerd ID.. it will not continue to add 200399..

whats wrong ?

Edited December 13, 2011 by luvdistortion

[Mercurial]

Hi, to solve this, execute this MySQL Query

ALTER TABLE login AUTO_INCREMENT=2003999

where 2003999 is the last account_id+1;

Tell us if it worked

Edited December 14, 2011 by Mercurial

[Gerome]

It doesnt work sir.. i do that many times.

it said (no results returned)

it always keep using the 9 digits.. is there any method ?. ALTER TABLE login AUTO_INCREMENT is not working for me.

i search about reseting auto increment field all i found is that method..

tnx for the Reply Mercurial.

Edited December 14, 2011 by luvdistortion

[KeiKun]

here's the thing

if an account_id or character_id is missing

example

2000000 = 1
2000001 = 2
2000003 = 3
2000004 = 4
2000005 = 5

the 6th registrant

gets 2000002

it will looks like this

2000000 = 1
2000001 = 2
2000003 = 3
2000004 = 4
2000005 = 5
2000002 = 6

[Xgear]

Actually no, MySQL doesnt automatically use the last unused ID. auto_increment IDs are saved as keys and the key value is what mySQL uses to increment the IDs.

You'd have to change the KEY in order to start reusing wasted IDs, however that'd give you errors once mysql tries to replicate an ID already used (It won't skip IDs up to the next either).

Only way around this is to generate a query which looks for unused/skipped IDs and have it use that value. However on most cases that'd generate a conflict between requests done at the same time, as the queries wouldnt be queued, not to mention the lack of performance this would have at some point (Should be pretty good for a really small database without that many requests to the database, but on a larger database it'd definately screw everything up)

[Mercurial]

Actually no, MySQL doesnt automatically use the last unused ID. auto_increment IDs are saved as keys and the key value is what mySQL uses to increment the IDs.

You'd have to change the KEY in order to start reusing wasted IDs, however that'd give you errors once mysql tries to replicate an ID already used (It won't skip IDs up to the next either).

Only way around this is to generate a query which looks for unused/skipped IDs and have it use that value. However on most cases that'd generate a conflict between requests done at the same time, as the queries wouldnt be queued, not to mention the lack of performance this would have at some point (Should be pretty good for a really small database without that many requests to the database, but on a larger database it'd definately screw everything up)

please read http://rathena.org/board/topic/54316-rejected-server-3-to-all-new-registered/page__view__findpost__p__60376

thats how you adjust current autoincrement value.

[Xgear]

I know that, I was referring to Keikun's comments on SQL reusing wasted auto increment values (Went a little offtopic though, sorry )

Edited December 14, 2011 by Xgear

[Gerome]

PROBLEM SOLVE:

WHAT ?

New Registered Player will be rejected when they login there character.

WHY ?

because of the account_id compose of 9 digits which is exceded like Emestry Said.

Steps that i did

first i edited all account_id in login and char table having 9 digits to 8 digits since i its running Online i and almost of the new registered player created already there character.

then i execute this some Mysql Quesry to Update a new account_id (maybe for the auto_increment)

INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`, `level`, `state`, `unban_time`, `expiration_time`, `logincount`, `lastlogin`, `last_ip`)
VALUES
(2004000,'username', 'password', 'F', '[email protected]', 0, 0, 0, 0, 0, '0', '0')

lastly i Execute this.

ALTER TABLE login AUTO_INCREMENT=2004000

when i only Execute the ALTER TABLE login AUTO_INCREMENT=2004000 it will keep using the 9 digits account_id thats why i tried to Execute somthing that will update the auto increment id.

thnx to all who reply to this topic. thnx a lot!

[Mercurial]

very good

No problem.

[Freya Jorgenson]

i am having the same problem. I have just done setting up a server, it is now running on my VPS and is telling me online. but when I create a character, it get the same exact error message. i tried doing what he did to ensure that I am on the right track but no luck , please help.

[Yetsuki]

i am having the same problem. I have just done setting up a server, it is now running on my VPS and is telling me online. but when I create a character, it get the same exact error message. i tried doing what he did to ensure that I am on the right track but no luck , please help.

char_athena:

// Enable or disable creation of new characters.
// Now it is actually supported [Kevin]
char_new: 1

Can't imagine you have the same issue as Gerome, his issue comes from having too many accounts. You just created your server so you might've configured something incorrectly.

Edited June 5, 2012 by Yetsuki