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

[canuck15]

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
 > 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 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/9df8bd44/attachment.html>