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: >> 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: >>> 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 >>>> >>> >>> >>> >>> _______________________________________________ >>> 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 > > > > _______________________________________________ > 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
