• 0
Sign in to follow this  
jommain

[SQL]: DB error - Table 'rathena.charlog' doesn't exist

Question

i check everywhere there is no rathena.clan.. maybe i just don't find it. if anyone know how to fix this.. please help

i don't want to start from scratch again. it has been 3 days of searching and tweaking..

thanks rAthena^^ *be patients im newbie

[Info]: Git Hash: 'fce885e81e9ef0d0b152309e8a0046f80fabe92c'
[Info]: Server uses 'select' as event dispatcher
[Info]: Server supports up to '4096' concurrent connections.
[Status]: Character server IP address : jomainro.zapto.org -> 115.132.62.91
[Info]: Done reading conf/import/char_conf.txt.
[Info]: Done reading conf/char_athena.conf.
[Info]: Done reading conf/import/inter_conf.txt.
[Info]: Done reading conf/inter_athena.conf.
[Info]: Done reading '149' messages in 'conf/msg_conf/char_msg.conf'.
[Info]: Done reading conf/import/inter_conf.txt.
[Info]: Done reading conf/inter_athena.conf.
[Info]: Connect Character DB server.... (Character Server)
[Status]: Done reading '1' entries in 'conf/inter_server.yml'
[Status]: Done reading '50' entries in 'db/re/exp_guild.txt'.
[Status]: Done reading '0' entries in 'db/import/exp_guild.txt'.
[SQL]: DB error - Table 'rathena.clan' doesn't exist
[Debug]: at C:\Users\Admin\Documents\GitHub\rathena\src\char\int_clan.cpp:213 - SELECT `clan_id` FROM `clan`
[Status]: Finished Reading GeoIP Database.
[Status]: Characters per Account: '0'.
[Status]: Defaulting to 192.168.0.135 as our IP address
[Info]: Start checking DB integrity
[SQL]: DB error - Table 'rathena.charlog' doesn't exist
[Debug]: at C:\Users\Admin\Documents\GitHub\rathena\src\char\char.cpp:2308 - SELECT 1 FROM `charlog` LIMIT 1;
[Fatal Error]: char : A tables is missing in sql-server, please fix it, see (sql-files main.sql for structure)

Char-Server has terminated abnormally.
Restarting in 15 seconds, press Ctrl+C to cancel.

 

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0
1 hour ago, jommain said:

i check everywhere there is no rathena.clan.. maybe i just don't find it. if anyone know how to fix this.. please help

i don't want to start from scratch again. it has been 3 days of searching and tweaking..

thanks rAthena^^ *be patients im newbie

[Info]: Git Hash: 'fce885e81e9ef0d0b152309e8a0046f80fabe92c'
[Info]: Server uses 'select' as event dispatcher
[Info]: Server supports up to '4096' concurrent connections.
[Status]: Character server IP address : jomainro.zapto.org -> 115.132.62.91
[Info]: Done reading conf/import/char_conf.txt.
[Info]: Done reading conf/char_athena.conf.
[Info]: Done reading conf/import/inter_conf.txt.
[Info]: Done reading conf/inter_athena.conf.
[Info]: Done reading '149' messages in 'conf/msg_conf/char_msg.conf'.
[Info]: Done reading conf/import/inter_conf.txt.
[Info]: Done reading conf/inter_athena.conf.
[Info]: Connect Character DB server.... (Character Server)
[Status]: Done reading '1' entries in 'conf/inter_server.yml'
[Status]: Done reading '50' entries in 'db/re/exp_guild.txt'.
[Status]: Done reading '0' entries in 'db/import/exp_guild.txt'.
[SQL]: DB error - Table 'rathena.clan' doesn't exist
[Debug]: at C:\Users\Admin\Documents\GitHub\rathena\src\char\int_clan.cpp:213 - SELECT `clan_id` FROM `clan`
[Status]: Finished Reading GeoIP Database.
[Status]: Characters per Account: '0'.
[Status]: Defaulting to 192.168.0.135 as our IP address
[Info]: Start checking DB integrity
[SQL]: DB error - Table 'rathena.charlog' doesn't exist
[Debug]: at C:\Users\Admin\Documents\GitHub\rathena\src\char\char.cpp:2308 - SELECT 1 FROM `charlog` LIMIT 1;
[Fatal Error]: char : A tables is missing in sql-server, please fix it, see (sql-files main.sql for structure)

Char-Server has terminated abnormally.
Restarting in 15 seconds, press Ctrl+C to cancel.

 

You can find it here. 
https://github.com/rathena/rathena/blob/master/sql-files/main.sql

Spoiler
  CREATE TABLE IF NOT EXISTS `clan` (
  `clan_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(24) NOT NULL DEFAULT '',
  `master` varchar(24) NOT NULL DEFAULT '',
  `mapname` varchar(24) NOT NULL DEFAULT '',
  `max_member` smallint(6) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`clan_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=5;

 

 

Share this post


Link to post
Share on other sites
  • 0

i copy paste everything but nothing change.. its ok.. redo everything.. can close this now

 

Share this post


Link to post
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.

Loading...
Sign in to follow this