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