<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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 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>