Juha Heinanen wrote:
i'll try again without word subscribe on subject line (which caused the
email being blocked).

handling subscribe causes the following error:

Aug 24 10:31:29 localhost /usr/sbin/openser[5962]: submit_query: Duplicate 
entry 'sip:[EMAIL PROTECTED]' for key 2
Aug 24 10:31:29 localhost /usr/sbin/openser[5962]: db_insert: Error while 
submitting query
Aug 24 10:31:29 localhost /usr/sbin/openser[5962]: PRESENCE: subscribe:ERROR 
while updating watchers table

i do have en entry in watchers table where

p_uri = sip:[EMAIL PROTECTED]
w_user = jh
w_domain = test.fi
event = presence
subs_status = 1
reason = NULL
inserted_time = 1187602182

why does openser try to insert an entry that already exists?  should it
try to update it instead?

Indeed it shouldn't and it doesn't (insert always follows an unsuccessful query). A new column was added to watchers table and the index updated to (p_uri, w_user, w_domain, event) and you probably did not update the table definition.

Anca

-- juha


_______________________________________________
Devel mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/devel



_______________________________________________
Devel mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/devel

Reply via email to