server support

[kickazz08]

need help on this one..

: DB error - Table 'ragnarok.loginlog' doesn't exist

[Debug]: at ..\src\login\loginlog_sql.c:75 - INSERT INTO `loginlog`(`time`,`ip`,

`user`,`rcode`,`log`) VALUES (NOW(), '0.0.0.0', 'login server', '100', 'login se

rver started')

[info]: Connection request of the char-server 'rAthena' @ 127.0.0.1:6121 (accoun

t: 's1', pass: 'p1', ip: '127.0.0.1')

[sql]: DB error - Table 'ragnarok.loginlog' doesn't exist

[Heero Yuy]

Upload the log.sql (you can find that file inside the sql-files folder) then restart your server.

[Emistry]

make sure your setting inside this file is correct

trunk/conf/inter_athena.conf

// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog

and make sure you did import the SQL Table here...

trunk/sql-files/logs.sql

[KaitoKid]

Noticed this error also.

I think there is a typo with the sql script.

But you can execute this code anyway make sure you select ragnarok as your default schema

CREATE TABLE IF NOT EXISTS `loginlog` (
 `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 `ip` varchar(15) NOT NULL DEFAULT '',
 `user` varchar(23) NOT NULL DEFAULT '',
 `rcode` tinyint(4) NOT NULL DEFAULT '0',
 `log` varchar(255) NOT NULL DEFAULT '',
 KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1$$

Edited October 31, 2012 by Kaito_Kid

[Jazz]

check mo ung log.sql kung nalagay mo sa SQL mo

[chatterboy]

naka lagay naman sya. d kaya d pede sa mysql 5.5.2.4 ?

3ceam nga pede e... nakuh bug yata ene!