_M/_F error.

[Noel Gallagher]

Svn Revision 16559

: DB error - Column count doesn't match value count at row 1

[Debug]: at account_sql.c:643 - INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`, `group_id`, `state`, `unban_time`, `expiration_time`, `logincount`, `lastlogin`, `last_ip`, `birthdate`, `last_mac`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Please fixed this :/

[Emistry]

perhap you are missing the favourite column ?

http://rathena.org/wiki/Favorite_tab

[Noel Gallagher]

i think the favourite tab db error is when you relog then your items disappeared.

[Emistry]

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; 

i dont think we have the last_mac in the sql .....

[Ind]

indeed we don't have. thats custom and therefore not rathena's fault.

[Noel Gallagher]

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;

Execute this in sql database?

[Mystery]

Sunny, that's the default login table. Your login table has last_mac which isn't supported by rAthena. By using the clean new login table, I suggest you make any backups to your old one (just in case you have a lot of players).

[Noel Gallagher]

So, What im going to do is drop the login table and execute a new one without last_mac?

Edited August 13, 2012 by Sunny Day

[Ind]

no. your login server is coded to try to obtain the last_mac field.

[Noel Gallagher]

How can i fix the _M/_F error? :/

bump.

Edited August 14, 2012 by Sunny Day

[Noel Gallagher]

BUMP!

[Mystery]

Try installing a clean SQL tables.. start from scratch and then add in the last_mac column. I believe that column is Harmony's. So, you can also refer to their installation guide for support.

[Brynner]

Svn Revision 16559

: DB error - Column count doesn't match value count at row 1

[Debug]: at account_sql.c:643 - INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`, `group_id`, `state`, `unban_time`, `expiration_time`, `logincount`, `lastlogin`, `last_ip`, `birthdate`, `last_mac`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Please fixed this :/

the fix for this is just add ? on the (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?). it should be 14 ?.