[Spce-user] Stuck on PRESENCE (PUBLISH) database error

[Skyler]

Hi all,

 

 I now have IM/voice working but presence is not updating, the below errors
are in the logs when a PUBLISH is received. The database tables are
installed and match
http://www.kamailio.org/dokuwiki/doku.php/presence:database-tables . Has
anyone seen this before or know what the problem might be?  Any help is
appreciated.

 

 

Kamailio-proxy.log -

 

INFO: <script>: New request - M=PUBLISH R=sip:testuser at dev.mydomain.com
F=sip:testuser at dev.mydomain.com T=sip:testuser at dev.mydomain.com
IP=207.216.253.26:1024 (127.0.0.1:5060) ID=26096

ERROR: db_mysql [km_dbase.c:120]: driver error on query: Field 'sender'
doesn't have a default value

ERROR: <core> [db_query.c:179]: error while submitting query

ERROR: presence [presentity.c:389]: inserting new record in database

ERROR: presence [publish.c:498]: when updating presentity

 

 

My Kamailio.proxy.cfg.tt2 -

 

#!ifdef WITH_PRESENCE

modparam("presence", "db_url", "mysql://[% kamailio.proxy.dbrwuser %]:[%
kamailio.proxy.dbrwpw %]@[% database.dbhost %]/[% kamailio.proxy.dbname %]")

modparam("presence", "fallback2db", 1)

modparam("presence", "db_update_period", 20)

modparam("presence_xml", "db_url", "mysql://[% kamailio.proxy.dbrwuser %]:[%
kamailio.proxy.dbrwpw %]@[% database.dbhost %]/[% kamailio.proxy.dbname %]")

modparam("presence_xml", "force_active", 0)

modparam("presence_xml", "integrated_xcap_server", 1)

#!endif

 

 

.and I'm doing the below in proxy.cfg.tt2

 

if(is_method("PUBLISH"))

                {

                                handle_publish();

                                t_release();

                }

 

TIA,

S.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20110704/d3fbecad/attachment.html>