Jump to content
  • 0

[Resolvido]helpMy server is giving error that table does anyone know to resolve?

GameOver

Asked by GameOver,

 Share

Question

9 answers to this question

Recommended Posts

Radian Drops

Radian

Posted
Posted

My server is giving error that table does anyone know to resolve?

 

 

http://imgur.com/XmDtgJ8

 

It's because you put a wrong information on the inter_athena.conf inside conf folder.

// MySQL Login server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: mysqlusername
login_server_pw: mysqlpassword
login_server_db: uprise
login_codepage:
login_case_sensitive: no

ipban_db_ip: 127.0.0.1
ipban_db_port: 3306
ipban_db_id: mysqlusername
ipban_db_pw: mysqlpassword
ipban_db_db: maindbname
ipban_codepage:

// MySQL Character server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: mysqlusername
char_server_pw: mysqlpassword
char_server_db: maindbname

// MySQL Map Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: mysqlusername
map_server_pw: mysqlpassword
map_server_db: maindbname

// MySQL Log Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: mysqlusername
log_db_pw: mysqlpassword
log_db_db: logssqlname
log_codepage:
log_login_db: loginlog
GameOver Poring

GameOver

Posted
  • Author
Posted

 

My server is giving error that table does anyone know to resolve?

 

 

http://imgur.com/XmDtgJ8

 

It's because you put a wrong information on the inter_athena.conf inside conf folder.

// MySQL Login server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: mysqlusername
login_server_pw: mysqlpassword
login_server_db: uprise
login_codepage:
login_case_sensitive: no

ipban_db_ip: 127.0.0.1
ipban_db_port: 3306
ipban_db_id: mysqlusername
ipban_db_pw: mysqlpassword
ipban_db_db: maindbname
ipban_codepage:

// MySQL Character server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: mysqlusername
char_server_pw: mysqlpassword
char_server_db: maindbname

// MySQL Map Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: mysqlusername
map_server_pw: mysqlpassword
map_server_db: maindbname

// MySQL Log Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: mysqlusername
log_db_pw: mysqlpassword
log_db_db: logssqlname
log_codepage:
log_login_db: loginlog

 

 

I'm using the standard conf

 

 

// MySQL Login server

login_server_ip: 127.0.0.1

login_server_port: 3306

login_server_id: root

login_server_pw: vertrigo

login_server_db: ragnarok

login_codepage:

login_case_sensitive: no

 

ipban_db_ip: 127.0.0.1

ipban_db_port: 3306

ipban_db_id: root

ipban_db_pw: vertrigo

ipban_db_db: ragnarok

ipban_codepage:

 

// MySQL Character server

char_server_ip: 127.0.0.1

char_server_port: 3306

char_server_id: root

char_server_pw: vertrigo

char_server_db: ragnarok

 

// MySQL Map Server

map_server_ip: 127.0.0.1

map_server_port: 3306

map_server_id: root

map_server_pw: vertrigo

map_server_db: ragnarok

 

// MySQL Log Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: root

log_db_pw: vertrigo

log_db_db: ragnarok

log_codepage:

log_login_db: loginlog

Luciar Poring

Luciar

Posted
Posted (edited)

You are missing the tables required for SQL logging. Be sure to execute sql-files/logs.sql on your server (same way you loaded main.sql).

 

Check your map_athena.conf as well, ensure you configured the server IP there.

 

 

Edit: Also this is not a support thread. See http://rathena.org/board/forum-2/announcement-1-this-section-is-not-a-support-section/

Edited by luciar
GameOver Poring

GameOver

Posted
  • Author
Posted

You are missing the tables required for SQL logging. Be sure to execute sql-files/logs.sql on your server (same way you loaded main.sql).

 

Check your map_athena.conf as well, ensure you configured the server IP there.

 

 

Edit: Also this is not a support thread. See http://rathena.org/board/forum-2/announcement-1-this-section-is-not-a-support-section/

yes am importing it in Vertrigo but keeps giving error, did the same thing I did with mainsql

