From 19b09998f57d37c571830bed32c1090a424b91cb Mon Sep 17 00:00:00 2001 From: =?utf8?q?J=C3=A9r=C3=B4me=20Benoit?= Date: Sun, 1 Jul 2018 17:34:02 +0200 Subject: [PATCH] Ensure we do not try to return an empty array row. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Jérôme Benoit --- src/Controller/PersonController.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/src/Controller/PersonController.php b/src/Controller/PersonController.php index 49c456d..b34bb53 100644 --- a/src/Controller/PersonController.php +++ b/src/Controller/PersonController.php @@ -179,7 +179,10 @@ class PersonController extends FOSRestController private function getLastLocalisation($em, $id) { $query = $em->createQuery("SELECT l1 FROM App\Entity\Localisation l1 WHERE l1.person = :person and l1.timestamp = (SELECT MAX(l2.timestamp) FROM App\Entity\Localisation l2 WHERE l2.person = l1.person)"); $query->setParameter('person', $id); - return $query->getResult()[0]; + $result = $query->getResult(); + if (!empty($result)) { + return $result[0]; + } } /** -- 2.34.1