[SR-Users] Siremis error Call to a member function getQuoted()

[canuck15]

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 at 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 at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20150323/f6f266a9/attachment.html>