pimcore/customer-data-framework

[Task] Verfiy identifyer quoting for formerly automatically quoted db calls

fashxp opened this issue · 1 comments

fashxp commented

Improvement description

related to pimcore/pimcore#13392

check for

  • ->update(
  • ->insert(
kingjia90 commented

HIDDEN reason: this doesn't seem related to this change of db->update() and db->insert() but it's a raw sql input error in SELECT

image

#3 /var/www/html/vendor/doctrine/dbal/src/Connection.php(585): Doctrine\DBAL\Connection->executeQuery('SELECT COUNT(*)...', Array, Array)
#4 /var/www/html/dev/pimcore/pimcore/bundles/CustomReportsBundle/src/Tool/Adapter/Sql.php(38): Doctrine\DBAL\Connection->fetchOne('SELECT COUNT(*)...')
#5 /var/www/html/dev/pimcore/pimcore/bundles/CustomReportsBundle/src/Controller/Reports/CustomReportController.php(343): Pimcore\Bundle\CustomReportsBundle\Tool\Adapter\Sql->getData(NULL, NULL, NULL, 0, 50, NULL, NULL)

it would work if i manually quote it here
image