<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Looks like there is another place used to return the "group" table
name. Once I get some time, I am going to look at the code and try
to spot the place where backticks have to be added for "group".<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 24/03/15 15:41, canuck15 wrote:<br>
</div>
<blockquote
cite="mid:BLU436-SMTP1424E8A27D6DC876A88A6DBDA0A0@phx.gbl"
type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
Thanks for the suggestion.<br>
<br>
It doesn't seem to work. It produces the following query.<br>
<br>
<span style="color: rgb(128, 0, 0); font-family: Arial; font-size:
12px; font-style: normal; font-variant: normal; font-weight:
bold; letter-spacing: normal; line-height: 18px; orphans: auto;
text-align: left; 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, 215, 216);">SELECT
T0.id, T0.name, T0.description FROM group T0 INNER JOIN
`user_group` TX ON TX.group_id = T0.id WHERE TX.user_id = '1'</span><br>
<br>
<div class="moz-cite-prefix">On 3/23/2015 2:59 PM,
Daniel-Constantin Mierla wrote:<br>
</div>
<blockquote cite="mid:55108CAC.60207@gmail.com" type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
The right solution is to enclose the table name in between the
quotations marks that allow any value there, including the
reserved keywords.<br>
<br>
In mysql you can use the back ticks, e.g:<br>
<br>
SELECT * FROM `group`;<br>
<br>
The above will just work. But is not standard SQL, just mysql
specific. That was the purpose of the getQuoted() function,
which came as patch to make siremis work with postgress. But
apparently the patch was not dealing with the association case.
IIRC, postgress uses double quotes instead of back ticks.<br>
<br>
As a shorter fix would be using:<br>
<br>
$xtable = "`" . $assoc["XTable"] . "`";<br>
<br>
In this way, you don't need to rename the table and change the
name of it on php code.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 23/03/15 16:20, canuck15 wrote:<br>
</div>
<blockquote
cite="mid:BLU436-SMTP241B608072C172C68D060F1DA0D0@phx.gbl"
type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
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>
<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>
<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>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a 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 class="moz-txt-link-freetext" href="http://www.kamailioworld.com">http://www.kamailioworld.com</a></pre>
</body>
</html>