Players Permissions Histories Error

[razoreqx 127]

Dev's.   Might be something you want to look at.    A bit of cleanup needed here. 

 

[09:47:42 AM] WARNING com.wurmonline.server.players.PermissionsHistories: Failed to add permissions history for object (16617855237380)
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:205)
    at com.wurmonline.server.players.PermissionsHistories.addHistoryEntry(PermissionsHistories.java:183)
    at com.wurmonline.server.questions.ManagePermissions.answer(ManagePermissions.java:508)
    at com.wurmonline.server.creatures.Communicator.reallyHandle_CMD_PERMISSIONS(Communicator.java:2960)
    at com.wurmonline.server.creatures.Communicator.reallyHandle(Communicator.java:2527)
    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:2422)
    at java.util.TimerThread.mainLoop(Unknown Source)
    at java.util.TimerThread.run(Unknown Source)

[bdew 2,462]

 

Added: Looks like it was fixed in adventure database template, but still borked in creative.

 

@devs - PERMISSIONSHISTORY.PK should set as a primary key, it's current'y isn't.

Edited May 13, 2016 by bdew

[razoreqx 127]

Fix still works.   Thanks bdew.