Error 500 Internal Server Error

GET https://staging.consentz.com/get_subtreatments/testclinic

Browse referrer URL
IP
74.7.242.24
Profiled on
Token
7e871b

Exceptions

MissingIdentifierField

HTTP 500 Internal Server Error

The identifier id is missing for a query of App\Entity\Clinic\Stock\TreatmentClinic

Exception

Doctrine\ORM\Exception\ MissingIdentifierField

in vendor/doctrine/orm/src/Exception/MissingIdentifierField.php (line 15)
  2. final class MissingIdentifierField extends LogicException implements ManagerException
  3. {
  4. public static function fromFieldAndClass(string $fieldName, string $className): self
  5. {
  6. return new self(sprintf(
  7. 'The identifier %s is missing for a query of %s',
  8. $fieldName,
  9. $className,
  10. ));
  11. }
in vendor/doctrine/orm/src/EntityManager.php :: fromFieldAndClass (line 307)
  2. $sortedId = [];
  4. foreach ($class->identifier as $identifier) {
  5. if (! isset($id[$identifier])) {
  6. throw MissingIdentifierField::fromFieldAndClass($identifier, $class->name);
  7. }
  9. if ($id[$identifier] instanceof BackedEnum) {
  10. $sortedId[$identifier] = $id[$identifier]->value;
  11. } else {
in vendor/doctrine/orm/src/EntityRepository.php -> find (line 86)
  1. * @return object|null The entity instance or NULL if the entity can not be found.
  2. * @phpstan-return ?T
  3. */
  4. public function find(mixed $id, LockMode|int|null $lockMode = null, int|null $lockVersion = null): object|null
  5. {
  6. return $this->em->find($this->entityName, $id, $lockMode, $lockVersion);
  7. }
  9. /**
  10. * Finds all entities in the repository.
  11. *
EntityRepository->find() in src/Controller/PublicProfileController.php (line 629)
  1. #[Route(path: '/get_subtreatments/{subDomain}', name: 'get_subtreatments')]
  2. public function getSubTreatments(Request $request): Response
  3. {
  4. $treatmentId = $request->get('treatment');
  5. $em = $this->doctrine->getManager();
  6. $treatment = $em->getRepository(TreatmentClinic::class)->find($treatmentId);
  7. $query = $query = " SELECT * FROM price_list WHERE treatment_id = $treatmentId and availability_online = 1";
  8. $subTreatments = $em->getConnection()->executeQuery($query)->fetchAllAssociative();
  9. if ($subTreatments) {
  10. $html = $this->render('sub_treatments.html.twig', [
  11. 'subTreatments' => $subTreatments,
in vendor/symfony/http-kernel/HttpKernel.php -> getSubTreatments (line 183)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  5. // call controller
  6. $response = $controller(...$arguments);
  8. // view
  9. if (!$response instanceof Response) {
  10. $event = new ViewEvent($this, $request, $type, $response, $event);
  11. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $this->handleRaw($request, $type);
  7. } catch (\Throwable $e) {
  8. if ($e instanceof \Error && !$this->handleAllThrowables) {
  9. throw $e;
  10. }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 193)
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  5. try {
  6. return $this->getHttpKernel()->handle($request, $type, $catch);
  7. } finally {
  8. --$this->requestStackSize;
  9. }
  10. }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. if (Kernel::VERSION_ID >= 60400) {
  9. $response->send(false);
  11. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/www/wwwroot/consentz/vendor/autoload_runtime.php') in public/index.php (line 4)
  1. <?php
  2. use App\Kernel;
  4. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  6. return static function (array $context) {
  7. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  8. };

Logs

Level Channel Message
INFO 01:48:58 deprecation Deprecated: App\EventListener\DoctrineExtensionSubscriber::__construct(): Optional parameter $blameableListener declared before required parameter $tokenStorage is implicitly treated as a required parameter 
{
    "exception": {}
}
INFO 01:48:58 deprecation Deprecated: App\EventListener\RateLimitSubscriber::__construct(): Implicitly marking parameter $tokenStorage as nullable is deprecated, the explicit nullable type must be used instead 
{
    "exception": {}
}
INFO 01:48:58 deprecation Deprecated: App\Service\RateLimiter\RateLimiterService::__construct(): Implicitly marking parameter $redis as nullable is deprecated, the explicit nullable type must be used instead 
{
    "exception": {}
}
INFO 01:48:58 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "7e871b"
    },
    "request_uri": "https://staging.consentz.com/_profiler/7e871b?panel=exception&type=request",
    "method": "GET"
}

Stack Trace

MissingIdentifierField 
Doctrine\ORM\Exception\MissingIdentifierField:
The identifier id is missing for a query of App\Entity\Clinic\Stock\TreatmentClinic

  at vendor/doctrine/orm/src/Exception/MissingIdentifierField.php:15
  at Doctrine\ORM\Exception\MissingIdentifierField::fromFieldAndClass()
     (vendor/doctrine/orm/src/EntityManager.php:307)
  at Doctrine\ORM\EntityManager->find()
     (vendor/doctrine/orm/src/EntityRepository.php:86)
  at Doctrine\ORM\EntityRepository->find()
     (src/Controller/PublicProfileController.php:629)
  at App\Controller\PublicProfileController->getSubTreatments()
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:193)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:32)
  at require_once('/www/wwwroot/consentz/vendor/autoload_runtime.php')
     (public/index.php:4)