Jump to content
  • 0

[SQL]: DB error - Incorrect table name


pandaplaygames

Question


  • Group:  Members
  • Topic Count:  12
  • Topics Per Day:  0.00
  • Content Count:  113
  • Reputation:   2
  • Joined:  10/29/12
  • Last Seen:  

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

Link to comment
Share on other sites

3 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  42
  • Reputation:   0
  • Joined:  08/22/12
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  12
  • Topics Per Day:  0.00
  • Content Count:  113
  • Reputation:   2
  • Joined:  10/29/12
  • Last Seen:  

disabled the logs for now. thanks :) ill check up ont SQL script.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  75
  • Topics Per Day:  0.02
  • Content Count:  2223
  • Reputation:   593
  • Joined:  10/26/11
  • Last Seen:  

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.

  • Upvote 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...