[SQL]: DB error

[adani_jmc]

ehm .. its appears on map-server console

first one is when i throw an item

and second is when i pickup again it

anyone know whats wrong with it ?

yeah i know its from picklog, i use mySQL for logging it

thx

Edited March 25, 2012 by adani_jmc

[Whitecash]

did you add log.sql?

[LCDTheOG]

you must make a seperate database for log, name it log, then run the log.sql file in ur /sql-files/ folder and make sure you give it permissions. also make sure you specify in the conf/inter_athena.conf the name of ur database.

[Asura]

Hi adani_jmc,

From your terminal, there seems to be an error with how the name of the tables are set.

Source: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/conf/log_athena.conf

By default, the log is written in a .log file and not SQL. So you must comment the standard default, and un-comment the proper SQL table names. So it should look like this instead...

// 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

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

[adani_jmc]

did you add log.sql?

Yes i do

you must make a seperate database for log, name it log, then run the log.sql file in ur /sql-files/ folder and make sure you give it permissions. also make sure you specify in the conf/inter_athena.conf the name of ur database.

No, it doesnt necesarry, in the Inter_athena.conf you will see which database you want to use for each configuration

Hi adani_jmc,

From your terminal, there seems to be an error with how the name of the tables are set.

Source: https://rathena.svn....log_athena.conf

By default, the log is written in a .log file and not SQL. So you must comment the standard default, and un-comment the proper SQL table names. So it should look like this instead...

// 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

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

i think this is the best answer, yeah it still uncomment, okeh i'll try it

thanks for answering my question