Error 500 Internal Server Error

GET https://imobiliare.n46.net/en/residential-complexes

IP
216.73.216.102
Profiled on
Token
843913

Exceptions

PDOException Exception InvalidFieldNameException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a0_.instagram_reel_id' in 'SELECT'

Exceptions 3

Doctrine\DBAL\Exception\ InvalidFieldNameException

Show exception properties 
Doctrine\DBAL\Exception\InvalidFieldNameException {#992
  -query: Doctrine\DBAL\Query {#1277
    -sql: "SELECT a0_.id AS id_0, a0_.cadastral_id AS cadastral_id_1, ST_AsText(a0_.multipolygon_moldref) AS multipolygon_moldref_2, ST_AsText(a0_.multipolygon) AS multipolygon_3, ST_AsText(a0_.centroid) AS centroid_4, a0_.land_area AS land_area_5, a0_.name AS name_6, a0_.rcslug AS rcslug_7, a0_.address AS address_8, a0_.instagram_reel_id AS instagram_reel_id_9, a0_.price_per_square_meter AS price_per_square_meter_10, a0_.completion_date AS completion_date_11, a0_.is_sold_out AS is_sold_out_12, a0_.client_status AS client_status_13, a0_.server_status AS server_status_14, a0_.views AS views_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, a0_.company_id AS company_id_18, a0_.locality_id AS locality_id_19 FROM ax_residential_complex a0_ WHERE a0_.client_status = ? AND a0_.server_status = ? ORDER BY a0_.name ASC LIMIT 10"
    -params: array:2 [
      0 => "active"
      1 => "ok"
    ]
    -types: array:2 [
      0 => Doctrine\DBAL\ParameterType {#1141
        +name: "STRING"
      }
      1 => Doctrine\DBAL\ParameterType {#1141}
    ]
  }
}
in vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php (line 63)
  1. 1557,
  2. 1569,
  3. 1586 => new UniqueConstraintViolationException($exception, $query),
  4. 1054,
  5. 1166,
  6. 1611 => new InvalidFieldNameException($exception, $query),
  7. 1052,
  8. 1060,
  9. 1110 => new NonUniqueFieldNameException($exception, $query),
  10. 1064,
  11. 1149,
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1460)
  1. private function handleDriverException(
  2. Driver\Exception $driverException,
  3. ?Query $query,
  4. ): DriverException {
  5. $this->exceptionConverter ??= $this->driver->getExceptionConverter();
  6. $exception = $this->exceptionConverter->convert($driverException, $query);
  8. if ($exception instanceof ConnectionLost) {
  9. $this->close();
  10. }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1396)
  1. Driver\Exception $e,
  2. string $sql,
  3. array $params = [],
  4. array $types = [],
  5. ): DriverException {
  6. return $this->handleDriverException($e, new Query($sql, $params, $types));
  7. }
  9. /** @internal */
  10. final public function convertException(Driver\Exception $e): DriverException
  11. {
in vendor/doctrine/dbal/src/Connection.php -> convertExceptionDuringQuery (line 809)
  1. $result = $connection->query($sql);
  2. }
  4. return new Result($result, $this);
  5. } catch (Driver\Exception $e) {
  6. throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
  7. }
  8. }
  10. /**
  11. * Executes a caching query.
in vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php -> executeQuery (line 27)
  1. /**
  2. * {@inheritDoc}
  3. */
  4. public function execute(Connection $conn, array $params, array $types): Result
  5. {
  6. return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);
  7. }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 296)
  1. $sqlParams,
  2. $types,
  3. $this->em->getConnection()->getParams(),
  4. );
  6. return $executor->execute($this->em->getConnection(), $sqlParams, $types);
  7. }
  9. /**
  10. * @param array<string,mixed> $sqlParams
  11. * @param array<string,Type> $types
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 930)
  1. $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2. $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3. };
  4. }
  6. $stmt = $this->_doExecute();
  8. if (is_numeric($stmt)) {
  9. $setCacheEntry($stmt);
  11. return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 886)
  1. ): mixed {
  2. if ($this->cacheable && $this->isCacheEnabled()) {
  3. return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4. }
  6. return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7. }
  9. /**
  10. * Execute query ignoring second level cache.
  11. *
in vendor/doctrine/orm/src/AbstractQuery.php -> execute (line 688)
  1. *
  2. * @phpstan-param string|AbstractQuery::HYDRATE_* $hydrationMode
  3. */
  4. public function getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed
  5. {
  6. return $this->execute(null, $hydrationMode);
  7. }
  9. /**
  10. * Gets the array of results for the query.
  11. *
in vendor/doctrine/orm/src/Tools/Pagination/Paginator.php -> getResult (line 151)
  1. } else {
  2. $result = $this->cloneQuery($this->query)
  3. ->setMaxResults($length)
  4. ->setFirstResult($offset)
  5. ->setCacheable($this->query->isCacheable())
  6. ->getResult($this->query->getHydrationMode());
  7. }
  9. return new ArrayIterator($result);
  10. }
Paginator->getIterator() in src/Pagination/Paginator.php (line 56)
  2. // $useOutputWalkers = \count($this->queryBuilder->getDQLPart('having') ?: []) > 0;
  3. $useOutputWalkers = $this->queryBuilder->getDQLPart('having') != null;
  4. $paginator->setUseOutputWalkers($useOutputWalkers);
  6. $this->results = $paginator->getIterator();
  7. $this->numResults = $paginator->count();
  8. $this->firstResult = $firstResult;
  9. $this->currentItems = ($firstResult + 1) . ' - ' . ($firstResult + $this->pageSize);
  11. return $this;
Paginator->paginate() in src/Repository/ResidentialComplexRepository.php (line 61)
  1. ->setParameters(new ArrayCollection([
  2. new Parameter('client_status', 'active'),
  3. new Parameter('server_status', 'ok')
  4. ]));
  6. return (new Paginator($qb))->paginate($page);
  7. }
  9. public function findByDistrict(int $districtId, int $page, string $view): Paginator|array
  10. {
  11. $qb = $this->createQueryBuilder('rc')
ResidentialComplexRepository->findAllOrderByName() in src/Controller/ResidentialComplexController.php (line 59)
  1. $residentialComplex = new ResidentialComplex();
  2. $form = $this->createForm(SearchResidentialComplexType::class, $residentialComplex, [
  3. 'method' => 'GET'
  4. ]);
  5. $page = $request->query->getInt('page', 1);
  6. $result = $residentialComplexes->findAllOrderByName($page);
  8. return $this->render('web/list_residential_complexes.html.twig', [
  9. // 'total_residential_complexes' => $residentialComplexes->countActiveResidentialComplexes(),
  10. 'paginator' => $result,
  11. 'form' => $form
in vendor/symfony/http-kernel/HttpKernel.php -> listResidentialComplexes (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 191)
  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('/var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/autoload_runtime.php') in public_html/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a0_.instagram_reel_id' in 'SELECT'

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 24)
  1. } else {
  2. $code = $exception->getCode();
  3. $sqlState = null;
  4. }
  6. return new self($exception->getMessage(), $sqlState, $code, $exception);
  7. }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 57)
  1. public function execute(): Result
  2. {
  3. try {
  4. $this->stmt->execute();
  5. } catch (PDOException $exception) {
  6. throw Exception::new($exception);
  7. }
  9. return new Result($this->stmt);
  10. }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 24)
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  4. public function execute(): Result
  5. {
  6. return $this->wrappedStatement->execute();
  7. }
  8. }
in vendor/doctrine/dbal/src/Logging/Statement.php -> execute (line 46)
  1. 'sql' => $this->sql,
  2. 'params' => $this->params,
  3. 'types' => $this->types,
  4. ]);
  6. return parent::execute();
  7. }
  8. }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 24)
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  4. public function execute(): Result
  5. {
  6. return $this->wrappedStatement->execute();
  7. }
  8. }
in vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php -> execute (line 58)
  2. $this->stopwatch?->start('doctrine', 'doctrine');
  3. $query->start();
  5. try {
  6. return parent::execute();
  7. } finally {
  8. $query->stop();
  9. $this->stopwatch?->stop('doctrine');
  10. }
  11. }
in vendor/doctrine/dbal/src/Connection.php -> execute (line 802)
  2. $stmt = $connection->prepare($sql);
  4. $this->bindParameters($stmt, $params, $types);
  6. $result = $stmt->execute();
  7. } else {
  8. $result = $connection->query($sql);
  9. }
  11. return new Result($result, $this);
in vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php -> executeQuery (line 27)
  1. /**
  2. * {@inheritDoc}
  3. */
  4. public function execute(Connection $conn, array $params, array $types): Result
  5. {
  6. return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);
  7. }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 296)
  1. $sqlParams,
  2. $types,
  3. $this->em->getConnection()->getParams(),
  4. );
  6. return $executor->execute($this->em->getConnection(), $sqlParams, $types);
  7. }
  9. /**
  10. * @param array<string,mixed> $sqlParams
  11. * @param array<string,Type> $types
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 930)
  1. $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2. $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3. };
  4. }
  6. $stmt = $this->_doExecute();
  8. if (is_numeric($stmt)) {
  9. $setCacheEntry($stmt);
  11. return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 886)
  1. ): mixed {
  2. if ($this->cacheable && $this->isCacheEnabled()) {
  3. return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4. }
  6. return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7. }
  9. /**
  10. * Execute query ignoring second level cache.
  11. *
in vendor/doctrine/orm/src/AbstractQuery.php -> execute (line 688)
  1. *
  2. * @phpstan-param string|AbstractQuery::HYDRATE_* $hydrationMode
  3. */
  4. public function getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed
  5. {
  6. return $this->execute(null, $hydrationMode);
  7. }
  9. /**
  10. * Gets the array of results for the query.
  11. *
in vendor/doctrine/orm/src/Tools/Pagination/Paginator.php -> getResult (line 151)
  1. } else {
  2. $result = $this->cloneQuery($this->query)
  3. ->setMaxResults($length)
  4. ->setFirstResult($offset)
  5. ->setCacheable($this->query->isCacheable())
  6. ->getResult($this->query->getHydrationMode());
  7. }
  9. return new ArrayIterator($result);
  10. }
Paginator->getIterator() in src/Pagination/Paginator.php (line 56)
  2. // $useOutputWalkers = \count($this->queryBuilder->getDQLPart('having') ?: []) > 0;
  3. $useOutputWalkers = $this->queryBuilder->getDQLPart('having') != null;
  4. $paginator->setUseOutputWalkers($useOutputWalkers);
  6. $this->results = $paginator->getIterator();
  7. $this->numResults = $paginator->count();
  8. $this->firstResult = $firstResult;
  9. $this->currentItems = ($firstResult + 1) . ' - ' . ($firstResult + $this->pageSize);
  11. return $this;
Paginator->paginate() in src/Repository/ResidentialComplexRepository.php (line 61)
  1. ->setParameters(new ArrayCollection([
  2. new Parameter('client_status', 'active'),
  3. new Parameter('server_status', 'ok')
  4. ]));
  6. return (new Paginator($qb))->paginate($page);
  7. }
  9. public function findByDistrict(int $districtId, int $page, string $view): Paginator|array
  10. {
  11. $qb = $this->createQueryBuilder('rc')
ResidentialComplexRepository->findAllOrderByName() in src/Controller/ResidentialComplexController.php (line 59)
  1. $residentialComplex = new ResidentialComplex();
  2. $form = $this->createForm(SearchResidentialComplexType::class, $residentialComplex, [
  3. 'method' => 'GET'
  4. ]);
  5. $page = $request->query->getInt('page', 1);
  6. $result = $residentialComplexes->findAllOrderByName($page);
  8. return $this->render('web/list_residential_complexes.html.twig', [
  9. // 'total_residential_complexes' => $residentialComplexes->countActiveResidentialComplexes(),
  10. 'paginator' => $result,
  11. 'form' => $form
in vendor/symfony/http-kernel/HttpKernel.php -> listResidentialComplexes (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 191)
  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('/var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/autoload_runtime.php') in public_html/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

PDOException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a0_.instagram_reel_id' in 'SELECT'

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 55)
  1. }
  3. public function execute(): Result
  4. {
  5. try {
  6. $this->stmt->execute();
  7. } catch (PDOException $exception) {
  8. throw Exception::new($exception);
  9. }
  11. return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 55)
  1. }
  3. public function execute(): Result
  4. {
  5. try {
  6. $this->stmt->execute();
  7. } catch (PDOException $exception) {
  8. throw Exception::new($exception);
  9. }
  11. return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 24)
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  4. public function execute(): Result
  5. {
  6. return $this->wrappedStatement->execute();
  7. }
  8. }
in vendor/doctrine/dbal/src/Logging/Statement.php -> execute (line 46)
  1. 'sql' => $this->sql,
  2. 'params' => $this->params,
  3. 'types' => $this->types,
  4. ]);
  6. return parent::execute();
  7. }
  8. }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 24)
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  4. public function execute(): Result
  5. {
  6. return $this->wrappedStatement->execute();
  7. }
  8. }
in vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php -> execute (line 58)
  2. $this->stopwatch?->start('doctrine', 'doctrine');
  3. $query->start();
  5. try {
  6. return parent::execute();
  7. } finally {
  8. $query->stop();
  9. $this->stopwatch?->stop('doctrine');
  10. }
  11. }
in vendor/doctrine/dbal/src/Connection.php -> execute (line 802)
  2. $stmt = $connection->prepare($sql);
  4. $this->bindParameters($stmt, $params, $types);
  6. $result = $stmt->execute();
  7. } else {
  8. $result = $connection->query($sql);
  9. }
  11. return new Result($result, $this);
in vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php -> executeQuery (line 27)
  1. /**
  2. * {@inheritDoc}
  3. */
  4. public function execute(Connection $conn, array $params, array $types): Result
  5. {
  6. return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);
  7. }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 296)
  1. $sqlParams,
  2. $types,
  3. $this->em->getConnection()->getParams(),
  4. );
  6. return $executor->execute($this->em->getConnection(), $sqlParams, $types);
  7. }
  9. /**
  10. * @param array<string,mixed> $sqlParams
  11. * @param array<string,Type> $types
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 930)
  1. $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2. $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3. };
  4. }
  6. $stmt = $this->_doExecute();
  8. if (is_numeric($stmt)) {
  9. $setCacheEntry($stmt);
  11. return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 886)
  1. ): mixed {
  2. if ($this->cacheable && $this->isCacheEnabled()) {
  3. return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4. }
  6. return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7. }
  9. /**
  10. * Execute query ignoring second level cache.
  11. *
in vendor/doctrine/orm/src/AbstractQuery.php -> execute (line 688)
  1. *
  2. * @phpstan-param string|AbstractQuery::HYDRATE_* $hydrationMode
  3. */
  4. public function getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed
  5. {
  6. return $this->execute(null, $hydrationMode);
  7. }
  9. /**
  10. * Gets the array of results for the query.
  11. *
in vendor/doctrine/orm/src/Tools/Pagination/Paginator.php -> getResult (line 151)
  1. } else {
  2. $result = $this->cloneQuery($this->query)
  3. ->setMaxResults($length)
  4. ->setFirstResult($offset)
  5. ->setCacheable($this->query->isCacheable())
  6. ->getResult($this->query->getHydrationMode());
  7. }
  9. return new ArrayIterator($result);
  10. }
Paginator->getIterator() in src/Pagination/Paginator.php (line 56)
  2. // $useOutputWalkers = \count($this->queryBuilder->getDQLPart('having') ?: []) > 0;
  3. $useOutputWalkers = $this->queryBuilder->getDQLPart('having') != null;
  4. $paginator->setUseOutputWalkers($useOutputWalkers);
  6. $this->results = $paginator->getIterator();
  7. $this->numResults = $paginator->count();
  8. $this->firstResult = $firstResult;
  9. $this->currentItems = ($firstResult + 1) . ' - ' . ($firstResult + $this->pageSize);
  11. return $this;
Paginator->paginate() in src/Repository/ResidentialComplexRepository.php (line 61)
  1. ->setParameters(new ArrayCollection([
  2. new Parameter('client_status', 'active'),
  3. new Parameter('server_status', 'ok')
  4. ]));
  6. return (new Paginator($qb))->paginate($page);
  7. }
  9. public function findByDistrict(int $districtId, int $page, string $view): Paginator|array
  10. {
  11. $qb = $this->createQueryBuilder('rc')
ResidentialComplexRepository->findAllOrderByName() in src/Controller/ResidentialComplexController.php (line 59)
  1. $residentialComplex = new ResidentialComplex();
  2. $form = $this->createForm(SearchResidentialComplexType::class, $residentialComplex, [
  3. 'method' => 'GET'
  4. ]);
  5. $page = $request->query->getInt('page', 1);
  6. $result = $residentialComplexes->findAllOrderByName($page);
  8. return $this->render('web/list_residential_complexes.html.twig', [
  9. // 'total_residential_complexes' => $residentialComplexes->countActiveResidentialComplexes(),
  10. 'paginator' => $result,
  11. 'form' => $form
in vendor/symfony/http-kernel/HttpKernel.php -> listResidentialComplexes (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 191)
  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('/var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/autoload_runtime.php') in public_html/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

Logs

Level Channel Message
INFO 19:46:09 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "843913"
    },
    "request_uri": "https://imobiliare.n46.net/_profiler/843913",
    "method": "GET"
}

Stack Traces 3

[3/3] InvalidFieldNameException 
Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a0_.instagram_reel_id' in 'SELECT'

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:63
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1460)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1396)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Connection.php:809)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27)
  at Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute()
     (vendor/doctrine/orm/src/Query.php:296)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/src/AbstractQuery.php:688)
  at Doctrine\ORM\AbstractQuery->getResult()
     (vendor/doctrine/orm/src/Tools/Pagination/Paginator.php:151)
  at Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
     (src/Pagination/Paginator.php:56)
  at App\Pagination\Paginator->paginate()
     (src/Repository/ResidentialComplexRepository.php:61)
  at App\Repository\ResidentialComplexRepository->findAllOrderByName()
     (src/Controller/ResidentialComplexController.php:59)
  at App\Controller\ResidentialComplexController->listResidentialComplexes()
     (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:191)
  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('/var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/autoload_runtime.php')
     (public_html/index.php:5)
[2/3] Exception 
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a0_.instagram_reel_id' in 'SELECT'

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:57)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/doctrine/dbal/src/Logging/Statement.php:46)
  at Doctrine\DBAL\Logging\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php:58)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:802)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27)
  at Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute()
     (vendor/doctrine/orm/src/Query.php:296)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/src/AbstractQuery.php:688)
  at Doctrine\ORM\AbstractQuery->getResult()
     (vendor/doctrine/orm/src/Tools/Pagination/Paginator.php:151)
  at Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
     (src/Pagination/Paginator.php:56)
  at App\Pagination\Paginator->paginate()
     (src/Repository/ResidentialComplexRepository.php:61)
  at App\Repository\ResidentialComplexRepository->findAllOrderByName()
     (src/Controller/ResidentialComplexController.php:59)
  at App\Controller\ResidentialComplexController->listResidentialComplexes()
     (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:191)
  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('/var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/autoload_runtime.php')
     (public_html/index.php:5)
[1/3] PDOException 
PDOException:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a0_.instagram_reel_id' in 'SELECT'

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:55
  at PDOStatement->execute()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:55)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/doctrine/dbal/src/Logging/Statement.php:46)
  at Doctrine\DBAL\Logging\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php:58)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:802)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27)
  at Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute()
     (vendor/doctrine/orm/src/Query.php:296)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/src/AbstractQuery.php:688)
  at Doctrine\ORM\AbstractQuery->getResult()
     (vendor/doctrine/orm/src/Tools/Pagination/Paginator.php:151)
  at Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
     (src/Pagination/Paginator.php:56)
  at App\Pagination\Paginator->paginate()
     (src/Repository/ResidentialComplexRepository.php:61)
  at App\Repository\ResidentialComplexRepository->findAllOrderByName()
     (src/Controller/ResidentialComplexController.php:59)
  at App\Controller\ResidentialComplexController->listResidentialComplexes()
     (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:191)
  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('/var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/autoload_runtime.php')
     (public_html/index.php:5)