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-funct... Sent from the Users mailing list archive at Nabble.com.