[ejabberd] postgresql insert problem

Cenk İlker İzanlı cenkilker at gmail.com
Mon Nov 5 13:17:37 MSK 2012


Hi,

I've installed ejabberd both 2.1.10 and 2.1.11 with postgresql support.
But when I add a contact or sign-out, I see some errors in postgresql
logs like below:

2012-11-05 11:07:07 EET ERROR:  null value in column "host" violates
not-null constraint
2012-11-05 11:07:07 EET STATEMENT:  insert into rosterusers(username, jid,
nick, subscription, ask, askmessage, server, subscribe, type) values
('test', 'testuser at mydomain.com', '', 'N', 'I', '', 'N', '', 'item');


2012-11-05 11:07:30 EET ERROR:  null value in column "host" violates
not-null constraint
2012-11-05 11:07:30 EET STATEMENT:  insert into last(username, seconds,
state) values ('testuser', '1352106450', '');

In ejabberd db, in rosterusers and last tables, there is a field with the
name 'host', but it's seen that ejabberd doesn't send host value in sql
queries?

Does anyone know how to solve this in order to insert the host value within
queries?

Thx.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.jabber.ru/pipermail/ejabberd/attachments/20121105/913ac646/attachment.html>


More information about the ejabberd mailing list