datatables-bundle
datatables-bundle copied to clipboard
With doctrine/orm 3.1: Error: Expected Doctrine\ORM\Query\TokenType::T_FROM, got '.'
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.