I was configuring messaging archiving in my openfire server. With mysql backend, openfire is not archiving MUC chats. The error was “You can’t specify target table” was in ConversationManager.java:processRoomMessage() because of INSERT_MESSAGE variable. Making messageID column as NOT NULL AUTO GENERATE fixes the issue.
- Running on mac osx (dev)
- mysql Ver 14.14 Distrib 5.6.23, for osx10.9