Exceptions
Exceptions 3
Doctrine\DBAL\Exception\ InvalidFieldNameException
Show exception properties
Doctrine\DBAL\Exception\InvalidFieldNameException {#575 -query: Doctrine\DBAL\Query {#574 -sql: """ SELECT\n i.*,\n u.email,\n u.first_name,\n u.last_name,\n d.host AS primary_domain\n FROM invoice i\n INNER JOIN app_user u ON u.id = i.recipient_id\n INNER JOIN school s ON s.id = i.school_id\n LEFT JOIN school_domain d ON d.school_id = i.school_id AND d.primary_domain = 1 AND d.active = 1\n WHERE s.active = 1\n AND i.issued_at >= ?\n ORDER BY i.issued_at DESC, i.id DESC\n LIMIT 1000 """ -params: array:1 [ 0 => "2025-02-19 16:48:19" ] -types: [] } }
1557,1569,1586 => new UniqueConstraintViolationException($exception, $query),1054,1166,1611 => new InvalidFieldNameException($exception, $query),1052,1060,1110 => new NonUniqueFieldNameException($exception, $query),1064,1149,
in
vendor/doctrine/dbal/src/Connection.php
->
convert
(line 1454)
private function handleDriverException(Driver\Exception $driverException,?Query $query,): DriverException {$this->exceptionConverter ??= $this->driver->getExceptionConverter();$exception = $this->exceptionConverter->convert($driverException, $query);if ($exception instanceof ConnectionLost) {$this->close();}
in
vendor/doctrine/dbal/src/Connection.php
->
handleDriverException
(line 1390)
Driver\Exception $e,string $sql,array $params = [],array $types = [],): DriverException {return $this->handleDriverException($e, new Query($sql, $params, $types));}/** @internal */final public function convertException(Driver\Exception $e): DriverException{
in
vendor/doctrine/dbal/src/Connection.php
->
convertExceptionDuringQuery
(line 807)
$result = $connection->query($sql);}return new Result($result, $this);} catch (Driver\Exception $e) {throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);}}/*** Executes a caching query.
in
vendor/doctrine/dbal/src/Connection.php
->
executeQuery
(line 620)
** @throws Exception*/public function fetchAllAssociative(string $query, array $params = [], array $types = []): array{return $this->executeQuery($query, $params, $types)->fetchAllAssociative();}/*** Prepares and executes an SQL query and returns the result as an associative array with the keys* mapped to the first column and the values mapped to the second column.
Connection->fetchAllAssociative('SELECT i.*, u.email, u.first_name, u.last_name, d.host AS primary_domainFROM invoice iINNER JOIN app_user u ON u.id = i.recipient_idINNER JOIN school s ON s.id = i.school_idLEFT JOIN school_domain d ON d.school_id = i.school_id AND d.primary_domain = 1 AND d.active = 1WHERE s.active = 1 AND i.issued_at >= :sinceORDER BY i.issued_at DESC, i.id DESCLIMIT 1000', array('since' => '2025-02-19 16:48:19'))
in
src/Controller/PublicInvoicePaymentController.php
(line 131)
) ?: [];if ($invoice !== []) {return $invoice;}} catch (\Throwable) {}$candidates = $connection->fetchAllAssociative(<<<'SQL'SELECTi.*,
PublicInvoicePaymentController->invoiceByToken(object(Connection), 'pay_A69wMP8SIjEMdm60N8169VBQrl5k_Ira2_EXwEpN0c0')
in
src/Controller/PublicInvoicePaymentController.php
(line 30)
private readonly TranslatorInterface $translator,) {}#[Route('/pay/{token}', name: 'public_invoice_payu_start', methods: ['GET'])]public function start(string $token, Request $request, Connection $connection, SchoolFeatureAccess $features, PayuCommissionCalculator $calculator, PayuOrderClient $payuClient): Response{$invoice = $this->invoiceByToken($connection, $token);if ($invoice === []) {throw $this->createNotFoundException();}
in
vendor/symfony/http-kernel/HttpKernel.php
->
start
(line 183)
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);$controller = $event->getController();$arguments = $event->getArguments();// call controller$response = $controller(...$arguments);// viewif (!$response instanceof Response) {$event = new ViewEvent($this, $request, $type, $response, $event);$this->dispatcher->dispatch($event, KernelEvents::VIEW);
in
vendor/symfony/http-kernel/HttpKernel.php
->
handleRaw
(line 76)
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());$this->requestStack->push($request);$response = null;try {return $response = $this->handleRaw($request, $type);} catch (\Throwable $e) {if ($e instanceof \Error && !$this->handleAllThrowables) {throw $e;}
in
vendor/symfony/http-kernel/Kernel.php
->
handle
(line 193)
if (!$this->handlingHttpCache) {$this->resetServices = true;}try {return $this->getHttpKernel()->handle($request, $type, $catch);} finally {--$this->requestStackSize;}}
in
vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php
->
handle
(line 34)
) {}public function run(): int{$response = $this->kernel->handle($this->request);$response->send(false);if (\function_exists('fastcgi_finish_request') && !$this->debug) {fastcgi_finish_request();
in
vendor/autoload_runtime.php
->
run
(line 32)
$app = $app(...$args);exit($runtime->getRunner($app)->run());
require_once('/home/klient.dhosting.pl/skillpilot/skillpilot.dfirma.pl/vendor/autoload_runtime.php')
in
public/index.php
(line 5)
<?phpuse App\Kernel;require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return static function (array $context): Kernel {return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);};
Doctrine\DBAL\Driver\PDO\ Exception
in
vendor/doctrine/dbal/src/Driver/PDO/Exception.php
(line 24)
} else {$code = $exception->getCode();$sqlState = null;}return new self($exception->getMessage(), $sqlState, $code, $exception);}}
in
vendor/doctrine/dbal/src/Driver/PDO/Statement.php
::
new
(line 57)
public function execute(): Result{try {$this->stmt->execute();} catch (PDOException $exception) {throw Exception::new($exception);}return new Result($this->stmt);}
in
vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php
->
execute
(line 24)
$this->wrappedStatement->bindValue($param, $value, $type);}public function execute(): Result{return $this->wrappedStatement->execute();}}
in
vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php
->
execute
(line 58)
$this->stopwatch?->start('doctrine', 'doctrine');$query->start();try {return parent::execute();} finally {$query->stop();$this->stopwatch?->stop('doctrine');}}
in
vendor/doctrine/dbal/src/Connection.php
->
execute
(line 800)
$stmt = $connection->prepare($sql);$this->bindParameters($stmt, $params, $types);$result = $stmt->execute();} else {$result = $connection->query($sql);}return new Result($result, $this);
in
vendor/doctrine/dbal/src/Connection.php
->
executeQuery
(line 620)
** @throws Exception*/public function fetchAllAssociative(string $query, array $params = [], array $types = []): array{return $this->executeQuery($query, $params, $types)->fetchAllAssociative();}/*** Prepares and executes an SQL query and returns the result as an associative array with the keys* mapped to the first column and the values mapped to the second column.
Connection->fetchAllAssociative('SELECT i.*, u.email, u.first_name, u.last_name, d.host AS primary_domainFROM invoice iINNER JOIN app_user u ON u.id = i.recipient_idINNER JOIN school s ON s.id = i.school_idLEFT JOIN school_domain d ON d.school_id = i.school_id AND d.primary_domain = 1 AND d.active = 1WHERE s.active = 1 AND i.issued_at >= :sinceORDER BY i.issued_at DESC, i.id DESCLIMIT 1000', array('since' => '2025-02-19 16:48:19'))
in
src/Controller/PublicInvoicePaymentController.php
(line 131)
) ?: [];if ($invoice !== []) {return $invoice;}} catch (\Throwable) {}$candidates = $connection->fetchAllAssociative(<<<'SQL'SELECTi.*,
PublicInvoicePaymentController->invoiceByToken(object(Connection), 'pay_A69wMP8SIjEMdm60N8169VBQrl5k_Ira2_EXwEpN0c0')
in
src/Controller/PublicInvoicePaymentController.php
(line 30)
private readonly TranslatorInterface $translator,) {}#[Route('/pay/{token}', name: 'public_invoice_payu_start', methods: ['GET'])]public function start(string $token, Request $request, Connection $connection, SchoolFeatureAccess $features, PayuCommissionCalculator $calculator, PayuOrderClient $payuClient): Response{$invoice = $this->invoiceByToken($connection, $token);if ($invoice === []) {throw $this->createNotFoundException();}
in
vendor/symfony/http-kernel/HttpKernel.php
->
start
(line 183)
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);$controller = $event->getController();$arguments = $event->getArguments();// call controller$response = $controller(...$arguments);// viewif (!$response instanceof Response) {$event = new ViewEvent($this, $request, $type, $response, $event);$this->dispatcher->dispatch($event, KernelEvents::VIEW);
in
vendor/symfony/http-kernel/HttpKernel.php
->
handleRaw
(line 76)
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());$this->requestStack->push($request);$response = null;try {return $response = $this->handleRaw($request, $type);} catch (\Throwable $e) {if ($e instanceof \Error && !$this->handleAllThrowables) {throw $e;}
in
vendor/symfony/http-kernel/Kernel.php
->
handle
(line 193)
if (!$this->handlingHttpCache) {$this->resetServices = true;}try {return $this->getHttpKernel()->handle($request, $type, $catch);} finally {--$this->requestStackSize;}}
in
vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php
->
handle
(line 34)
) {}public function run(): int{$response = $this->kernel->handle($this->request);$response->send(false);if (\function_exists('fastcgi_finish_request') && !$this->debug) {fastcgi_finish_request();
in
vendor/autoload_runtime.php
->
run
(line 32)
$app = $app(...$args);exit($runtime->getRunner($app)->run());
require_once('/home/klient.dhosting.pl/skillpilot/skillpilot.dfirma.pl/vendor/autoload_runtime.php')
in
public/index.php
(line 5)
<?phpuse App\Kernel;require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return static function (array $context): Kernel {return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);};
PDOException
in
vendor/doctrine/dbal/src/Driver/PDO/Statement.php
(line 55)
}public function execute(): Result{try {$this->stmt->execute();} catch (PDOException $exception) {throw Exception::new($exception);}return new Result($this->stmt);
in
vendor/doctrine/dbal/src/Driver/PDO/Statement.php
->
execute
(line 55)
}public function execute(): Result{try {$this->stmt->execute();} catch (PDOException $exception) {throw Exception::new($exception);}return new Result($this->stmt);
in
vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php
->
execute
(line 24)
$this->wrappedStatement->bindValue($param, $value, $type);}public function execute(): Result{return $this->wrappedStatement->execute();}}
in
vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php
->
execute
(line 58)
$this->stopwatch?->start('doctrine', 'doctrine');$query->start();try {return parent::execute();} finally {$query->stop();$this->stopwatch?->stop('doctrine');}}
in
vendor/doctrine/dbal/src/Connection.php
->
execute
(line 800)
$stmt = $connection->prepare($sql);$this->bindParameters($stmt, $params, $types);$result = $stmt->execute();} else {$result = $connection->query($sql);}return new Result($result, $this);
in
vendor/doctrine/dbal/src/Connection.php
->
executeQuery
(line 620)
** @throws Exception*/public function fetchAllAssociative(string $query, array $params = [], array $types = []): array{return $this->executeQuery($query, $params, $types)->fetchAllAssociative();}/*** Prepares and executes an SQL query and returns the result as an associative array with the keys* mapped to the first column and the values mapped to the second column.
Connection->fetchAllAssociative('SELECT i.*, u.email, u.first_name, u.last_name, d.host AS primary_domainFROM invoice iINNER JOIN app_user u ON u.id = i.recipient_idINNER JOIN school s ON s.id = i.school_idLEFT JOIN school_domain d ON d.school_id = i.school_id AND d.primary_domain = 1 AND d.active = 1WHERE s.active = 1 AND i.issued_at >= :sinceORDER BY i.issued_at DESC, i.id DESCLIMIT 1000', array('since' => '2025-02-19 16:48:19'))
in
src/Controller/PublicInvoicePaymentController.php
(line 131)
) ?: [];if ($invoice !== []) {return $invoice;}} catch (\Throwable) {}$candidates = $connection->fetchAllAssociative(<<<'SQL'SELECTi.*,
PublicInvoicePaymentController->invoiceByToken(object(Connection), 'pay_A69wMP8SIjEMdm60N8169VBQrl5k_Ira2_EXwEpN0c0')
in
src/Controller/PublicInvoicePaymentController.php
(line 30)
private readonly TranslatorInterface $translator,) {}#[Route('/pay/{token}', name: 'public_invoice_payu_start', methods: ['GET'])]public function start(string $token, Request $request, Connection $connection, SchoolFeatureAccess $features, PayuCommissionCalculator $calculator, PayuOrderClient $payuClient): Response{$invoice = $this->invoiceByToken($connection, $token);if ($invoice === []) {throw $this->createNotFoundException();}
in
vendor/symfony/http-kernel/HttpKernel.php
->
start
(line 183)
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);$controller = $event->getController();$arguments = $event->getArguments();// call controller$response = $controller(...$arguments);// viewif (!$response instanceof Response) {$event = new ViewEvent($this, $request, $type, $response, $event);$this->dispatcher->dispatch($event, KernelEvents::VIEW);
in
vendor/symfony/http-kernel/HttpKernel.php
->
handleRaw
(line 76)
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());$this->requestStack->push($request);$response = null;try {return $response = $this->handleRaw($request, $type);} catch (\Throwable $e) {if ($e instanceof \Error && !$this->handleAllThrowables) {throw $e;}
in
vendor/symfony/http-kernel/Kernel.php
->
handle
(line 193)
if (!$this->handlingHttpCache) {$this->resetServices = true;}try {return $this->getHttpKernel()->handle($request, $type, $catch);} finally {--$this->requestStackSize;}}
in
vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php
->
handle
(line 34)
) {}public function run(): int{$response = $this->kernel->handle($this->request);$response->send(false);if (\function_exists('fastcgi_finish_request') && !$this->debug) {fastcgi_finish_request();
in
vendor/autoload_runtime.php
->
run
(line 32)
$app = $app(...$args);exit($runtime->getRunner($app)->run());
require_once('/home/klient.dhosting.pl/skillpilot/skillpilot.dfirma.pl/vendor/autoload_runtime.php')
in
public/index.php
(line 5)
<?phpuse App\Kernel;require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return static function (array $context): Kernel {return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);};
Logs
| Level | Message |
|---|---|
| info 19:37:23 |
User Deprecated: Class "Doctrine\ORM\Proxy\Autoloader" is deprecated. Use native lazy objects instead. (Autoloader.php:74 called by DoctrineBundle.php:136, https://github.com/doctrine/orm/pull/12005, package doctrine/orm) {
"exception": {}
}
|
| info 19:37:23 |
Matched route "_profiler". {
"route": "_profiler",
"route_parameters": {
"_route": "_profiler",
"_controller": "web_profiler.controller.profiler::panelAction",
"token": "d1cb9b"
},
"request_uri": "https://testowa-szkola.panelzajec.pl/_profiler/d1cb9b",
"method": "GET"
}
|
| debug 19:37:23 |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
|
| debug 19:37:23 |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
|
| debug 19:37:23 |
Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest"
}
|
| debug 19:37:23 |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
|
| debug 19:37:23 |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
|
| debug 19:37:23 |
Notified event "kernel.request" to listener "App\EventSubscriber\SchoolContextSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "App\\EventSubscriber\\SchoolContextSubscriber::onKernelRequest"
}
|
| debug 19:37:23 |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
|
| debug 19:37:23 |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
|
| debug 19:37:23 |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
|
| debug 19:37:23 |
Notified event "kernel.request" to listener "App\EventSubscriber\FormCsrfSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "App\\EventSubscriber\\FormCsrfSubscriber::onKernelRequest"
}
|
| debug 19:37:23 |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". {
"event": "kernel.request",
"listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
|
| debug 19:37:23 |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
|
| debug 19:37:23 |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". {
"event": "kernel.controller",
"listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
|
| debug 19:37:23 |
Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". {
"event": "kernel.controller",
"listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
|
| debug 19:37:23 |
Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments". {
"event": "kernel.controller_arguments",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\IsSignatureValidAttributeListener::onKernelControllerArguments"
}
|
| debug 19:37:23 |
Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments". {
"event": "kernel.controller_arguments",
"listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
}
|
| debug 19:37:23 |
Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments". {
"event": "kernel.controller_arguments",
"listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
|
| debug 19:37:23 |
Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". {
"event": "kernel.controller_arguments",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
|
| debug 19:37:23 |
Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". {
"event": "kernel.controller_arguments",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
|
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 's.active' in 'WHERE'
at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:63
at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), object(Query))
(vendor/doctrine/dbal/src/Connection.php:1454)
at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query))
(vendor/doctrine/dbal/src/Connection.php:1390)
at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), 'SELECT i.*, u.email, u.first_name, u.last_name, d.host AS primary_domainFROM invoice iINNER JOIN app_user u ON u.id = i.recipient_idINNER JOIN school s ON s.id = i.school_idLEFT JOIN school_domain d ON d.school_id = i.school_id AND d.primary_domain = 1 AND d.active = 1WHERE s.active = 1 AND i.issued_at >= ?ORDER BY i.issued_at DESC, i.id DESCLIMIT 1000', array('2025-02-19 16:48:19'), array())
(vendor/doctrine/dbal/src/Connection.php:807)
at Doctrine\DBAL\Connection->executeQuery('SELECT i.*, u.email, u.first_name, u.last_name, d.host AS primary_domainFROM invoice iINNER JOIN app_user u ON u.id = i.recipient_idINNER JOIN school s ON s.id = i.school_idLEFT JOIN school_domain d ON d.school_id = i.school_id AND d.primary_domain = 1 AND d.active = 1WHERE s.active = 1 AND i.issued_at >= ?ORDER BY i.issued_at DESC, i.id DESCLIMIT 1000', array('2025-02-19 16:48:19'), array())
(vendor/doctrine/dbal/src/Connection.php:620)
at Doctrine\DBAL\Connection->fetchAllAssociative('SELECT i.*, u.email, u.first_name, u.last_name, d.host AS primary_domainFROM invoice iINNER JOIN app_user u ON u.id = i.recipient_idINNER JOIN school s ON s.id = i.school_idLEFT JOIN school_domain d ON d.school_id = i.school_id AND d.primary_domain = 1 AND d.active = 1WHERE s.active = 1 AND i.issued_at >= :sinceORDER BY i.issued_at DESC, i.id DESCLIMIT 1000', array('since' => '2025-02-19 16:48:19'))
(src/Controller/PublicInvoicePaymentController.php:131)
at App\Controller\PublicInvoicePaymentController->invoiceByToken(object(Connection), 'pay_A69wMP8SIjEMdm60N8169VBQrl5k_Ira2_EXwEpN0c0')
(src/Controller/PublicInvoicePaymentController.php:30)
at App\Controller\PublicInvoicePaymentController->start('pay_A69wMP8SIjEMdm60N8169VBQrl5k_Ira2_EXwEpN0c0', object(Request), object(Connection), object(SchoolFeatureAccess), object(PayuCommissionCalculator), object(PayuOrderClient))
(vendor/symfony/http-kernel/HttpKernel.php:183)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
(vendor/symfony/http-kernel/HttpKernel.php:76)
at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
(vendor/symfony/http-kernel/Kernel.php:193)
at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
(vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:34)
at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
(vendor/autoload_runtime.php:32)
at require_once('/home/klient.dhosting.pl/skillpilot/skillpilot.dfirma.pl/vendor/autoload_runtime.php')
(public/index.php:5)
|
|
[2/3]
Exception
|
|---|
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.active' in 'WHERE'
at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24
at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException))
(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/symfony/doctrine-bridge/Middleware/Debug/Statement.php:58)
at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
(vendor/doctrine/dbal/src/Connection.php:800)
at Doctrine\DBAL\Connection->executeQuery('SELECT i.*, u.email, u.first_name, u.last_name, d.host AS primary_domainFROM invoice iINNER JOIN app_user u ON u.id = i.recipient_idINNER JOIN school s ON s.id = i.school_idLEFT JOIN school_domain d ON d.school_id = i.school_id AND d.primary_domain = 1 AND d.active = 1WHERE s.active = 1 AND i.issued_at >= ?ORDER BY i.issued_at DESC, i.id DESCLIMIT 1000', array('2025-02-19 16:48:19'), array())
(vendor/doctrine/dbal/src/Connection.php:620)
at Doctrine\DBAL\Connection->fetchAllAssociative('SELECT i.*, u.email, u.first_name, u.last_name, d.host AS primary_domainFROM invoice iINNER JOIN app_user u ON u.id = i.recipient_idINNER JOIN school s ON s.id = i.school_idLEFT JOIN school_domain d ON d.school_id = i.school_id AND d.primary_domain = 1 AND d.active = 1WHERE s.active = 1 AND i.issued_at >= :sinceORDER BY i.issued_at DESC, i.id DESCLIMIT 1000', array('since' => '2025-02-19 16:48:19'))
(src/Controller/PublicInvoicePaymentController.php:131)
at App\Controller\PublicInvoicePaymentController->invoiceByToken(object(Connection), 'pay_A69wMP8SIjEMdm60N8169VBQrl5k_Ira2_EXwEpN0c0')
(src/Controller/PublicInvoicePaymentController.php:30)
at App\Controller\PublicInvoicePaymentController->start('pay_A69wMP8SIjEMdm60N8169VBQrl5k_Ira2_EXwEpN0c0', object(Request), object(Connection), object(SchoolFeatureAccess), object(PayuCommissionCalculator), object(PayuOrderClient))
(vendor/symfony/http-kernel/HttpKernel.php:183)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
(vendor/symfony/http-kernel/HttpKernel.php:76)
at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
(vendor/symfony/http-kernel/Kernel.php:193)
at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
(vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:34)
at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
(vendor/autoload_runtime.php:32)
at require_once('/home/klient.dhosting.pl/skillpilot/skillpilot.dfirma.pl/vendor/autoload_runtime.php')
(public/index.php:5)
|
|
[1/3]
PDOException
|
|---|
PDOException:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.active' in 'WHERE'
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/symfony/doctrine-bridge/Middleware/Debug/Statement.php:58)
at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
(vendor/doctrine/dbal/src/Connection.php:800)
at Doctrine\DBAL\Connection->executeQuery('SELECT i.*, u.email, u.first_name, u.last_name, d.host AS primary_domainFROM invoice iINNER JOIN app_user u ON u.id = i.recipient_idINNER JOIN school s ON s.id = i.school_idLEFT JOIN school_domain d ON d.school_id = i.school_id AND d.primary_domain = 1 AND d.active = 1WHERE s.active = 1 AND i.issued_at >= ?ORDER BY i.issued_at DESC, i.id DESCLIMIT 1000', array('2025-02-19 16:48:19'), array())
(vendor/doctrine/dbal/src/Connection.php:620)
at Doctrine\DBAL\Connection->fetchAllAssociative('SELECT i.*, u.email, u.first_name, u.last_name, d.host AS primary_domainFROM invoice iINNER JOIN app_user u ON u.id = i.recipient_idINNER JOIN school s ON s.id = i.school_idLEFT JOIN school_domain d ON d.school_id = i.school_id AND d.primary_domain = 1 AND d.active = 1WHERE s.active = 1 AND i.issued_at >= :sinceORDER BY i.issued_at DESC, i.id DESCLIMIT 1000', array('since' => '2025-02-19 16:48:19'))
(src/Controller/PublicInvoicePaymentController.php:131)
at App\Controller\PublicInvoicePaymentController->invoiceByToken(object(Connection), 'pay_A69wMP8SIjEMdm60N8169VBQrl5k_Ira2_EXwEpN0c0')
(src/Controller/PublicInvoicePaymentController.php:30)
at App\Controller\PublicInvoicePaymentController->start('pay_A69wMP8SIjEMdm60N8169VBQrl5k_Ira2_EXwEpN0c0', object(Request), object(Connection), object(SchoolFeatureAccess), object(PayuCommissionCalculator), object(PayuOrderClient))
(vendor/symfony/http-kernel/HttpKernel.php:183)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
(vendor/symfony/http-kernel/HttpKernel.php:76)
at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
(vendor/symfony/http-kernel/Kernel.php:193)
at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
(vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:34)
at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
(vendor/autoload_runtime.php:32)
at require_once('/home/klient.dhosting.pl/skillpilot/skillpilot.dfirma.pl/vendor/autoload_runtime.php')
(public/index.php:5)
|