No result was found for query although at least one row was expected.

Stack Trace

1. in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php at line 807 
   804.         $result = $this->execute(null, $hydrationMode);
   806.         if ($this->_hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
   807.             throw new NoResultException;
   808.         }
   810.         if ( ! is_array($result)) {
2. at AbstractQuery ->getSingleResult ()
   in src/GG/BackendBundle/Services/RoomsService.php at line 34 
3. at RoomsService ->GetById ('{$value.id$}{$value.friendlyUrl$}')
   in src/GG/FrontendBundle/Controller/RoomController.php at line 36 
   33.         $this->storeId = 6;
   34.         $request->getSession()->set('currentStoreId', 6);
   35.         $this->generalSettingsId = 1;
   36.         $room = $this->get(GGBackendBundle::ROOMS_SERVICE)->GetById($id);
   37.         $this->storeId = $request->getSession()->get('currentStoreId');
   38.         if (intval($room['storeId']) != $this->storeId) {
   39.             return $this->redirectToRoute('arxiki');
4. at RoomController ->indexAction (object(Request), '{$value.id$}{$value.friendlyUrl$}', '')
5. at call_user_func_array (array(object(RoomController), 'indexAction'), array(object(Request), '{$value.id$}{$value.friendlyUrl$}', ''))
   in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php at line 142 
   139.         $arguments = $this->resolver->getArguments($request, $controller);
   141.         // call controller
   142.         $response = call_user_func_array($controller, $arguments);
   144.         // view
   145.         if (!$response instanceof Response) {
6. at HttpKernel ->handleRaw (object(Request), '1')
   in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php at line 62 
   59.         $request->headers->set('X-Php-Ob-Level', ob_get_level());
   61.         try {
   62.             return $this->handleRaw($request, $type);
   63.         } catch (\Exception $e) {
   64.             if ($e instanceof ConflictingHeadersException) {
   65.                 $e = new BadRequestHttpException('The request headers contain conflicting information regarding the origin of this request.', $e);
7. at HttpKernel ->handle (object(Request), '1', true)
   in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/DependencyInjection/ContainerAwareHttpKernel.php at line 67 
   64.         $this->container->set('request', $request, 'request');
   66.         try {
   67.             $response = parent::handle($request, $type, $catch);
   68.         } catch (\Exception $e) {
   69.             $this->container->set('request', null, 'request');
   70.             $this->container->leaveScope('request');
8. at ContainerAwareHttpKernel ->handle (object(Request), '1', true)
   in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php at line 183 
   180.             $this->boot();
   181.         }
   183.         return $this->getHttpKernel()->handle($request, $type, $catch);
   184.     }
   186.     /**
9. at Kernel ->handle (object(Request))
   in web/app.php at line 25 
   22. // When using the HttpCache, you need to call the method in your front controller instead of relying on the configuration parameter
   23. //Request::enableHttpMethodParameterOverride();
   24. $request = Request::createFromGlobals();
   25. $response = $kernel->handle($request);
   26. $response->send();
   27. $kernel->terminate($request, $response);

Stack Trace (Plain Text) 

[1] Doctrine\ORM\NoResultException: No result was found for query although at least one row was expected.
    at n/a
        in /var/www/vhosts/saybooth.gr/bgae.lobsters.gr/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php line 807

    at Doctrine\ORM\AbstractQuery->getSingleResult()
        in /var/www/vhosts/saybooth.gr/bgae.lobsters.gr/src/GG/BackendBundle/Services/RoomsService.php line 34

    at GG\BackendBundle\Services\RoomsService->GetById('{$value.id$}{$value.friendlyUrl$}')
        in /var/www/vhosts/saybooth.gr/bgae.lobsters.gr/src/GG/FrontendBundle/Controller/RoomController.php line 36

    at GG\FrontendBundle\Controller\RoomController->indexAction(object(Request), '{$value.id$}{$value.friendlyUrl$}', '')
        in  line 

    at call_user_func_array(array(object(RoomController), 'indexAction'), array(object(Request), '{$value.id$}{$value.friendlyUrl$}', ''))
        in /var/www/vhosts/saybooth.gr/bgae.lobsters.gr/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 142

    at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), '1')
        in /var/www/vhosts/saybooth.gr/bgae.lobsters.gr/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 62

    at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), '1', true)
        in /var/www/vhosts/saybooth.gr/bgae.lobsters.gr/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/DependencyInjection/ContainerAwareHttpKernel.php line 67

    at Symfony\Component\HttpKernel\DependencyInjection\ContainerAwareHttpKernel->handle(object(Request), '1', true)
        in /var/www/vhosts/saybooth.gr/bgae.lobsters.gr/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php line 183

    at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
        in /var/www/vhosts/saybooth.gr/bgae.lobsters.gr/web/app.php line 25