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

[jommain]

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.

 

[Gerzzie]

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;

 

 

[jommain]

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

 

[Emistry]

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

the error is pretty much self explained.

you didnt load this SQL script into your log database

or

you unable or didnt connect to the correct log database.