Search the Community
Showing results for tags 'database'.
Found 9 results
Server Changing .map Files for Custom Map
Surumon posted a topic in Bug ReportsFor reasons I cannot understand -- The server is changing the .map files randomly every few days. I assumed originally this was just because the game was keeping the map updated as we make and perform changes but it's not just a few megabytes here or there; Randomly our resource.map file gained 30mb of new data and set all resource tiles to 55 resources remaining. Today we can't even dig the clay that we've been gathering because now the server assumes all resources have been dug straight down to rock tiles. I've adjusted no settings between server restarts. This just happens randomly. I can briefly fix this by replacing these map files with the originals, but I would love to know WHY this keeps happening.
[SOLVED] Linux DB Rebuild issues
phreekbird posted a topic in Server IssuesSo 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  (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  that's all I did anyway, but I would be leery of adding executable's to my servers, so ... yea to each their own.  https://www.dropbox.com/s/vwswo0o7sbpy5qb/rebuild-dbs_and_sqlite3.zip?dl=0  https://sqlite.org/download.html ~Phreek
I am trying to completely delete a player on a non hosted 24/7 dedicated server. I tried to delete the entry in the wurmplayers.db but after making a new character with the same name I am seeing the old character when trying to manage house and container permissions. Any ideas on how to permanently delete that character would be appreciated. Rebuilding the database is absolutely out of the question as everyone would lose what they have worked hard to create.
CentOS - Database Rebuild
Wetterwachs posted a topic in Server IssuesIf you have Problems to rebuild Database with "./rebuild-dbs" - try to: 1) Convert File to UTF8 2) Edit call of SQLITE SQLITE_CMD=./sqlite3 SQLITE_CMD=sqlite3 3) Comment out: # Check that the sqlite3 executable exists #if [ ! -f $SQLITE_CMD ]; then # echo "ERROR: Could not find sqlite executable $SQLITE_CMD" # pauseAndExit 1 #fi
King's Coffers (Database question)
Llurendt posted a topic in Unlimited Questions and ConfusionsDoes anyone know how to check the amount of money the kingdom treasury has in it? I looked in wurmeconomy.db and the 'economy' table seems to be the best bet, but I really don't know. :/ I'm running into a problem where it seems the traders' accounts aren't refilling, so I think the kingdom bank might be empty, but I've no way of checking or refilling it, haha. Thanks! -Llurendt
There must be a way. I would like template "players" that can found a starter for kingdoms without having to make them every time. I just mess around with maps and stuff. I find it funner than actually playing. I have WO for that.
Hosted server, unable to find characters in wurmplayers.db?
Nagorian posted a topic in Server IssuesGreetings 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?
Permissionshistory table issue
Taufiq posted a topic in Server IssuesAffects all platforms for Wurm Unlimited builds 828552 and earlier, and Wurm Unlimited Dedicated Server builds 828553 and earlier. Issue The server is unable to add entries to the PERMISSIONSHISTORY table in wurmplayers.db. In the server logs, this can be seen with exceptions similar to the following: WARNING: Failed to add permissions history for object (3540598449154) java.sql.SQLException: [SQLITE_CONSTRAINT] Abort due to constraint violation (NOT NULL constraint failed: PERMISSIONSHISTORY.PK) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.execute(DB.java:810) at org.sqlite.core.DB.executeUpdate(DB.java:847) at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86) at com.wurmonline.server.players.PermissionsHistories.dbAddHistoryEvent(PermissionsHistories.java:180) at com.wurmonline.server.players.PermissionsHistories.addHistoryEntry(PermissionsHistories.java:162) at com.wurmonline.server.questions.ManagePermissions.answer(ManagePermissions.java:507) at com.wurmonline.server.creatures.Communicator.reallyHandle(Communicator.java:6330) at com.wurmonline.communication.SocketConnection.tick(SocketConnection.java:615) at com.wurmonline.communication.SocketServer.tick(SocketServer.java:172) at com.wurmonline.server.Server.run(Server.java:2418) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Cause This problem is due to the wrong data type being used as the primary key (INT instead of INTEGER), which means that keys are not auto-created. Fix Warning: The following steps will involve dropping and recreating a database table, and may result in loss of data. It is recommended that a backup be made before attempting to modify the database. It is possible to recreate the permissionshistory table by dropping and recreating it with the correct data type (Sqlite is not able to change data types on existing tables). Make a backup of the world directory (eg. Creative), found in steamapps\common\Wurm Unlimited for the client/server, or steamapps\common\Wurm Unlimited Dedicated Server for the dedicated server. Create a file named patch-20151029-12af395a-permissionshistory.sql in the sqlite directory of the world directory (eg. Creative\sqlite), with the following contents: BEGIN TRANSACTION; CREATE TABLE PERMISSIONSHISTORY_12af395a ( PK INTEGER NOT NULL PRIMARY KEY, OBJECTID BIGINT NOT NULL, EVENTDATE BIGINT NOT NULL, PLAYERID BIGINT NOT NULL, PERFORMER VARCHAR(40) NOT NULL, EVENT VARCHAR(255) NOT NULL ); INSERT INTO PERMISSIONSHISTORY_12af395a SELECT PK, OBJECTID, EVENTDATE, PLAYERID, PERFORMER, EVENT FROM PERMISSIONSHISTORY; DROP TABLE PERMISSIONSHISTORY; ALTER TABLE PERMISSIONSHISTORY_12af395a RENAME TO PERMISSIONSHISTORY; COMMIT; Note that the BEGIN TRANSACTION; and COMMIT; lines will cause the update to fail if executed in an Sqlite browser that performs transactions automatically. Open a command or terminal window and navigate to the directory Execute the following to update the table: sqlite3 wurmplayers.db < patch-20151029-12af395a-permissionshistory.sql Released Fix Should be fixed in build Wurm Unlimited build 836088 (in the publicly available beta branch) and Wurm Unlimited Dedicated Server build 836095, though this will only fix new servers, not existing ones. We are looking at options for a system to implement database schema updates. Edit: Wrong database specified in application instructions, corrected wurmlogin.db to wurmplayers.db. This will not cause issues apart from having a redundant table, but the fix will need to be reapplied. Edit 2: Correction on which servers are fixed