pandaplaygames Posted November 5, 2012 Group: Members Topic Count: 12 Topics Per Day: 0.00 Content Count: 113 Reputation: 2 Joined: 10/29/12 Last Seen: September 21, 2017 Share 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 Link to comment Share on other sites More sharing options...
JRZ Posted November 5, 2012 Group: Members Topic Count: 5 Topics Per Day: 0.00 Content Count: 42 Reputation: 0 Joined: 08/22/12 Last Seen: April 30, 2016 Share 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 Link to comment Share on other sites More sharing options...
pandaplaygames Posted November 5, 2012 Group: Members Topic Count: 12 Topics Per Day: 0.00 Content Count: 113 Reputation: 2 Joined: 10/29/12 Last Seen: September 21, 2017 Author Share Posted November 5, 2012 disabled the logs for now. thanks ill check up ont SQL script. Quote Link to comment Share on other sites More sharing options...
Brian Posted November 5, 2012 Group: Members Topic Count: 75 Topics Per Day: 0.02 Content Count: 2223 Reputation: 593 Joined: 10/26/11 Last Seen: June 2, 2018 Share 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 Link to comment Share on other sites More sharing options...
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
Link to comment
Share on other sites
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.