getDBTableQuoted causing query syntax errors

[ghost]

Setup

• Docker images
  • mysql:latest
  • Mysql 8.0.19
  • siremis-git
  • based off Dockerfile.debian10-gitdev
  • installed php-pgsql
• Steps to reproduce
  • Follow webui setup (check all 4 boxes)
  • Connecting to remote Postgres kamailio DB
  • log into webui as admin admin
  • select SIP Admin Menu
  • click any link in SIP Admin Menu

Error

Error message: #0, Error in query:: SELECT T0.id, T0.setid, T0.destination, T0.flags, T0.priority, T0.attrs, T0.description FROM `dispatcher` T0 LIMIT 10. SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "`" LINE 1: ...lags, T0.priority, T0.attrs, T0.description FROM `dispatche... ^
Script name and line number of error: /var/www/siremis/openbiz/bin/data/BizDataObj_Lite.php:447

function: _run_search ( Array(2) ) @ /var/www/siremis/openbiz/bin/data/BizDataObj_Lite.php 243
function: fetch ( ) @ /var/www/siremis/openbiz/bin/easy/EasyForm.php 690
function: fetchDataSet ( ) @ /var/www/siremis/openbiz/bin/easy/FormRenderer.php 69
function: renderSmarty ( Object(EasySiremisForm), "/var/www/siremis/siremis/modules/sipadmin/template/grid.tpl" ) @ /var/www/siremis/openbiz/bin/easy/FormRenderer.php 45
function: render ( Object(EasySiremisForm) ) @ /var/www/siremis/openbiz/bin/easy/EasyForm.php 1648
function: renderHTML ( ) @ /var/www/siremis/openbiz/bin/easy/EasyForm.php 1538
function: render ( ) @ /var/www/siremis/openbiz/bin/easy/ViewRenderer.php 83
function: renderSmarty ( Object(EasyView), "/var/www/siremis/siremis/modules/sipadmin/template/view.tpl" ) @ /var/www/siremis/openbiz/bin/easy/ViewRenderer.php 40
function: render ( Object(EasyView) ) @ /var/www/siremis/openbiz/bin/easy/EasyView.php 274
function: _render ( ) @ /var/www/siremis/openbiz/bin/easy/EasyView.php 237
function: render ( ) @ /var/www/siremis/openbiz/bin/BizController.php 221
function: renderView ( "sipadmin.view.DispatcherListView", "", "", Null, "" ) @ /var/www/siremis/openbiz/bin/BizController.php 107
function: dispatchRequest ( ) @ /var/www/siremis/openbiz/bin/BizController.php 32
function: include_once ( "/var/www/siremis/openbiz/bin/BizController.php" ) @ /var/www/siremis/siremis/bin/controller.php 6
function: include ( "/var/www/siremis/siremis/bin/controller.php" ) @ /var/www/siremis/siremis/bin/_forward.php 102
function: include ( "/var/www/siremis/siremis/bin/_forward.php" ) @ /var/www/siremis/siremis/index.php 3

Solution

• This could very well cause issues elsewhere. I have not run into issues with the limited testing I have done, which was just verifying I can add a dialplan to the db
• /openbiz/bin/BizSystem.php getDBTableQuoted
  • replace return "`".$value."`"; with return $value;

[miconda]

You comment is confusing in the way that you list Mysql 8.0.19, but then you have php-pgsql and connect to remote Postgres.

Postgres is not supported yet, see #8. If you want to work on Postgres support, that's appreciated and you are more than welcome. But has to be made in a way that doesn't break the MySQL support.

[miconda]

Closing due to long time inactivity.