Search the Community

So I came accross a couple of issues when rebuilding the database on Linux. 1. And the most annoying, is that the file format was set to windows only line formatting ... so when you executed the rebuild-dbs file, it just refused to run because of line formatting. Using an app called dos2unix i converted the line formatting, which solved this problem. 2. sqlite3.exe exist ... good job, but what about sqlite3 .... you know, for Linux/Unix types ... sigh -_-... so yea I downloaded a copy of that too. That solved all the database rebuild issues. See link for a download of the new rebuilt-dbs script [0] (with proper line formatting) and a copy of the sqlite3 executable for Linux ... if you don't trust me, just delete the sqlite3 executable, and snag a copy from here [1] that's all I did anyway, but I would be leery of adding executable's to my servers, so ... yea to each their own. [0] https://www.dropbox.com/s/vwswo0o7sbpy5qb/rebuild-dbs_and_sqlite3.zip?dl=0 [1] https://sqlite.org/download.html ~Phreek

My dedicated server keeps shutting itself down every couple of days after running into the following error: Nov 24, 2015 1:14:30 PM com.wurmonline.server.Server run INFO: Polling shop demands Nov 24, 2015 1:14:30 PM com.wurmonline.server.economy.LocalSupplyDemand increaseAllDemands WARNING: Failed to increase all demands due to [SQLITE_ERROR] SQL error or missing database (no such function: GREATEST) java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such function: GREATEST) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:40) at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:29) at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:18) at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:47) at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:254) at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:226) at com.wurmonline.server.economy.LocalSupplyDemand.increaseAllDemands(LocalSupplyDemand.java:326) at com.wurmonline.server.Server.pollShopDemands(Server.java:2497) at com.wurmonline.server.Server.run(Server.java:2210) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Nov 24, 2015 1:14:35 PM com.wurmonline.server.zones.TilePoller calcRest INFO: Current polltile=0, rest=0 pollmodifier=29053, pollround=33 Nov 24, 2015 1:14:35 PM com.wurmonline.server.zones.TilePoller calcRest INFO: tiles=4194304, mask=4194303 ticksperday=3456000, Nthick=1, rest=738304, manypertick=true Nov 24, 2015 1:14:35 PM com.wurmonline.server.zones.TilePoller checkPolltile INFO: New pollModifier: 42527 eruptions=false Nov 24, 2015 1:14:39 PM com.wurmonline.server.statistics.Statistics run INFO: current mem in use: 1241M free mem: 673M Max mem: 2010M player count: 1 bytes in: 0 bytes out: 0 total in: 6129238 total out: 27261720 Server uptime: 86400 seconds. Unanswered questions:0 Nov 24, 2015 1:14:40 PM com.wurmonline.server.skills.SkillStat$1 run WARNING: Polling 145 skills for stats v2 took 1 ms. Nov 24, 2015 1:14:42 PM com.wurmonline.server.Items countEggs INFO: Current number of eggs is 52 (max eggs is 1000) That took 37.75788 ms. Nov 24, 2015 1:14:47 PM com.wurmonline.server.epic.EpicServerStatus pollExpiredMissions INFO: Deleting last mission for deity 1 since it could not be found Nov 24, 2015 1:14:47 PM com.wurmonline.server.epic.EpicServerStatus pollExpiredMissions INFO: Deleting last mission for deity 2 since it could not be found Nov 24, 2015 1:14:47 PM com.wurmonline.server.epic.EpicServerStatus pollExpiredMissions INFO: Deleting last mission for deity 4 since it could not be found Nov 24, 2015 1:14:58 PM com.wurmonline.server.Server run SEVERE: null java.lang.NullPointerException at com.wurmonline.mesh.GrassData.encodeGrassTileData(GrassData.java:572) at com.wurmonline.server.zones.TilePoller.checkForGrassGrowth(TilePoller.java:763) at com.wurmonline.server.zones.TilePoller.checkEffects(TilePoller.java:404) at com.wurmonline.server.zones.TilePoller.pollNextTile(TilePoller.java:235) at com.wurmonline.server.zones.TilePoller.pollNext(TilePoller.java:165) at com.wurmonline.server.Server.run(Server.java:1709) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Nov 24, 2015 1:14:58 PM com.wurmonline.server.Server run SEVERE: Server is shutting down but there is no information in the Exception so creating a new one java.lang.Exception at com.wurmonline.server.Server.run(Server.java:2471) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Nov 24, 2015 1:14:58 PM com.wurmonline.server.Server shutDown INFO: Shutting down at: java.lang.Exception at com.wurmonline.server.Server.shutDown(Server.java:3278) at com.wurmonline.server.Server.run(Server.java:2473) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Nov 24, 2015 1:14:58 PM com.wurmonline.server.Server shutDown Seems the issue is that the server is trying to use the 'GREATEST' SQL function which Sqlite doesn't support (though you could simply use MAX in it's place to a degree). Any ideas if it's something I can fix on my end (I'd like to keep using sqlite) or if it needs to be patched by the devs?

Greetings all I have an issue with my hosted server, the files are only available using ftp, so I download and edit them. I uploaded my custom map, and it seems to work well, then I created a character I wish to make a GM, but when I quit, shut down the server and export the wurmplayers.db file, its empty I use sqlitebrowser I renamed the file and imported a file with a character of the same name, but one that had GM powers, started up the server and logged in, but I got into the same character as before, with the same inventory and all... so my question is : where else are the characters stored, and has anyone been able to make a GM on killservers?