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