<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Ok, so the complete fix is:<br>
<br>
edit <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);">...openbiz/bin/data/BizDataSql.php<br>
go to line 237</span><br>
replace the line with.<br>
<br>
$xtable = $assoc["XTable"];<br>
<br>
mysql -p<br>
> USE siremis;<br>
> RENAME TABLE group TO grouptable;<br>
<br>
Or pick some other new name for the group table.<br>
<br>
edit ..siremis/modules/system/do<br>
<br>
Go through all the files in that directory and change <br>
Table="group"<br>
<br>
To<br>
<br>
Table="grouptable"<br>
<br>
Or whatever the new name given to the group table is. Now it all
seems to work.<br>
<br>
<br>
<div class="moz-cite-prefix">On 3/23/2015 7:03 AM, canuck15 wrote:<br>
</div>
<blockquote
cite="mid:BLU436-SMTP119FE1AD87540016975B03FDA0D0@phx.gbl"
type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
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 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>
</blockquote>
<br>
</body>
</html>