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

Janoz janoz at iol.it
Tue Mar 24 18:03:01 CET 2015


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





--
View this message in context: http://sip-router.1086192.n5.nabble.com/Siremis-error-Call-to-a-member-function-getQuoted-tp136417p136469.html
Sent from the Users mailing list archive at Nabble.com.



More information about the sr-users mailing list