pandaplaygames Posted November 5, 2012 Posted November 5, 2012 Hi all- I've been getting this LOG error. [sql]: DB error - Incorrect table name '' [Debug]: at log.c:198 - INSERT DELAYED INTO `` (`time`, `char_id`, `type`, `nameid`, `amount`, `refine`, `card0`, `card1`, `card2`, `card3`, `map`) VALUES (NOW(), '1261', 'M', '7053', '-1', '0', '0', '0', '0', '0', 'prontera') I've notice that in log.c if( SQL_ERROR == Sql_Query(logmysql_handle, LOG_QUERY " INTO `%s` (`time`, `char_id`, `type`, `nameid`, `amount`, `refine`, `card0`, `card1`, `card2`, `card3`, `map`) VALUES (NOW(), '%d', '%c', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%s')", 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:"") ) { but the logs.sql creates picklog not log_pick. So i renamed the picklog to log_pick #Database: ragnarok #Table: picklog CREATE TABLE `picklog` ( `id` int(11) NOT NULL auto_increment, `time` datetime NOT NULL default '0000-00-00 00:00:00', `char_id` int(11) NOT NULL default '0', `type` enum('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U') NOT NULL default 'P', `nameid` int(11) NOT NULL default '0', `amount` int(11) NOT NULL default '1', `refine` tinyint(3) unsigned NOT NULL default '0', `card0` int(11) NOT NULL default '0', `card1` int(11) NOT NULL default '0', `card2` int(11) NOT NULL default '0', `card3` int(11) NOT NULL default '0', `map` varchar(11) NOT NULL default '', PRIMARY KEY (`id`), INDEX (`type`) ) ENGINE=MyISAM AUTO_INCREMENT=1 ; any patch of heaven that can help me out? I still get that delayed insert to error message coz my table name is incorrect. -.- turned off logs for now but need help lol Quote
JRZ Posted November 5, 2012 Posted November 5, 2012 I don't exactly know how you get there.. The question is, are you trying to add a script to your MySQL? If so, follow the steps on link bellow: http://rathena.org/wiki/SQL_Installation Quote
pandaplaygames Posted November 5, 2012 Author Posted November 5, 2012 disabled the logs for now. thanks ill check up ont SQL script. Quote
Brian Posted November 5, 2012 Posted November 5, 2012 log_pick is the correct variable name in source. The default table name is picklog. trunk/conf/log_athena.conf These should be left the defaults: 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 unless you rename the tables. 1 Quote
Question
pandaplaygames
Hi all-
I've been getting this LOG error.
I've notice that in log.c
but the logs.sql creates picklog not log_pick. So i renamed the picklog to log_pick
any patch of heaven that can help me out? I still get that delayed insert to error message coz my table name is incorrect.
-.- turned off logs for now but need help lol
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.