<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hello,</p>
<p>you need a more recent version of kamailio, at least 4.3, to work
with siremis 4.4.</p>
<p>Cheers,<br>
Daniel<br>
</p>
<br>
<div class="moz-cite-prefix">On 31.05.17 20:38, Clive Churchyard |
Tech Cloud wrote:<br>
</div>
<blockquote
cite="mid:AAFA9F3C-322E-41EA-990A-9B087AFC4728@techcloud.global"
type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<div><span></span></div>
<div><span>Hi list </span><br>
<span></span><br>
<span>Having installed kamailio 4.2 and siremis 4.4 I now get
the below error when browsing to either the 'subscribers list'
or the 'location list' tried both deb8.8 and ubuntu 14.04
using MySQL and php5 with apache2</span></div>
<div><br>
<span></span><span style="background-color: rgba(255, 255, 255,
0);"><span style="font-weight: bold;">Error message: </span><font
style="font-weight: bold;">#0, Error in query:: SELECT
T0.id, T0.username, T0.domain, T0.contact, T0.received,
T0.path, T0.expires, T0.q, T0.callid, T0.cseq,
T0.last_modified, T0.flags, T0.cflags, T0.user_agent,
T0.socket, T0.methods, T0.ruid, T0.instance, T0.reg_id,
T0.server_id, T0.connection_id, T0.keepalive, T0.partition
FROM `location` T0 LIMIT 10. SQLSTATE[42S22]: Column not
found: 1054 Unknown column 'T0.server_id' in 'field list'</font><br
style="font-weight: bold;">
<span style="font-weight: bold;">Script name and line number
of error: </span><font style="font-weight: bold;">/var/www/siremis-4.4.0/openbiz/bin/data/BizDataObj_Lite.php:447</font></span><br>
<span></span><br>
<span>Any ideas please </span><br>
<span></span>Thanks</div>
<div>Clive<br>
<span>Sent from my iPhone</span></div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a>
<a class="moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a>
Kamailio Advanced Training - <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
Kamailio World Conference - <a class="moz-txt-link-abbreviated" href="http://www.kamailioworld.com">www.kamailioworld.com</a></pre>
</body>
</html>