This bug is trivial , assigning as blocker

doh missed that - so used to not having permission to attach files in this jira I forget to look for them

Thanks David, your patch matches mine attached to the ticket

Patch for this issue:

1.  

   1.  

      1. Eclipse Workspace Patch 1.0
         #P openfire
         Index: src/java/org/jivesoftware/openfire/muc/spi/MUCPersistenceManager.java
         ===================================================================

      • src/java/org/jivesoftware/openfire/muc/spi/MUCPersistenceManager.java (revision 10828)
        +++ src/java/org/jivesoftware/openfire/muc/spi/MUCPersistenceManager.java (working copy)
        @@ -112,7 +112,7 @@
        private static final String DELETE_USER_MEMBER =

"DELETE FROM ofMucMember WHERE jid=?";

private static final String DELETE_USER_MUCAFFILIATION =

• "DELETE FROM ofMucaffiliation WHERE jid=?";

+ "DELETE FROM ofMucAffiliation WHERE jid=?";

private static final String ADD_CONVERSATION_LOG =

"INSERT INTO ofMucConversationLog (roomID,sender,nickname,logTime,subject,body) " +

"VALUES (?,?,?,?,?,?)";

relevent lines from at least one of the cases that throws this:

at $java.sql.PreparedStatement$$EnhancerByProxool$$a8cf99df.executeUpdate(<generated>)
at org.jivesoftware.openfire.muc.spi.MUCPersistenceManager.removeAffiliationFromDB(MUCPersistenceManager.java:956)
at org.jivesoftware.openfire.muc.MultiUserChatManager.userDeleting(MultiUserChatManager.java:835)
at org.jivesoftware.openfire.event.UserEventDispatcher.dispatchEvent(UserEventDispatcher.java:124)
at org.jivesoftware.openfire.user.UserManager.deleteUser(UserManager.java:188)
at org.jivesoftware.openfire.admin.user_002ddelete_jsp._jspService(user_002ddelete_jsp.java:93)

This will affect at least all users of mysql on *nix platforms