Symfony (3.2.6) SQL Error not ([Semantical ]第0行，第39行，靠近“泊车罚单设置”：Error:类“parking_ticket_settings”未定义)。

Question

我对Symfony中的SQL查询有问题(3.2.6)。

我试图运行以下代码：

$em->persist($AxfonePushPayment);
$query = $em->createQuery("SELECT parking_ticket_settings.id FROM parking_ticket_settings JOIN zone z ON(z.id = parking_ticket_settings.zone_id) WHERE z.zone_identifier = '" . $AxfonePushPayment->getZone() . "'");

$ptsID = $query->getResult();

但是这个错误出现了：

Uncaught PHP Exception Doctrine\ORM\Query\QueryException: "[Semantical Error] line 0, col 39 near 'parking_ticket_settings': Error: Class 'parking_ticket_settings' is not defined." at /var/www/app.clickpark.cz/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php line 63 {"exception":"[object] (Doctrine\\ORM\\Query\\QueryException(code: 0): [Semantical Error] line 0, col 39 near 'parking_ticket_settings': Error: Class 'parking_ticket_settings' is not defined. at /var/www/app.clickpark.cz/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:63, Doctrine\\ORM\\Query\\QueryException(code: 0): SELECT parking_ticket_settings.id FROM parking_ticket_settings JOIN zone z ON(z.id = parking_ticket_settings.zone_id) WHERE z.zone_identifier = 'BERF' at /var/www/app.clickpark.cz/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:41)"}

当我在mysql中执行查询时，它正常工作。

有人知道问题出在哪里吗？

非常感谢!

Answer 1

您需要提供实体类名，而不是表名。

$em = $this->getDoctrine()->getManager();
$query = $em->createQuery('SELECT p FROM AppBundle:ParkingTicketSettings p')
$ptsID = $query->getResult();