GameOver Poring

GameOver

Posted
  • Author
Posted (edited)

Como posso fazer isso? Eu estou usando a versão mais recente do rathena

 

verificar o seu banco de dados que você não tem mesa "loginlog" em seu banco de dados é indicado em seu erro.

Como posso fazer isso? Eu estou usando a versão mais recente do rathena

 

i add...

 

 

#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
 
#Database: ragnarok
#Table: picklog
CREATE TABLE IF NOT EXISTS `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` smallint(5) unsigned NOT NULL default '0',
  `amount` int(11) NOT NULL default '1',
  `refine` tinyint(3) unsigned NOT NULL default '0',
  `card0` smallint(5) unsigned NOT NULL default '0',
  `card1` smallint(5) unsigned NOT NULL default '0',
  `card2` smallint(5) unsigned NOT NULL default '0',
  `card3` smallint(5) unsigned NOT NULL default '0',
  `unique_id` bigint(20) unsigned NOT NULL default '0',
  `map` varchar(11) NOT NULL default '',
  `bound` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  INDEX (`type`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
 
#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 IF NOT EXISTS `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('T','V','P','M','S','N','D','C','A','E','I','B','K') 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 ;
 
#Database: ragnarok
#Table: branchlog
CREATE TABLE IF NOT EXISTS `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 ;
 
#Database: ragnarok
#Table: mvplog
CREATE TABLE IF NOT EXISTS `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` smallint(5) unsigned 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 ;
 
#Database: ragnarok
#Table: atcommandlog
CREATE TABLE IF NOT EXISTS `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 ;
 
#Database: ragnarok
#Table: npclog
CREATE TABLE IF NOT EXISTS `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 ;
 
#ChatLog types Gl(O)bal,(W)hisper,(P)arty,(G)uild,(M)ain chat
#Database: ragnarok
#Table: chatlog
CREATE TABLE IF NOT EXISTS `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 ;
 
#Database: ragnarok
#Table: loginlog
CREATE TABLE IF NOT EXISTS `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 ;
 
#Database: ragnarok
#Table: cashlog
CREATE TABLE IF NOT EXISTS `cashlog` (
  `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('T','V','P','M','S','N','D','C','A','E','I','B','$') NOT NULL DEFAULT 'S',
  `cash_type` enum('O','K','C') NOT NULL DEFAULT 'O',
  `amount` int(11) NOT NULL DEFAULT '0',
  `map` varchar(11) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  INDEX `type` (`type`)
) ENGINE=MyISAM AUTO_INCREMENT=1;
 
 
 
 
not resolved
Edited by GameOver
Microsoft Poring

Microsoft

Posted
Posted

Try to create a new database for your logs.sql,

 

create database ragnalog;

 

then upload the sql-files/logs.sql inside the ragnalog database then change your inter_athena.conf to this:

// MySQL Log Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: root
log_db_pw: vertrigo
log_db_db: ragnalog
log_codepage:
log_login_db: loginlog
GameOver Poring

GameOver

Posted
  • Author
Posted

 

Try to create a new database for your logs.sql,

 

create database ragnalog;

 

then upload the sql-files/logs.sql inside the ragnalog database then change your inter_athena.conf to this:

// MySQL Log Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: root
log_db_pw: vertrigo
log_db_db: ragnalog
log_codepage:
log_login_db: loginlog

OMGGGGGGGGGGG...........

O_O

 

you made it work thks Thks Thks....

Thks >D

Microsoft Poring

Microsoft

Posted
Posted

 

 

Try to create a new database for your logs.sql,

 

create database ragnalog;

 

then upload the sql-files/logs.sql inside the ragnalog database then change your inter_athena.conf to this:

// MySQL Log Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: root
log_db_pw: vertrigo
log_db_db: ragnalog
log_codepage:
log_login_db: loginlog

OMGGGGGGGGGGG...........

O_O

 

you made it work thks Thks Thks....

Thks >D

 

 

No problem :)

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.

×
 Share
Go to question listing

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...