[OpenSIPS-Users] error while using sphere parameter in presence rules.

[Visu.M]

Team,

I am trying to use sphere based presence rules.
openXCAP is my xcap server. sipsimpleclient is the client.
(I set the enable_sphere_check parameter in server).
I am getting the following error, when publishing from the client.
My PA with RLS, openXCAP and client are co-located in the same machine.

Mar 31 11:53:34 [25349] ERROR:db_mysql:db_mysql_submit_query: driver error
on query: Unknown column 'domain' in 'where clause'
Mar 31 11:53:34 [25349] ERROR:core:db_do_update: error while submitting
query
Mar 31 11:53:34 [25349] ERROR:presence:update_presentity: updating published
info in database
Mar 31 11:53:34 [25349] ERROR:presence:handle_publish: when updating
presentity

Follow the links for complete log and my config file.
Please let me know, where the error is.
Log file : http://www.cc.gatech.edu/~vmahali1/logs/log-opensips.txt<http://www.cc.gatech.edu/%7Evmahali1/logs/log-opensips.txt>
Config file : http://www.cc.gatech.edu/~vmahali1/logs/opensips.cfg<http://www.cc.gatech.edu/%7Evmahali1/logs/opensips.cfg>
Presence rules for cnn:
http://www.cc.gatech.edu/~vmahali1/logs/pres-rules-sphere.xml<http://www.cc.gatech.edu/%7Evmahali1/logs/pres-rules-sphere.xml>
published information for cnn:
http://www.cc.gatech.edu/~vmahali1/logs/published-info-cnn.txt
<http://www.cc.gatech.edu/%7Evmahali1/logs/published-info-cnn.txt>
Thanks in advance,
Visu M
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090331/2573c1a7/attachment.htm