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

[Daniel-Constantin Mierla]

Hello,


On 24/03/15 18:03, Janoz wrote:
> I am having the same error here, applying the back ticks patch is not
> working. Looks like the back ticks are not finding their way to the SQL
> quesry, as I get this error:
>
> [2015-03-24 16:41:38 (GMT)] An exception occurred while executing this
> script:
> Error message: #0, Error in 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' LIMIT 10. SQLSTATE[42000]*: Syntax error or access
> violation: 1064 You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> 'group T0 INNER JOIN user_group TX ON TX.group_id = T0.id WHERE TX.user_id =
> '1' at line 1
> Script name and line number of error:
> /var/www/siremis-4.2.0/openbiz/bin/data/BizDataObj_Lite.php:447
>
> function: _run_search ( Array(2) ) @
> /var/www/siremis-4.2.0/openbiz/bin/data/BizDataObj_Lite.php 243 
> function: fetch ( ) @ /var/www/siremis-4.2.0/openbiz/bin/easy/EasyForm.php
> 690 
> function: fetchDataSet ( ) @
> /var/www/siremis-4.2.0/openbiz/bin/easy/FormRenderer.php 69 
> function: renderSmarty ( Object(EasyForm),
> "/var/www/siremis-4.2.0/siremis/themes/default/template/system_ri..." ) @
> /var/www/siremis-4.2.0/openbiz/bin/easy/FormRenderer.php 45 
> function: render ( Object(EasyForm) ) @
> /var/www/siremis-4.2.0/openbiz/bin/easy/EasyForm.php 1648 
> function: renderHTML ( ) @
> /var/www/siremis-4.2.0/openbiz/bin/easy/EasyForm.php 1538 
> function: render ( ) @
> /var/www/siremis-4.2.0/openbiz/bin/easy/ViewRenderer.php 83 
> function: renderSmarty ( Object(EasyView),
> "/var/www/siremis-4.2.0/siremis/themes/default/template/system_vi..." ) @
> /var/www/siremis-4.2.0/openbiz/bin/easy/ViewRenderer.php 40 
> function: render ( Object(EasyView) ) @
> /var/www/siremis-4.2.0/openbiz/bin/easy/EasyView.php 274 
> function: _render ( ) @ /var/www/siremis-4.2.0/openbiz/bin/easy/EasyView.php
> 237 
> function: render ( ) @ /var/www/siremis-4.2.0/openbiz/bin/BizController.php
> 221 
> function: renderView ( "system.view.UserDetailView", "", "", Null, "" ) @
> /var/www/siremis-4.2.0/openbiz/bin/BizController.php 107 
> function: dispatchRequest ( ) @
> /var/www/siremis-4.2.0/openbiz/bin/BizController.php 32 
> function: include_once (
> "/var/www/siremis-4.2.0/openbiz/bin/BizController.php" ) @
> /var/www/siremis-4.2.0/siremis/bin/controller.php 6 
> function: include ( "/var/www/siremis-4.2.0/siremis/bin/controller.php" ) @
> /var/www/siremis-4.2.0/siremis/bin/_forward.php 102 
> function: include ( "/var/www/siremis-4.2.0/siremis/bin/_forward.php" ) @
> /var/www/siremis-4.2.0/siremis/index.php 3
>
>
> FROM group doesn't show any back ticks.
>
> Do I have to change the table name and the php code? I'm worried about
> future upgrades, where these changes could be lost. Please advice, thanks.

wrote in a previous mail, looks like there is another place returning
the "group" table name. The right fix is to find that one and escape the
table name with back ticks. That part of the code is part of the
phpopenbiz/cubi framework used to build siremis with. It will be
investigated and fixed with the next chance, now being caught is some
activity out of normal working schedule.

Cheers,
Daniel

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