Jayz Posted November 3, 2012 Posted November 3, 2012 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 Quote
JRZ Posted November 4, 2012 Posted November 4, 2012 What revision are you using? and what changes did you do to your svn? Quote
Emistry Posted November 4, 2012 Posted November 4, 2012 -- -- 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; Quote
Jayz Posted November 4, 2012 Author Posted November 4, 2012 -- 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? Quote
Emistry Posted November 4, 2012 Posted November 4, 2012 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... Quote
Jayz Posted November 4, 2012 Author Posted November 4, 2012 but icant wipe.. ill edit the all over 00 account id but when registering still making new account id over two 0 Quote
Emistry Posted November 4, 2012 Posted November 4, 2012 wipe the database and run it with new & fixed sql...... Quote
Jayz Posted November 4, 2012 Author Posted November 4, 2012 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? Quote
Winz Posted November 8, 2012 Posted November 8, 2012 control panels should be able to do it. register newer users Quote
Emistry Posted November 8, 2012 Posted November 8, 2012 try run this query.. ALTER TABLE `login` AUTO_INCREMENT = <LATEST ACCOUNT ID> make sure you backup before do this. Quote
Question
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
9 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.