Earnestinence Posted June 28, 2017 Group: Members Topic Count: 15 Topics Per Day: 0.00 Content Count: 152 Reputation: 78 Joined: 06/13/15 Last Seen: October 22, 2023 Share Posted June 28, 2017 (edited) 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 Quote Link to comment Share on other sites More sharing options...
0 Lordok Posted June 28, 2017 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 25 Reputation: 1 Joined: 07/15/12 Last Seen: July 18, 2017 Share Posted June 28, 2017 Maybe You will need apply the SQL Upgrades from sql-files/upgrades Start date: upgrade_20161116.sql(Clan system) up to upgrade_20170620.sql Quote Link to comment Share on other sites More sharing options...
1 Cyro Posted June 28, 2017 Group: Members Topic Count: 8 Topics Per Day: 0.00 Content Count: 1137 Reputation: 290 Joined: 04/29/13 Last Seen: January 9, 2023 Share Posted June 28, 2017 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 Quote Link to comment Share on other sites More sharing options...
-1 Earnestinence Posted June 28, 2017 Group: Members Topic Count: 15 Topics Per Day: 0.00 Content Count: 152 Reputation: 78 Joined: 06/13/15 Last Seen: October 22, 2023 Author Share Posted June 28, 2017 (edited) 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 Quote Link to comment Share on other sites More sharing options...
-1 Lordok Posted June 28, 2017 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 25 Reputation: 1 Joined: 07/15/12 Last Seen: July 18, 2017 Share Posted June 28, 2017 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. Quote Link to comment Share on other sites More sharing options...
-1 Earnestinence Posted June 28, 2017 Group: Members Topic Count: 15 Topics Per Day: 0.00 Content Count: 152 Reputation: 78 Joined: 06/13/15 Last Seen: October 22, 2023 Author Share Posted June 28, 2017 we just have to wait i guess .. Quote Link to comment Share on other sites More sharing options...
Question
Earnestinence
Hello there,
i just updated my server, and i'm getting this error after recompile
charserv.bat
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 by Ciel PhantomhiveLink to comment
Share on other sites
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.