_M _F Problem

[Jayz]

When i tried use _F or _M always popup Unregistered ID

When i use Control panel to register.

then login in game

disconnecting sesseion #7 with unknown packet version, possibly for having an invalid account_id (p:0x08a8,1:19).

then i will check my sql database check the account.. instead 2000010 why make to 200000010

[JRZ]

What revision are you using? and what changes did you do to your svn?

[Emistry]

--
-- Table structure for table `login`
--
CREATE TABLE IF NOT EXISTS `login` (
 `account_id` int(11) unsigned NOT NULL auto_increment,
 `userid` varchar(23) NOT NULL default '',
 `user_pass` varchar(32) NOT NULL default '',
 `sex` enum('M','F','S') NOT NULL default 'M',
 `email` varchar(39) NOT NULL default '',
 `group_id` tinyint(3) NOT NULL default '0',
 `state` int(11) unsigned NOT NULL default '0',
 `unban_time` int(11) unsigned NOT NULL default '0',
 `expiration_time` int(11) unsigned NOT NULL default '0',
 `logincount` mediumint(9) unsigned NOT NULL default '0',
 `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
 `last_ip` varchar(100) NOT NULL default '',
 `birthdate` DATE NOT NULL DEFAULT '0000-00-00',
 PRIMARY KEY  (`account_id`),
 KEY `name` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=2000000;

check this part...

AUTO_INCREMENT=2000000;

[Jayz]

-- Table structure for table `login`
--
CREATE TABLE IF NOT EXISTS `login` (
 `account_id` int(11) unsigned NOT NULL auto_increment,
 `userid` varchar(23) NOT NULL default '',
 `user_pass` varchar(32) NOT NULL default '',
 `sex` enum('M','F','S') NOT NULL default 'M',
 `email` varchar(39) NOT NULL default '',
 `group_id` tinyint(3) NOT NULL default '0',
 `state` int(11) unsigned NOT NULL default '0',
 `unban_time` int(11) unsigned NOT NULL default '0',
 `expiration_time` int(11) unsigned NOT NULL default '0',
 `logincount` mediumint(9) unsigned NOT NULL default '0',
 `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
 `last_ip` varchar(100) NOT NULL default '',
 `birthdate` DATE NOT NULL DEFAULT '0000-00-00',
 PRIMARY KEY  (`account_id`),
 KEY `name` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=200000010;

ok i have over account id on auto_increment how can i edit this?

[Emistry]

AUTO_INCREMENT=200000010;

remove the extra "00"

but it's better to run another separate query to re-adjust your auto-increment value..

or....WIPE your database...and run a new query using fixed auto-increment value...

[Jayz]

but icant wipe.. ill edit the all over 00 account id but when registering still making new account id over two 0

[Emistry]

wipe the database and run it with new & fixed sql......

[Jayz]

no other solution?? b'coz i dont want to wipe my sql

btw the 200000010 this is only sample..

b'coz honestly i have 150+ player so how can i solve this without wiping?

[Winz]

control panels should be able to do it. register newer users

[Emistry]

try run this query..

ALTER TABLE `login` AUTO_INCREMENT = <LATEST ACCOUNT ID>

make sure you backup before do this.