Help Account ID Register

[Droke]

My flux is registering with a extra zero for example it start 2000000 but after 2000237 it showing 20000235 some time it goes 200000335

please need help

when any new player creat new account this account should come as 2000308 but is cming as 20000308

please help me what is the issue

[Emistry]

Merged same topic .....

@TS

Please dont create similar topic in multiple forum...

---

--
-- 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;

Edited November 4, 2012 by Emistry

[Brian]

Did you manually edit an account_id in SQL?

Maybe you added an extra 0, then that changed the AUTO_INCREMENT value, then the next account that FluxCP registered had the extra zero too.

The easy way to fix it would be re-import main.sql (but this would delete all your existing data).

Or you can:

1. edit all the account_id and remove the extra zero (you would also have to edit `account_id` columns in other tables like char, storage, global_reg_value, etc.

2. edit the `login` table's AUTO_INCREMENT value and remove the extra zero.

ALTER TABLE `buildbot_rag`.`login` AUTO_INCREMENT=2000335;