CtrlDream Posted March 16, 2014 Posted March 16, 2014 Whenever I try to make a new character using _M/_F. That error appears and preventing me to make new account. Help here please. Quote
Phenomena Posted March 16, 2014 Posted March 16, 2014 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', `character_slots` tinyint(3) unsigned NOT NULL default '0', `pincode` varchar(4) NOT NULL DEFAULT '', `pincode_change` int(11) unsigned NOT NULL DEFAULT '0', `bank_vault` int(11) NOT NULL DEFAULT '0', `vip_time` int(11) unsigned NOT NULL default '0', `old_group` tinyint(3) NOT NULL default '0', PRIMARY KEY (`account_id`), KEY `name` (`userid`) ) ENGINE=MyISAM AUTO_INCREMENT=2000000; last column must be `old_group` and you use `last_mac` Quote
Question
CtrlDream
Whenever I try to make a new character using _M/_F. That error appears and preventing me to make new account. Help here please.
1 answer 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.