Batch database nickname update

Hi,

I am new in Openfire. I had to build corporate IM infrastructure based on XMPP protocol.

I used Openfire 3.6.4. I created all users by Openfire admin console.

Next I used mySQL script to create relationships between users in tables ofPubsubAffiliation, ofPubsubSubscription, ofRoster.

Script automatically filled field nick by username.

Next day I update nick field of table ofRoster to change nicknames.

But change was not reflected by client (Pidgin 2.7.10) even after Openfire restart. When I change nickname in client I can see change in table ofRoster.

I tried new client Spark 2.5.8 and I can see all nicknames changed.

What is wrong?

Thank you.