Team,<br><br>I am trying to use sphere based presence rules.<br>openXCAP is my xcap server. sipsimpleclient is the client.<br>(I set the enable_sphere_check parameter in server).<br>I am getting the following error, when publishing from the client.<br>
My PA with RLS, openXCAP and client are co-located in the same machine.<br><br>Mar 31 11:53:34 [25349] ERROR:db_mysql:db_mysql_submit_query: driver error on query: Unknown column &#39;domain&#39; in &#39;where clause&#39;              <br>
Mar 31 11:53:34 [25349] ERROR:core:db_do_update: error while submitting query                                                           <br>
Mar 31 11:53:34 [25349] ERROR:presence:update_presentity: updating published info in database                                               <br>Mar 31 11:53:34 [25349] ERROR:presence:handle_publish: when updating presentity      <br>
<br>Follow the links for complete log and my config file.<br>Please let me know, where the error is.<br>Log file : <a href="http://www.cc.gatech.edu/%7Evmahali1/logs/log-opensips.txt">http://www.cc.gatech.edu/~vmahali1/logs/log-opensips.txt</a><br>
Config file : <a href="http://www.cc.gatech.edu/%7Evmahali1/logs/opensips.cfg">http://www.cc.gatech.edu/~vmahali1/logs/opensips.cfg</a><br>Presence rules for cnn: <a href="http://www.cc.gatech.edu/%7Evmahali1/logs/pres-rules-sphere.xml">http://www.cc.gatech.edu/~vmahali1/logs/pres-rules-sphere.xml</a><br>
published information for cnn: <a href="http://www.cc.gatech.edu/%7Evmahali1/logs/published-info-cnn.txt">http://www.cc.gatech.edu/~vmahali1/logs/published-info-cnn.txt<br></a><br>Thanks in advance,<br>Visu M<br>