Line 93 of org.jivesoftware.openfire.archive.ConversationManager has a typo in the database table name: 'ofConparticipant' should be 'ofConParticipant'.
Tables names in MySQL in Linux are case sensitive, so this prevents the query from running because the table cannot be found.
thanks LG, sent the fix in