25 Mar
2015
25 Mar
'15
8:43 a.m.
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".
Cheers,
Daniel
On 24/03/15 15:41, canuck15 wrote:
Thanks for the suggestion.
It doesn't seem to work. It produces the following query.
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'
On 3/23/2015 2:59 PM, Daniel-Constantin Mierla wrote:
--
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, May 27-29, 2015
Berlin, Germany - http://www.kamailioworld.com
The right solution is to enclose the table name
in between the
quotations marks that allow any value there, including the reserved
keywords.
In mysql you can use the back ticks, e.g:
SELECT * FROM `group`;
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.
As a shorter fix would be using:
$xtable = "`" . $assoc["XTable"] . "`";
In this way, you don't need to rename the table and change the name
of it on php code.
Cheers,
Daniel
On 23/03/15 16:20, canuck15 wrote:
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users Ok, so the complete fix is:
edit ...openbiz/bin/data/BizDataSql.php
go to line 237
replace the line with.
$xtable = $assoc["XTable"];
mysql -p
--
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, May 27-29, 2015
Berlin, Germany - http://www.kamailioworld.com
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users USE siremis;
RENAME TABLE group TO grouptable;
Or pick some other new name for the group table.
edit ..siremis/modules/system/do
Go through all the files in that directory and change
Table="group"
To
Table="grouptable"
Or whatever the new name given to the group table is. Now it all
seems to work.
On 3/23/2015 7:03 AM, canuck15 wrote:
Hi,
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.
On 3/23/2015 1:18 AM, Daniel-Constantin Mierla wrote:
> The issue is calling a function which is not member of the object
> referred to.
>
> We will look into fixing it properly, for the moment do following
> changes:
>
> - editi the file: /var/www/html/openbiz/bin/data/BizDataSql.php
> - go to line 237
> - replace the line with:
>
> $xtable = $assoc["XTable"];
>
> Thanks for reporting and troubleshooting.
>
> Cheers,
> Daniel
>
> On 23/03/15 02:52, canuck15 wrote:
>> I think I found the root cause.
>>
>> Siremis database has a table called "group". That is a reserved
>> word in mysql that cannot be used as a table name.
>> http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html
>>
>> Do the following to prove it.
>> mysql
>> > USE siremis;
>> > SELECT * FROM group;
>>
>> error
>>
>> > RENAME TABLE group TO group1;
>> > SELECT * FROM group1;
>>
>> no error
>>
>> On 3/21/2015 4:39 PM, canuck15 wrote:
>>> When you add/update/view Administrator usernames
>>>
>>> To reproduce
>>> Administration > User Management >
>>>
>>> Click on any existing username. The browser goes blank.
>>>
>>> Error in apache logs is:
>>> 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
>>> This is on the latest Siremis v4.2.0 downloaded today
>>>
>>> I am using CentOS v6.6, php v5.3.3
>>>
>>
>>
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users(a)lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
> --
> Daniel-Constantin Mierla
> http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
> Kamailio World Conference, May 27-29, 2015
> Berlin, Germany - http://www.kamailioworld.com
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users(a)lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users