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