Am 20.07.2011 17:34, schrieb Roberto Fichera:
> On 07/20/2011 05:18 PM, Klaus Darilion wrote:
>>
>> Am 20.07.2011 17:00, schrieb Roberto Fichera:
>>> ERROR: null value in column "sender" violates not-null constraint
>>> STATEMENT: insert into presentity
>>> (domain,username,event,etag,expires,body,received_time ) values
>>> ('192.168.2.92','roberto','presence','a.1311173612.4970.2.0',1311177224,'<?xml
>>> version="1.0" encoding="UTF-8" standalone="no"?><presence
>>> xmlns="urn:ietf:params:xml:ns:pidf"
>>> xmlns:dm="urn:ietf:params:xml:ns:pidf:data-model"
>>> xmlns:rpid="urn:ietf:params:xml:ns:pidf:rpid"
>>> entity="sip:roberto@192.168.2.92"><dm:person
>>> id="p3619"><rpid:activities/></dm:person><tuple
>>> id="t9285"><status><basic>open</basic></status><contact>sip:roberto@192.168.2.92</contact><note>Online</note></tuple></presence>',1311173624)
>> Seems like the statement does not insert the "sender" although it is
>> mandatory. If "sender" is really mandatory, then it seems the statement
>> is buggy.
>
> how does look the corresponding presentity mysql table, does it has the same
> constraint or not?
You find the data base scripts for comparison in:
utils/kamctl/mysql
and
utils/kamctl/postgres
regards
klaus
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
