log sql error r15832

[Kanage]

as i have updated my server with revision 15832 i encountered this error. they change the schema where the last time logs should be in log schema, now its in ragnarok schema. hope the developer can fix the problem with the database.

heres the new logs.sql

#PickLog types (M)onsters Drop, (P)layers Drop/Take, Mobs Drop (L)oot Drop/Take,
# Players (T)rade Give/Take, Players (V)ending Sell/Take, (S)hop Sell/Take, (N)PC Give/Take,
# ©onsumable Items, (A)dministrators Create/Delete, Sto®age, (G)uild Storage,
# (E)mail attachment,(B)uying Store, Pr(O)duced Items/Ingredients, Auct(I)oned Items,
# (X) Other, (D) Stolen from mobs, (U) MVP Prizes[/color]
[color=#006400]#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 ;[/color]
[color=#006400]#ZenyLog types (M)onsters,(T)rade,(V)ending Sell/Buy,(S)hop Sell/Buy,(N)PC Change amount,(A)dministrators,(E)Mail,(B)uying Store
#Database: ragnarok
#Table: zenylog
CREATE TABLE `zenylog` (
 `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',
 `src_id` int(11) NOT NULL default '0',
 `type` enum('M','T','V','S','N','A','E','B','I') NOT NULL default 'S',
 `amount` int(11) NOT NULL default '0',
 `map` varchar(11) NOT NULL default '',
 PRIMARY KEY  (`id`),
 INDEX (`type`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;[/color]
[color=#006400]#Database: ragnarok
#Table: branchlog
CREATE TABLE `branchlog` (
 `branch_id` mediumint(9) unsigned NOT NULL auto_increment,
 `branch_date` datetime NOT NULL default '0000-00-00 00:00:00',
 `account_id` int(11) NOT NULL default '0',
 `char_id` int(11) NOT NULL default '0',
 `char_name` varchar(25) NOT NULL default '',
 `map` varchar(11) NOT NULL default '',
 PRIMARY KEY  (`branch_id`),
 INDEX (`account_id`),
 INDEX (`char_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;[/color]
[color=#006400]#Database: ragnarok
#Table: mvplog
CREATE TABLE `mvplog` (
 `mvp_id` mediumint(9) unsigned NOT NULL auto_increment,
 `mvp_date` datetime NOT NULL default '0000-00-00 00:00:00',
 `kill_char_id` int(11) NOT NULL default '0',
 `monster_id` smallint(6) NOT NULL default '0',
 `prize` int(11) NOT NULL default '0',
 `mvpexp` mediumint(9) NOT NULL default '0',
 `map` varchar(11) NOT NULL default '',
 PRIMARY KEY  (`mvp_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;[/color]
[color=#006400]#Database: ragnarok
#Table: atcommandlog
CREATE TABLE `atcommandlog` (
 `atcommand_id` mediumint(9) unsigned NOT NULL auto_increment,
 `atcommand_date` datetime NOT NULL default '0000-00-00 00:00:00',
 `account_id` int(11) unsigned NOT NULL default '0',
 `char_id` int(11) unsigned NOT NULL default '0',
 `char_name` varchar(25) NOT NULL default '',
 `map` varchar(11) NOT NULL default '',
 `command` varchar(255) NOT NULL default '',
 PRIMARY KEY  (`atcommand_id`),
 INDEX (`account_id`),
 INDEX (`char_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;[/color]
[color=#006400]#Database: ragnarok
#Table: npclog
CREATE TABLE `npclog` (
 `npc_id` mediumint(9) unsigned NOT NULL auto_increment,
 `npc_date` datetime NOT NULL default '0000-00-00 00:00:00',
 `account_id` int(11) unsigned NOT NULL default '0',
 `char_id` int(11) unsigned NOT NULL default '0',
 `char_name` varchar(25) NOT NULL default '',
 `map` varchar(11) NOT NULL default '',
 `mes` varchar(255) NOT NULL default '',
 PRIMARY KEY  (`npc_id`),
 INDEX (`account_id`),
 INDEX (`char_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;[/color]
[color=#006400]#ChatLog types Gl(O)bal,(W)hisper,(P)arty,(G)uild,(M)ain chat
#Database: ragnarok
#Table: chatlog
CREATE TABLE `chatlog` (
 `id` bigint(20) NOT NULL auto_increment,
 `time` datetime NOT NULL default '0000-00-00 00:00:00',
 `type` enum('O','W','P','G','M') NOT NULL default 'O',
 `type_id` int(11) NOT NULL default '0',
 `src_charid` int(11) NOT NULL default '0',
 `src_accountid` int(11) NOT NULL default '0',
 `src_map` varchar(11) NOT NULL default '',
 `src_map_x` smallint(4) NOT NULL default '0',
 `src_map_y` smallint(4) NOT NULL default '0',
 `dst_charname` varchar(25) NOT NULL default '',
 `message` varchar(150) NOT NULL default '',
 PRIMARY KEY  (`id`),
 INDEX (`src_accountid`),
 INDEX (`src_charid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;[/color]
[color=#006400]#Database: ragnarok
#Table: loginlog
CREATE TABLE `loginlog` (
 `time` datetime NOT NULL default '0000-00-00 00:00:00',
 `ip` varchar(15) NOT NULL default '',
 `user` varchar(23) NOT NULL default '',
 `rcode` tinyint(4) NOT NULL default '0',
 `log` varchar(255) NOT NULL default '',
 INDEX (`ip`)
) ENGINE=MyISAM ;

to fix this find all the

#Database: ragnarok

and change it to

#Database: log

this should fix the error

Edited April 8, 2012 by Myrmiddon