[ejabberd] Error when moving a user to another group

Evgeniy Khramtsov xramtsov at gmail.com
Fri Aug 13 08:10:24 MSD 2010


13.08.2010 06:28, Yann Leboulanger wrote:
> On 07/29/2010 02:04 PM, Yann Leboulanger wrote:
>>
>> Here are SQL logs when I move a contact in another group:
>>
>> 100729 13:56:01 275 Query begin
>> 275 Query select username, jid, nick, subscription, ask, askmessage,
>> server, subscribe, type from rosterusers where username='ME' and
>> jid='CONTACT'
>> 275 Query update rosterusers set username='ME', jid='CONTACT',
>> nick='NICK', subscription='B', ask='N', askmessage='', server='N',
>> subscribe='', type='item' where username='ME' and jid='CONTACT'
>> 275 Query insert into rosterusers(username, jid, nick, subscription,
>> ask, askmessage, server, subscribe, type) values ('ME', 'CONTACT',
>> 'NICK', 'B', 'N', '', 'N', '', 'item')
>> 275 Query rollback
>>
>>
>> 1/ I don't understand why there is a update in rosterusers table, only
>> rostergroups should be updated
>> 2/ There should definitively not be a insert, which cause the
>> rostergroups update to be aborded.
>>
>> Any idea why this happen?
>
> Am I the only one with this problem? Any idea why ejabberd try to 
> re-insert the user in database?
>

Seems so. Are you using the most recent version of mysql driver?

-- 
Regards,
Evgeniy Khramtsov, ProcessOne.
xmpp:xram at jabber.ru.



More information about the ejabberd mailing list