datatables-bundle icon indicating copy to clipboard operation
datatables-bundle copied to clipboard

With doctrine/orm 3.1: Error: Expected Doctrine\ORM\Query\TokenType::T_FROM, got '.'

Open knallcharge opened this issue 11 months ago • 6 comments

Hi,

I tried updating my project to use doctrine/orm 3.1 today (from 2) and now I'm getting the following error:

"[Syntax Error] line 0, col 20: Error: Expected Doctrine\ORM\Query\TokenType::T_FROM, got '.'"

The datatable I'm using is pretty straightforward, this is my code:

$dataTable = $dataTableFactory->create()
                              ->add('id', NumberColumn::class)
                              ->add('created', DateTimeColumn::class, ['format' => 'd. M Y H:i:s', 'searchable' => false])
                              ->add('fileName', TextColumn::class)
                              ->add('filePath', TextColumn::class, ['visible' => false])
                              ->add('uploader', TextColumn::class, ['field' => 'uploader.loginName'])
                              ->add('mimeType', TextColumn::class)
                              ->add(
                                  'fileSize',
                                  NumberColumn::class,
                                  [
                                      'render' => static fn($value, $context) => Binary::bytes($value)->format('/2'),
                                  ]
                              )
                              ->add('Link', TwigColumn::class, ['template' => 'tables/link.html.twig'])
                              ->addOrderBy('id', DataTable::SORT_DESCENDING)
                              ->createAdapter(ORMAdapter::class, [
                                  'entity' => Image::class,
                              ])
                              ->handleRequest($request);

I have tried to remove one column after the other to check whether that makes a difference, but it doesn't.

This is the full stacktrace:

Doctrine\ORM\Query\QueryException: [Syntax Error] line 0, col 20: Error: Expected Doctrine\ORM\Query\TokenType::T_FROM, got '.'


  at (...)\vendor\doctrine\orm\src\Query\QueryException.php:23
  at Doctrine\ORM\Query\QueryException::syntaxError('line 0, col 20: Error: Expected Doctrine\\ORM\\Query\\TokenType::T_FROM, got \'.\'', object(QueryException))
     ((...)\vendor\doctrine\orm\src\Query\Parser.php:396)
  at Doctrine\ORM\Query\Parser->syntaxError('Doctrine\\ORM\\Query\\TokenType::T_FROM')
     ((...)\vendor\doctrine\orm\src\Query\Parser.php:273)
  at Doctrine\ORM\Query\Parser->match(object(TokenType))
     ((...)\vendor\doctrine\orm\src\Query\Parser.php:1180)
  at Doctrine\ORM\Query\Parser->FromClause()
     ((...)\vendor\doctrine\orm\src\Query\Parser.php:769)
  at Doctrine\ORM\Query\Parser->SelectStatement()
     ((...)\vendor\doctrine\orm\src\Query\Parser.php:740)
  at Doctrine\ORM\Query\Parser->QueryLanguage()
     ((...)\vendor\doctrine\orm\src\Query\Parser.php:221)
  at Doctrine\ORM\Query\Parser->getAST()
     ((...)\vendor\doctrine\orm\src\Query\Parser.php:309)
  at Doctrine\ORM\Query\Parser->parse()
     ((...)\vendor\doctrine\orm\src\Query.php:236)
  at Doctrine\ORM\Query->parse()
     ((...)\vendor\doctrine\orm\src\Query.php:183)
  at Doctrine\ORM\Query->getResultSetMapping()
     ((...)\vendor\doctrine\orm\src\AbstractQuery.php:863)
  at Doctrine\ORM\AbstractQuery->toIterable(array(), 1)
     ((...)\vendor\doctrine\orm\src\Query.php:594)
  at Doctrine\ORM\Query->toIterable(array(), 1)
     ((...)\vendor\omines\datatables-bundle\src\Adapter\Doctrine\ORMAdapter.php:191)
  at Omines\DataTablesBundle\Adapter\Doctrine\ORMAdapter->getResults(object(Query))
     ((...)\vendor\omines\datatables-bundle\src\Adapter\AbstractAdapter.php:44)
  at Omines\DataTablesBundle\Adapter\AbstractAdapter->getData(object(DataTableState))
     ((...)\vendor\omines\datatables-bundle\src\DataTable.php:317)
  at Omines\DataTablesBundle\DataTable->getResultSet()
     ((...)\vendor\omines\datatables-bundle\src\DataTable.php:276)
  at Omines\DataTablesBundle\DataTable->getResponse()
     ((...)\src\Controller\IndexController.php:88)
  at App\Controller\IndexController->gallery(object(Request), object(DataTableFactory))
     ((...)\vendor\symfony\http-kernel\HttpKernel.php:178)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     ((...)\vendor\symfony\http-kernel\HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     ((...)\vendor\symfony\http-kernel\Kernel.php:185)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     ((...)\vendor\symfony\runtime\Runner\Symfony\HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     ((...)\vendor\autoload_runtime.php:29)
  at require_once('(...)\\vendor\\autoload_runtime.php')
     ((...)\public\index.php:6)

I tried to downgrade doctrine/orm to 3.0 but the error remains.

knallcharge avatar Mar 19 '24 10:03 knallcharge