rosterID sequences

Hi guys.

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:

Table: ofRoster

Time: Before




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?