<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi,<br>
<br>
I figured that part out which is when I got the database error about
the "group" table. So I will need to find where to change that
table name. I should have mentioned that.<br>
<br>
<div class="moz-cite-prefix">On 3/23/2015 1:18 AM, Daniel-Constantin
Mierla wrote:<br>
</div>
<blockquote cite="mid:550FCC44.2000509@gmail.com" type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
The issue is calling a function which is not member of the object
referred to.<br>
<br>
We will look into fixing it properly, for the moment do following
changes:<br>
<br>
- editi the file: <span style="color: rgb(51, 51, 51);
font-family: 'Helvetica Neue', Helvetica, 'Segoe UI', Arial,
freesans, sans-serif; font-size: 14px; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing:
normal; line-height: 22.3999996185303px; orphans: auto;
text-align: start; text-indent: 0px; text-transform: none;
white-space: normal; widows: 1; word-spacing: 0px;
-webkit-text-stroke-width: 0px; display: inline !important;
float: none; background-color: rgb(255, 255, 255);">/var/www/html/openbiz/bin/data/BizDataSql.php<br>
- go to line 237</span><br>
- replace the line with:<br>
<br>
$xtable = $assoc["XTable"];<br>
<br>
Thanks for reporting and troubleshooting.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 23/03/15 02:52, canuck15 wrote:<br>
</div>
<blockquote
cite="mid:BLU437-SMTP6641AFC37E0BA0C89F409EDA0D0@phx.gbl"
type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
I think I found the root cause.<br>
<br>
Siremis database has a table called "group". That is a reserved
word in mysql that cannot be used as a table name.<br>
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html">http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html</a><br>
<br>
Do the following to prove it.<br>
mysql<br>
> USE siremis;<br>
> SELECT * FROM group;<br>
<br>
error<br>
<br>
> RENAME TABLE group TO group1;<br>
> SELECT * FROM group1;<br>
<br>
no error<br>
<br>
<div class="moz-cite-prefix">On 3/21/2015 4:39 PM, canuck15
wrote:<br>
</div>
<blockquote
cite="mid:BLU436-SMTP9166C1D95F4229D900C771DA0F0@phx.gbl"
type="cite">
<meta http-equiv="content-type" content="text/html;
charset=windows-1252">
When you add/update/view Administrator usernames<br>
<br>
To reproduce<br>
Administration > User Management ><br>
<br>
Click on any existing username. The browser goes blank.<br>
<span style="color: rgb(51, 51, 51); font-family: 'Helvetica
Neue', Helvetica, 'Segoe UI', Arial, freesans, sans-serif;
font-size: 14px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height:
22.3999996185303px; orphans: auto; text-align: start;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 1; word-spacing: 0px; -webkit-text-stroke-width:
0px; display: inline !important; float: none;
background-color: rgb(255, 255, 255);"><br>
Error in apache logs is:</span><br style="box-sizing:
border-box; color: rgb(51, 51, 51); font-family: 'Helvetica
Neue', Helvetica, 'Segoe UI', Arial, freesans, sans-serif;
font-size: 14px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height:
22.3999996185303px; orphans: auto; text-align: start;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 1; word-spacing: 0px; -webkit-text-stroke-width:
0px; background-color: rgb(255, 255, 255);">
<span style="color: rgb(51, 51, 51); font-family: 'Helvetica
Neue', Helvetica, 'Segoe UI', Arial, freesans, sans-serif;
font-size: 14px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height:
22.3999996185303px; orphans: auto; text-align: start;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 1; word-spacing: 0px; -webkit-text-stroke-width:
0px; display: inline !important; float: none;
background-color: rgb(255, 255, 255);">PHP Fatal error: Call
to a member function getQuoted() on a non-object in
/var/www/html/openbiz/bin/data/BizDataSql.php on line 237</span><br
style="box-sizing: border-box; color: rgb(51, 51, 51);
font-family: 'Helvetica Neue', Helvetica, 'Segoe UI', Arial,
freesans, sans-serif; font-size: 14px; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing:
normal; line-height: 22.3999996185303px; orphans: auto;
text-align: start; text-indent: 0px; text-transform: none;
white-space: normal; widows: 1; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255,
255, 255);">
<span style="color: rgb(51, 51, 51); font-family: 'Helvetica
Neue', Helvetica, 'Segoe UI', Arial, freesans, sans-serif;
font-size: 14px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height:
22.3999996185303px; orphans: auto; text-align: start;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 1; word-spacing: 0px; -webkit-text-stroke-width:
0px; display: inline !important; float: none;
background-color: rgb(255, 255, 255);">This is on the latest
Siremis v4.2.0 downloaded today</span><br>
<br>
I am using CentOS v6.6, php v5.3.3<br>
<br>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://twitter.com/#%21/miconda">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, May 27-29, 2015
Berlin, Germany - <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.kamailioworld.com">http://www.kamailioworld.com</a></pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
</body>
</html>