Jump to content
  • 0

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

GameOver

Asked by GameOver,

 Share

Question

GameOver Poring

GameOver

Posted
  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  17
  • Reputation:   0
  • Joined:  11/13/14
  • Last Seen:  
Posted (edited)

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

 

 

http://imgur.com/XmDtgJ8

Edited by GameOver
Link to comment
Share on other sites

9 answers to this question

Recommended Posts

Radian Drops

Radian

Posted
  • Group:  Members
  • Topic Count:  162
  • Topics Per Day:  0.05
  • Content Count:  1546
  • Reputation:   192
  • Joined:  07/23/14
  • Last Seen:  
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
Link to comment
Share on other sites
GameOver Poring

GameOver

Posted
  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  17
  • Reputation:   0
  • Joined:  11/13/14
  • Last Seen:  
  • 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

Link to comment
Share on other sites
Luciar Poring

Luciar

Posted
  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  177
  • Reputation:   21
  • Joined:  01/31/12
  • Last Seen:  
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
Link to comment
Share on other sites
GameOver Poring

GameOver

Posted
  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  17
  • Reputation:   0
  • Joined:  11/13/14
  • Last Seen:  
  • 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

Link to comment
Share on other sites
Stickhead Poring

Stickhead

Posted
  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  13
  • Reputation:   0
  • Joined:  11/20/11
  • Last Seen:  
Posted

check your database you don't have "loginlog" table in your database it is indicated in your error.

Link to comment
Share on other sites
GameOver Poring

GameOver

Posted
  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  17
  • Reputation:   0
  • Joined:  11/13/14
  • Last Seen:  
  • 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
Link to comment
Share on other sites
Microsoft Poring

Microsoft

Posted
  • Group:  Members
  • Topic Count:  21
  • Topics Per Day:  0.00
  • Content Count:  244
  • Reputation:   17
  • Joined:  11/19/11
  • Last Seen:  
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
Link to comment
Share on other sites
GameOver Poring

GameOver

Posted
  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  17
  • Reputation:   0
  • Joined:  11/13/14
  • Last Seen:  
  • 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

Link to comment
Share on other sites
Microsoft Poring

Microsoft

Posted
  • Group:  Members
  • Topic Count:  21
  • Topics Per Day:  0.00
  • Content Count:  244
  • Reputation:   17
  • Joined:  11/19/11
  • Last Seen:  
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 :)

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.

×
 Share
Go to question listing
×
×
  • Create New...