Recently I update my openfire to 4.0.2 version. I’m having problem with my users. They can not add other users. In warn.log file, I saw a “duplicate” a error about duplicate register. In a Google search, I found a user that resolved the situation adding a trigger in SQL DB. I did the same thing. After this I can add other users, but when I do log off and log in Spark that user disaper. It’s happend with many users in my company.
The trigger that I used was:
SET NEW.rosterID = (SELECT MAX(rosterID) + 1 FROM ofRoster);
I think it might be something in ofID table, but I’m not sure.
Someone know what I can do to fix this?