<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hello Martin,<br>
<br>
Do you see (in apache logs or postgres logs) the actual query
performed by CP 6.2? It will help to see if there is something
wrong in it. Or at least some error logs....<br>
<br>
In the Users tab, do you apply some filters ? or you get the error
when listing all users (without any filtering) ?<br>
<br>
Best regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a>
OpenSIPS Summit May 2017 Amsterdam
<a class="moz-txt-link-freetext" href="http://www.opensips.org/events/Summit-2017Amsterdam.html">http://www.opensips.org/events/Summit-2017Amsterdam.html</a>
</pre>
<div class="moz-cite-prefix">On 03/29/2017 12:11 PM, M L wrote:<br>
</div>
<blockquote
cite="mid:HE1PR10MB055619B17949D16ABB15DD6AB3350@HE1PR10MB0556.EURPRD10.PROD.OUTLOOK.COM"
type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
<div id="divtagdefaultwrapper"
style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;"
dir="ltr">
<p>Hi,</p>
<p><br>
</p>
<p>I just want to give a heads-up that control panel 6.2 does
not work with postgres when using user management. It gives
some MDB2 errors.
<br>
</p>
<p>It is related to changed behaviour of select syntax between
6.1 and 6.2.</p>
<p><br>
</p>
<p>In 6.2 you will find this select syntax in
user_management.main.php<br>
</p>
<p><span>Line 185<br>
</span></p>
<p><span>$sql_command="from ".$table." s ".$sql_search." order
by s.id asc";</span></p>
<p>Line 193</p>
<p><span>$resultset = $link->queryAll("select count(*)
".$sql_command);</span></p>
<p><span><br>
</span></p>
<p><span>In 6.1 that still works with postgres for user
management and opensips 2.2 select syntax is:</span></p>
<p><span></span>Line 157</p>
<p><span>$sql_command="select * from ".$table." s where (1=1)
".$sql_search." order by s.id asc";</span></p>
<p>Line 166 <br>
</p>
<p><span>$resultset = $link->queryAll($sql_command);</span></p>
<p><span><br>
</span></p>
<p><span>Not sure reason of why select syntax is changed in 6.2
but you should correct it so it works for postgres.
Meanwhile a workaround is to use cp 6.1 if you use pgsql as
db for opensips.</span></p>
<p><span><br>
</span></p>
<p><span>Regards,</span></p>
<p><span>Martin</span><br>
</p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>