Hercules Elf Bot - Mar 16, 2012 7:22
Originally posted by [b]alohadoubt[/b]
I dunno if it's just me but this first time I've use the rAthena and I found this odd.
I've set [b]sql_logs: yes[/b] and [b]log_commands: yes[/b] however I'm having this errors in map-server_sql
[quote]
[Info]: 'alohashin' logged in. (AID/CID: '2000000/150000', Packet Ver: '26', IP: '112.210.255.67', Group '99').
[SQL]: DB error - Incorrect table name 'log/atcommandlog.log'
[Debug]: at log.c:304 - INSERT DELAYED INTO `log/atcommandlog.log` (`atcommand_date`, `account_id`, `char_id`, `char_name`, `map`, `command`) VALUES (NOW(), '2000000', '150000', ?, 'payon', ?)
[SQL]: DB error - Incorrect table name 'log/atcommandlog.log'
[Debug]: at log.c:304 - INSERT DELAYED INTO `log/atcommandlog.log` (`atcommand_date`, `account_id`, `char_id`, `char_name`, `map`, `command`) VALUES (NOW(), '2000000', '150000', ?, 'alberta', ?)
[SQL]: DB error - Incorrect table name 'log/atcommandlog.log'
[Debug]: at log.c:304 - INSERT DELAYED INTO `log/atcommandlog.log` (`atcommand_date`, `account_id`, `char_id`, `char_name`, `map`, `command`) VALUES (NOW(), '2000000', '150000', ?, 'alberta', ?)
[SQL]: DB error - Incorrect table name 'log/atcommandlog.log'
[Debug]: at log.c:304 - INSERT DELAYED INTO `log/atcommandlog.log` (`atcommand_date`, `account_id`, `char_id`, `char_name`, `map`, `command`) VALUES (NOW(), '2000000', '150000', ?, 'alberta', ?)
[/quote]
It seems the log settings for SQL won't work and it doesn't insert the GM log commands I'm currently using my admin account grplv 99 when I check the atcommandlog table nothing is inserted.
Is there any other settings for SQL logs? Can someone enlighten me about this logs...did I missed something on the settings? or bug?
I appreciate
This post has been edited by
alohadoubt
on Mar 16, 2012 7:34
Hercules Elf Bot - Mar 16, 2012 8:00
Originally posted by [b]Brian[/b]
You need to edit /conf/log_athena.conf
1. comment out this block (these are for TXT log files)
[code]// log_gm_db: log/atcommandlog.log
// log_branch_db: log/branchlog.log
// log_chat_db: log/chatlog.log
// log_mvpdrop_db: log/mvplog.log
// log_npc_db: log/npclog.log
// log_pick_db: log/picklog.log
// log_zeny_db: log/zenylog.log
[/code]
2. un-comment the block below (SQL log settings) so it looks like this:
[code]log_gm_db: atcommandlog
log_branch_db: branchlog
log_chat_db: chatlog
log_mvpdrop_db: mvplog
log_npc_db: npclog
log_pick_db: picklog
log_zeny_db: zenylog
[/code]
This post has been edited by
Brian
on Mar 16, 2012 8:01