table rathena.clan/sales doesn't exist

[Earnestinence]

Hello there,

 

i just updated my server, and i'm getting this error after recompile 

charserv.bat

[SQL]: DB error - Table 'rathena.clan' doesn't exist
[Debug]: at c:\users\pcd\desktop\rathena\03 rathena\rathena\src\char\int_clan.c:210 - SELECT `clan_id` FROM `clan`
[Status]: Finished Reading GeoIP Database.
[Status]: Characters per Account: '0'.
[Info]: Start checking DB integrity
[SQL]: DB error - Table 'rathena.clan' doesn't exist
[Debug]: at c:\users\pcd\desktop\rathena\03 rathena\rathena\src\char\char.cpp:2244 - SELECT 1 FROM `clan` LIMIT 1;
[Fatal Error]: char : A tables is missing in sql-server, please fix it, see (sql-files main.sql for structure)

 

Update: also in mapserv.bat 

 

[SQL]: DB error - Table 'rathena.sales' doesn't exist
[Debug]: at c:\users\pcd\desktop\rathena\03 rathena\rathena\src\map\cashshop.c:200 - SELECT `nameid`, UNIX_TIMESTAMP(`start`), UNIX_TIMESTAMP(`end`), `amount` FROM `sales` WHERE `end` > now()
[SQL]: DB error - Table 'rathena.sales' doesn't exist
[Debug]: at c:\users\pcd\desktop\rathena\03 rathena\rathena\src\map\cashshop.c:438 - DELETE FROM `sales` WHERE `end` < FROM_UNIXTIME(1498610778)

 

Edited June 28, 2017 by Ciel Phantomhive

[Lordok]

Maybe You will need apply the SQL Upgrades from sql-files/upgrades Start date: upgrade_20161116.sql(Clan system) up to upgrade_20170620.sql

[Cyro]

3 hours ago, Lordok said:

umm that to Bad. rAthena has turn into Unstable branch. I have at Error in my server, can't save the player data and mapserver stuck. 

Don't blame rAthena for your own mistakes , 

 

4 hours ago, Ciel Phantomhive said:

Hello there,

 

i just updated my server, and i'm getting this error after recompile 

charserv.bat

[SQL]: DB error - Table 'rathena.clan' doesn't exist
[Debug]: at c:\users\pcd\desktop\rathena\03 rathena\rathena\src\char\int_clan.c:210 - SELECT `clan_id` FROM `clan`
[Status]: Finished Reading GeoIP Database.
[Status]: Characters per Account: '0'.
[Info]: Start checking DB integrity
[SQL]: DB error - Table 'rathena.clan' doesn't exist
[Debug]: at c:\users\pcd\desktop\rathena\03 rathena\rathena\src\char\char.cpp:2244 - SELECT 1 FROM `clan` LIMIT 1;
[Fatal Error]: char : A tables is missing in sql-server, please fix it, see (sql-files main.sql for structure)

 

Update: also in mapserv.bat 

 

[SQL]: DB error - Table 'rathena.sales' doesn't exist
[Debug]: at c:\users\pcd\desktop\rathena\03 rathena\rathena\src\map\cashshop.c:200 - SELECT `nameid`, UNIX_TIMESTAMP(`start`), UNIX_TIMESTAMP(`end`), `amount` FROM `sales` WHERE `end` > now()
[SQL]: DB error - Table 'rathena.sales' doesn't exist
[Debug]: at c:\users\pcd\desktop\rathena\03 rathena\rathena\src\map\cashshop.c:438 - DELETE FROM `sales` WHERE `end` < FROM_UNIXTIME(1498610778)

 

https://github.com/rathena/rathena/blob/master/sql-files/upgrades/upgrade_20170215.sql

 

You probably missing this table

[Earnestinence]

10 hours ago, Lordok said:

Maybe You will need apply the SQL Upgrades from sql-files/upgrades Start date: upgrade_20161116.sql(Clan system) up to upgrade_20170620.sql

Hello @Lordok
 

i already did that, still same error

 

SOLVED: i was running the server on the wrong DB

Edited June 28, 2017 by Ciel Phantomhive

[Lordok]

umm that to Bad. rAthena has turn into Unstable branch. I have at Error in my server, can't save the player data and mapserver stuck. 

[Earnestinence]

we just have to wait i guess ..