(SOLVED) DEBUG shown on map-server console everytime player drop item or get item

[rakuzas]

 

Hello,

I already use latest rathena and recompile.. 

Also already import new SQL from import folder..

But every time player drop or get item.. will shows this DB Error..

In my core.h : 

/// uncomment to enable query_sql script command and mysql logs to function on it's own thread
/// be aware this feature is under tests and you should use at your own risk, we however
/// welcome any feedback you may have regarding this feature, please send us all bug reports.
//#define BETA_THREAD_TEST

 

In my log.c : 

#ifdef BETA_THREAD_TEST
		char entry[512];
		int e_length = 0;
		e_length = sprintf(entry, LOG_QUERY " INTO `%s` (`time`, `char_id`, `type`, `nameid`, `amount`, `refine`, `card0`, `card1`, `card2`, `card3`, `map`, `unique_id`, `bound`) VALUES (NOW(), '%d', '%c', '%hu', '%d', '%d', '%hu', '%hu', '%hu', '%hu', '%s', '%"PRIu64"', '%d')",
				log_config.log_pick, id, log_picktype2char(type), itm->nameid, amount, itm->refine, itm->card[0], itm->card[1], itm->card[2], itm->card[3], map[m].name?map[m].name:"", itm->unique_id, itm->bound);
		queryThread_log(entry,e_length);
#else
		if( SQL_ERROR == Sql_Query(logmysql_handle, LOG_QUERY " INTO `%s` (`time`, `char_id`, `type`, `nameid`, `amount`, `refine`, `card0`, `card1`, `card2`, `card3`, `map`, `unique_id`, `bound`) VALUES (NOW(), '%d', '%c', '%hu', '%d', '%d', '%hu', '%hu', '%hu', '%hu', '%s', '%"PRIu64"', '%d')",
			log_config.log_pick, id, log_picktype2char(type), itm->nameid, amount, itm->refine, itm->card[0], itm->card[1], itm->card[2], itm->card[3], map[m].name?map[m].name:"", itm->unique_id, itm->bound) )
		{
			Sql_ShowDebug(logmysql_handle);
			return;
		}
#endif

line 229 in log.c : 

            Sql_ShowDebug(logmysql_handle);

So.. Any idea how to fix this? 

Thanks..  

Edited October 12, 2017 by rakuzas

[srhmike]

Did you change anything in your conf/log_athena.conf?

And is your MySQL Log database in conf/inter_athena.conf correctly entered?

// MySQL Log 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 did you change anything in the Mysql database Tables, located at the bottom of conf/inter_athena.conf?

[rakuzas]

1 hour ago, srhmike said:

Did you change anything in your conf/log_athena.conf?

And is your MySQL Log database in conf/inter_athena.conf correctly entered?

// MySQL Log 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 did you change anything in the Mysql database Tables, located at the bottom of conf/inter_athena.conf?

I recheck in the interserver all fine.. 

Then recheck my database also fine..

Then.. Recheck at log_athena.conf.. 

And this line was //log_pick_db: picklog

So uncomment and its works.. Thank you..