https://dev.wunschliefertag.de/run/RemoveDuplicateAddress/3fb47935717ce0866b0d3af0931f1c46ca22600f5c53e55bf7


0
https://dev.wunschliefertag.de/run/Assigned/2cd89e70bbb4e447d72a1122429c94ae5860b9abcacc70ef29


0
https://dev.wunschliefertag.de/run/AvisSend/46dc73d2612a09fced1c1d70196b2cbfae0b5a8315145861c8
Warning: Undefined array key 0 (500 Internal Server Error)

Symfony Exception

Symfony Docs

ErrorException

HTTP 500 Internal Server Error

Warning: Undefined array key 0

Exception

ErrorException

in src/Job/AvisSend.php (line 87)
  1.                         case 'SMS':
  3.                             $qb->andWhere('m.name like :match')
  4.                                 ->setParameter('match', 'avis_sms%');
  6.                             $textSMS = $qb->getQuery()->execute()[0];
  7.                             if (empty($textSMS)) {
  8.                                 $textSMS = $defSMS;
  9.                             }
  10.                             if ($obj->getContent() == '')
  11.                                 $obj->setContent($obj->getSending()->textReplace($textSMS->getContent()));
AvisSend->run() in src/Controller/RunController.php (line 100)
  1.     {
  2.         $logger->info('jobstart ' . $taskName . ' ' . $hash);
  3.         foreach ($jobService->listJobs() as $job) {
  4.             if (($job->getName() == $taskName)
  5.                 && (($job->getEnabled() && $job->getEntity()->getHash() == $hash) || $hash == "tryIt")) {
  6.                 $job->prepareRun()->run();
  7.             }
  8.         }
  9.         $logger->info('jobend ' . $taskName . ' ' . $hash);
  10.         return new Response('');
  11.     }
in vendor/symfony/http-kernel/HttpKernel.php -> run (line 163)
  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 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $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 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  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.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/revision/dev/v05.00.0750/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  6. return function (array $context) {
  7.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  8. };

Logs 1

Level Channel Message
INFO 07:26:02 request Matched route "jobRun". 
{
    "route": "jobRun",
    "route_parameters": {
        "_route": "jobRun",
        "_controller": "App\\Controller\\RunController::run",
        "taskName": "AvisSend",
        "hash": "46dc73d2612a09fced1c1d70196b2cbfae0b5a8315145861c8"
    },
    "request_uri": "https://dev.wunschliefertag.de/run/AvisSend/46dc73d2612a09fced1c1d70196b2cbfae0b5a8315145861c8",
    "method": "GET"
}
DEBUG 07:26:02 security Checking for authenticator support. 
{
    "firewall_name": "main",
    "authenticators": 1
}
DEBUG 07:26:02 security Checking support on authenticator. 
{
    "firewall_name": "main",
    "authenticator": "App\\Security\\LoginFormAuthticatorAuthenticator"
}
DEBUG 07:26:02 security Authenticator does not support the request. 
{
    "firewall_name": "main",
    "authenticator": "App\\Security\\LoginFormAuthticatorAuthenticator"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 07:26:02 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 07:26:02 event Notified event "kernel.controller" to listener "App\EventSubscriber\MenuSubscriber::onControllerEvent". 
{
    "event": "kernel.controller",
    "listener": "App\\EventSubscriber\\MenuSubscriber::onControllerEvent"
}
DEBUG 07:26:02 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 07:26:02 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ControllerListener::onKernelController"
}
DEBUG 07:26:02 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ParamConverterListener::onKernelController"
}
DEBUG 07:26:02 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelController"
}
DEBUG 07:26:02 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\TemplateListener::onKernelController"
}
INFO 07:26:02 doctrine Connecting with parameters {params} 
{
    "params": {
        "driver": "pdo_mysql",
        "host": "80.158.50.170",
        "port": 3306,
        "user": "fbusch",
        "password": "<redacted>",
        "driverOptions": [],
        "defaultTableOptions": [],
        "dbname": "wlt5_dev",
        "serverVersion": "8.0.21-2",
        "charset": "utf8"
    }
}
DEBUG 07:26:02 doctrine Executing query: SELECT t0.id AS id_1, t0.state AS state_2, t0.step_kind AS step_kind_3, t0.description AS description_4, t0.state_message_ftp AS state_message_ftp_5, t0.state_message_fax AS state_message_fax_6, t0.state_message_mail AS state_message_mail_7, t0.state_message_sms AS state_message_sms_8, t0.state_message_api AS state_message_api_9, t0.changing_sending AS changing_sending_10, t0.state_group AS state_group_11, t0.avis_try AS avis_try_12, t0.show_hist AS show_hist_13, t0.bookable AS bookable_14, t0.export_state_id AS export_state_id_15, t0.sgroup_id AS sgroup_id_16 FROM type_sending_state t0 
{
    "sql": "SELECT t0.id AS id_1, t0.state AS state_2, t0.step_kind AS step_kind_3, t0.description AS description_4, t0.state_message_ftp AS state_message_ftp_5, t0.state_message_fax AS state_message_fax_6, t0.state_message_mail AS state_message_mail_7, t0.state_message_sms AS state_message_sms_8, t0.state_message_api AS state_message_api_9, t0.changing_sending AS changing_sending_10, t0.state_group AS state_group_11, t0.avis_try AS avis_try_12, t0.show_hist AS show_hist_13, t0.bookable AS bookable_14, t0.export_state_id AS export_state_id_15, t0.sgroup_id AS sgroup_id_16 FROM type_sending_state t0"
}
DEBUG 07:26:02 doctrine Executing query: SELECT t0.id AS id_1, t0.state AS state_2, t0.step_kind AS step_kind_3, t0.description AS description_4, t0.state_message_ftp AS state_message_ftp_5, t0.state_message_fax AS state_message_fax_6, t0.state_message_mail AS state_message_mail_7, t0.state_message_sms AS state_message_sms_8, t0.state_message_api AS state_message_api_9, t0.changing_sending AS changing_sending_10, t0.state_group AS state_group_11, t0.avis_try AS avis_try_12, t0.show_hist AS show_hist_13, t0.bookable AS bookable_14, t0.export_state_id AS export_state_id_15, t0.sgroup_id AS sgroup_id_16 FROM type_sending_state t0 
{
    "sql": "SELECT t0.id AS id_1, t0.state AS state_2, t0.step_kind AS step_kind_3, t0.description AS description_4, t0.state_message_ftp AS state_message_ftp_5, t0.state_message_fax AS state_message_fax_6, t0.state_message_mail AS state_message_mail_7, t0.state_message_sms AS state_message_sms_8, t0.state_message_api AS state_message_api_9, t0.changing_sending AS changing_sending_10, t0.state_group AS state_group_11, t0.avis_try AS avis_try_12, t0.show_hist AS show_hist_13, t0.bookable AS bookable_14, t0.export_state_id AS export_state_id_15, t0.sgroup_id AS sgroup_id_16 FROM type_sending_state t0"
}
DEBUG 07:26:02 doctrine Executing query: SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.last_run AS last_run_4, t0.last_state AS last_state_5, t0.hash AS hash_6, t0.enabled AS enabled_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM job t0 
{
    "sql": "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.last_run AS last_run_4, t0.last_state AS last_state_5, t0.hash AS hash_6, t0.enabled AS enabled_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM job t0"
}
DEBUG 07:26:02 doctrine Executing statement: SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_dev AS is_dev_5, t0.all_depot AS all_depot_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.title AS title_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.right_level_id AS right_level_id_13, t0.standard_depot_id AS standard_depot_id_14, t0.state_id AS state_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.id = ? LIMIT 1 (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_dev AS is_dev_5, t0.all_depot AS all_depot_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.title AS title_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.right_level_id AS right_level_id_13, t0.standard_depot_id AS standard_depot_id_14, t0.state_id AS state_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.id = ? LIMIT 1",
    "params": {
        "1": -1
    },
    "types": {
        "1": 2
    }
}
DEBUG 07:26:02 doctrine Executing statement: SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_dev AS is_dev_5, t0.all_depot AS all_depot_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.title AS title_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.right_level_id AS right_level_id_13, t0.standard_depot_id AS standard_depot_id_14, t0.state_id AS state_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.id = ? LIMIT 1 (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_dev AS is_dev_5, t0.all_depot AS all_depot_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.title AS title_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.right_level_id AS right_level_id_13, t0.standard_depot_id AS standard_depot_id_14, t0.state_id AS state_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.id = ? LIMIT 1",
    "params": {
        "1": -1
    },
    "types": {
        "1": 2
    }
}
INFO 07:26:02 deprecation Deprecated: Creation of dynamic property App\Job\CalendarBookableDate::$sysUser is deprecated 
{
    "exception": {}
}
DEBUG 07:26:02 event 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 07:26:02 event 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 07:26:02 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
DEBUG 07:26:02 event Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\SecurityListener::onKernelControllerArguments"
}
DEBUG 07:26:02 event Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\IsGrantedListener::onKernelControllerArguments"
}
INFO 07:26:02 app jobstart AvisSend 46dc73d2612a09fced1c1d70196b2cbfae0b5a8315145861c8
DEBUG 07:26:02 doctrine Executing query: select min(id) from (select jh.id from job_history jh where jh.job_id=8 and resultcode=4 order by jh.id desc limit 20) x 
{
    "sql": "select min(id) from (select jh.id from job_history jh where jh.job_id=8 and resultcode=4 order by jh.id desc limit 20) x"
}
DEBUG 07:26:02 doctrine Executing query: delete from job_history where job_id=8 and resultcode=4 and id <0 
{
    "sql": "delete from job_history where job_id=8 and resultcode=4 and id <0"
}
DEBUG 07:26:02 doctrine Executing query: select min(id) from (select jh.id from job_history jh where jh.job_id=8 order by jh.id desc limit 100) x 
{
    "sql": "select min(id) from (select jh.id from job_history jh where jh.job_id=8 order by jh.id desc limit 100) x"
}
DEBUG 07:26:02 doctrine Executing query: delete from job_history where job_id=8 and id <7169785 
{
    "sql": "delete from job_history where job_id=8 and id <7169785"
}
DEBUG 07:26:02 doctrine Beginning transaction
DEBUG 07:26:02 doctrine Executing statement: INSERT INTO job_history (start, end, resultcode, resulttext, job_id) VALUES (?, ?, ?, ?, ?) (parameters: {params}, types: {types}) 
{
    "sql": "INSERT INTO job_history (start, end, resultcode, resulttext, job_id) VALUES (?, ?, ?, ?, ?)",
    "params": {
        "1": "2025-04-05 07:26:02",
        "2": null,
        "3": 1,
        "4": "",
        "5": 8
    },
    "types": {
        "1": 2,
        "2": 2,
        "3": 1,
        "4": 2,
        "5": 1
    }
}
DEBUG 07:26:02 doctrine Executing statement: UPDATE job SET last_run = ?, updated_at = ? WHERE id = ? (parameters: {params}, types: {types}) 
{
    "sql": "UPDATE job SET last_run = ?, updated_at = ? WHERE id = ?",
    "params": {
        "1": "2025-04-05 07:26:02",
        "2": "2025-04-05 07:26:02",
        "3": 8
    },
    "types": {
        "1": 2,
        "2": 2,
        "3": 1
    }
}
DEBUG 07:26:02 doctrine Committing transaction
DEBUG 07:26:02 doctrine Executing query: SELECT t0.id AS id_1, t0.state AS state_2, t0.step_kind AS step_kind_3, t0.description AS description_4, t0.state_message_ftp AS state_message_ftp_5, t0.state_message_fax AS state_message_fax_6, t0.state_message_mail AS state_message_mail_7, t0.state_message_sms AS state_message_sms_8, t0.state_message_api AS state_message_api_9, t0.changing_sending AS changing_sending_10, t0.state_group AS state_group_11, t0.avis_try AS avis_try_12, t0.show_hist AS show_hist_13, t0.bookable AS bookable_14, t0.export_state_id AS export_state_id_15, t0.sgroup_id AS sgroup_id_16 FROM type_sending_state t0 
{
    "sql": "SELECT t0.id AS id_1, t0.state AS state_2, t0.step_kind AS step_kind_3, t0.description AS description_4, t0.state_message_ftp AS state_message_ftp_5, t0.state_message_fax AS state_message_fax_6, t0.state_message_mail AS state_message_mail_7, t0.state_message_sms AS state_message_sms_8, t0.state_message_api AS state_message_api_9, t0.changing_sending AS changing_sending_10, t0.state_group AS state_group_11, t0.avis_try AS avis_try_12, t0.show_hist AS show_hist_13, t0.bookable AS bookable_14, t0.export_state_id AS export_state_id_15, t0.sgroup_id AS sgroup_id_16 FROM type_sending_state t0"
}
DEBUG 07:26:02 doctrine Executing query: SELECT t0.id AS id_1, t0.state AS state_2, t0.step_kind AS step_kind_3, t0.description AS description_4, t0.state_message_ftp AS state_message_ftp_5, t0.state_message_fax AS state_message_fax_6, t0.state_message_mail AS state_message_mail_7, t0.state_message_sms AS state_message_sms_8, t0.state_message_api AS state_message_api_9, t0.changing_sending AS changing_sending_10, t0.state_group AS state_group_11, t0.avis_try AS avis_try_12, t0.show_hist AS show_hist_13, t0.bookable AS bookable_14, t0.export_state_id AS export_state_id_15, t0.sgroup_id AS sgroup_id_16 FROM type_sending_state t0 
{
    "sql": "SELECT t0.id AS id_1, t0.state AS state_2, t0.step_kind AS step_kind_3, t0.description AS description_4, t0.state_message_ftp AS state_message_ftp_5, t0.state_message_fax AS state_message_fax_6, t0.state_message_mail AS state_message_mail_7, t0.state_message_sms AS state_message_sms_8, t0.state_message_api AS state_message_api_9, t0.changing_sending AS changing_sending_10, t0.state_group AS state_group_11, t0.avis_try AS avis_try_12, t0.show_hist AS show_hist_13, t0.bookable AS bookable_14, t0.export_state_id AS export_state_id_15, t0.sgroup_id AS sgroup_id_16 FROM type_sending_state t0"
}
DEBUG 07:26:02 doctrine Executing query: SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM type_sendavis_result t0 
{
    "sql": "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM type_sendavis_result t0"
}
DEBUG 07:26:02 doctrine Executing query: SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM type_sendavis_state t0 
{
    "sql": "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM type_sendavis_state t0"
}
DEBUG 07:26:02 doctrine Executing statement: SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.start AS start_4, t0.end AS end_5, t0.autotext AS autotext_6, t0.content AS content_7, t0.subject AS subject_8, t0.html AS html_9, t0.dropable AS dropable_10, t0.language AS language_11, t0.hwt AS hwt_12, t0.use_hwt AS use_hwt_13, t0.avis AS avis_14, t0.does_25_v AS does_25_v_15, t0.fixdate AS fixdate_16, t0.priority AS priority_17, t0.sending_state_id AS sending_state_id_18, t0.attach_type_id AS attach_type_id_19 FROM message t0 WHERE t0.id = ? LIMIT 1 (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.start AS start_4, t0.end AS end_5, t0.autotext AS autotext_6, t0.content AS content_7, t0.subject AS subject_8, t0.html AS html_9, t0.dropable AS dropable_10, t0.language AS language_11, t0.hwt AS hwt_12, t0.use_hwt AS use_hwt_13, t0.avis AS avis_14, t0.does_25_v AS does_25_v_15, t0.fixdate AS fixdate_16, t0.priority AS priority_17, t0.sending_state_id AS sending_state_id_18, t0.attach_type_id AS attach_type_id_19 FROM message t0 WHERE t0.id = ? LIMIT 1",
    "params": {
        "1": 1
    },
    "types": {
        "1": 1
    }
}
DEBUG 07:26:02 doctrine Executing statement: SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.start AS start_4, t0.end AS end_5, t0.autotext AS autotext_6, t0.content AS content_7, t0.subject AS subject_8, t0.html AS html_9, t0.dropable AS dropable_10, t0.language AS language_11, t0.hwt AS hwt_12, t0.use_hwt AS use_hwt_13, t0.avis AS avis_14, t0.does_25_v AS does_25_v_15, t0.fixdate AS fixdate_16, t0.priority AS priority_17, t0.sending_state_id AS sending_state_id_18, t0.attach_type_id AS attach_type_id_19 FROM message t0 WHERE t0.id = ? LIMIT 1 (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.start AS start_4, t0.end AS end_5, t0.autotext AS autotext_6, t0.content AS content_7, t0.subject AS subject_8, t0.html AS html_9, t0.dropable AS dropable_10, t0.language AS language_11, t0.hwt AS hwt_12, t0.use_hwt AS use_hwt_13, t0.avis AS avis_14, t0.does_25_v AS does_25_v_15, t0.fixdate AS fixdate_16, t0.priority AS priority_17, t0.sending_state_id AS sending_state_id_18, t0.attach_type_id AS attach_type_id_19 FROM message t0 WHERE t0.id = ? LIMIT 1",
    "params": {
        "1": 2
    },
    "types": {
        "1": 1
    }
}
DEBUG 07:26:02 doctrine Executing query: SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM type_sendavis_state t0 
{
    "sql": "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM type_sendavis_state t0"
}
DEBUG 07:26:02 doctrine Executing statement: SELECT t0.id AS id_1, t0.kind AS kind_2, t0.start AS start_3, t0.recipients AS recipients_4, t0.content AS content_5, t0.lastaction AS lastaction_6, t0.sending_id AS sending_id_7, t0.depot_id AS depot_id_8, t0.state_id AS state_id_9, t0.result_id AS result_id_10 FROM send_avis t0 WHERE t0.state_id = ? ORDER BY t0.lastaction ASC LIMIT 1000 (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.kind AS kind_2, t0.start AS start_3, t0.recipients AS recipients_4, t0.content AS content_5, t0.lastaction AS lastaction_6, t0.sending_id AS sending_id_7, t0.depot_id AS depot_id_8, t0.state_id AS state_id_9, t0.result_id AS result_id_10 FROM send_avis t0 WHERE t0.state_id = ? ORDER BY t0.lastaction ASC LIMIT 1000",
    "params": {
        "1": 1
    },
    "types": {
        "1": 1
    }
}
DEBUG 07:26:02 doctrine Executing statement: SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.description AS description_2, m0_.start AS start_3, m0_.end AS end_4, m0_.autotext AS autotext_5, m0_.content AS content_6, m0_.subject AS subject_7, m0_.html AS html_8, m0_.dropable AS dropable_9, m0_.language AS language_10, m0_.hwt AS hwt_11, m0_.use_hwt AS use_hwt_12, m0_.avis AS avis_13, m0_.does_25_v AS does_25_v_14, m0_.fixdate AS fixdate_15, m0_.priority AS priority_16, m0_.sending_state_id AS sending_state_id_17, m0_.attach_type_id AS attach_type_id_18 FROM message m0_ LEFT JOIN depot_message d1_ ON m0_.id = d1_.message_id WHERE d1_.depot_id = ? AND m0_.name LIKE ? ORDER BY m0_.id DESC (parameters: {params}, types: {types}) 
{
    "sql": "SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.description AS description_2, m0_.start AS start_3, m0_.end AS end_4, m0_.autotext AS autotext_5, m0_.content AS content_6, m0_.subject AS subject_7, m0_.html AS html_8, m0_.dropable AS dropable_9, m0_.language AS language_10, m0_.hwt AS hwt_11, m0_.use_hwt AS use_hwt_12, m0_.avis AS avis_13, m0_.does_25_v AS does_25_v_14, m0_.fixdate AS fixdate_15, m0_.priority AS priority_16, m0_.sending_state_id AS sending_state_id_17, m0_.attach_type_id AS attach_type_id_18 FROM message m0_ LEFT JOIN depot_message d1_ ON m0_.id = d1_.message_id WHERE d1_.depot_id = ? AND m0_.name LIKE ? ORDER BY m0_.id DESC",
    "params": {
        "1": "9",
        "2": "avis_sms%"
    },
    "types": {
        "1": 2,
        "2": 2
    }
}
DEBUG 07:26:02 doctrine Executing statement: SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_dev AS is_dev_5, t0.all_depot AS all_depot_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.title AS title_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.right_level_id AS right_level_id_13, t0.standard_depot_id AS standard_depot_id_14, t0.state_id AS state_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.id = ? LIMIT 1 (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_dev AS is_dev_5, t0.all_depot AS all_depot_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.title AS title_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.right_level_id AS right_level_id_13, t0.standard_depot_id AS standard_depot_id_14, t0.state_id AS state_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.id = ? LIMIT 1",
    "params": {
        "1": -1
    },
    "types": {
        "1": 2
    }
}
DEBUG 07:26:02 doctrine Executing statement: SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_dev AS is_dev_5, t0.all_depot AS all_depot_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.title AS title_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.right_level_id AS right_level_id_13, t0.standard_depot_id AS standard_depot_id_14, t0.state_id AS state_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.id = ? LIMIT 1 (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_dev AS is_dev_5, t0.all_depot AS all_depot_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.title AS title_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.right_level_id AS right_level_id_13, t0.standard_depot_id AS standard_depot_id_14, t0.state_id AS state_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.id = ? LIMIT 1",
    "params": {
        "1": -1
    },
    "types": {
        "1": 2
    }
}
DEBUG 07:26:02 doctrine Beginning transaction
DEBUG 07:26:02 doctrine Executing statement: INSERT INTO error (message, file, line, calls, url, callerip, created_at, updated_at, user_id, created_by_id, updated_by_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (parameters: {params}, types: {types}) 
{
    "sql": "INSERT INTO error (message, file, line, calls, url, callerip, created_at, updated_at, user_id, created_by_id, updated_by_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
    "params": {
        "1": "Warning: Undefined array key 0",
        "2": "/var/www/revision/dev/v05.00.0750/src/Job/AvisSend.php",
        "3": 87,
        "4": "[{\"file\":\"\\/var\\/www\\/revision\\/dev\\/v05.00.0750\\/src\\/Controller\\/RunController.php\",\"line\":\"100\",\"function\":\"run\",\"class\":\"App\\\\Job\\\\AvisSend\",\"type\":\"->\"},{\"file\":\"\\/var\\/www\\/revision\\/dev\\/v05.00.0750\\/vendor\\/symfony\\/http-kernel\\/HttpKernel.php\",\"line\":\"163\",\"function\":\"run\",\"class\":\"App\\\\Controller\\\\RunController\",\"type\":\"->\"},{\"file\":\"\\/var\\/www\\/revision\\/dev\\/v05.00.0750\\/vendor\\/symfony\\/http-kernel\\/HttpKernel.php\",\"line\":\"74\",\"function\":\"handleRaw\",\"class\":\"Symfony\\\\Component\\\\HttpKernel\\\\HttpKernel\",\"type\":\"->\"},{\"file\":\"\\/var\\/www\\/revision\\/dev\\/v05.00.0750\\/vendor\\/symfony\\/http-kernel\\/Kernel.php\",\"line\":\"184\",\"function\":\"handle\",\"class\":\"Symfony\\\\Component\\\\HttpKernel\\\\HttpKernel\",\"type\":\"->\"},{\"file\":\"\\/var\\/www\\/revision\\/dev\\/v05.00.0750\\/vendor\\/symfony\\/runtime\\/Runner\\/Symfony\\/HttpKernelRunner.php\",\"line\":\"35\",\"function\":\"handle\",\"class\":\"Symfony\\\\Component\\\\HttpKernel\\\\Kernel\",\"type\":\"->\"},{\"file\":\"\\/var\\/www\\/revision\\/dev\\/v05.00.0750\\/vendor\\/autoload_runtime.php\",\"line\":\"29\",\"function\":\"run\",\"class\":\"Symfony\\\\Component\\\\Runtime\\\\Runner\\\\Symfony\\\\HttpKernelRunner\",\"type\":\"->\"},{\"file\":\"\\/var\\/www\\/revision\\/dev\\/v05.00.0750\\/public\\/index.php\",\"line\":\"5\",\"args\":[\"\\/var\\/www\\/revision\\/dev\\/v05.00.0750\\/vendor\\/autoload_runtime.php\"],\"function\":\"require_once\"}]",
        "5": "https://dev.wunschliefertag.de/run/AvisSend/46dc73d2612a09fced1c1d70196b2cbfae0b5a8315145861c8",
        "6": "80.158.57.161",
        "7": "2025-04-05 07:26:02",
        "8": "2025-04-05 07:26:02",
        "9": null,
        "10": "-1",
        "11": "-1"
    },
    "types": {
        "1": 2,
        "2": 2,
        "3": 1,
        "4": 2,
        "5": 2,
        "6": 2,
        "7": 2,
        "8": 2,
        "9": 2,
        "10": 2,
        "11": 2
    }
}
DEBUG 07:26:02 doctrine Committing transaction
CRITICAL 07:26:02 request Uncaught PHP Exception ErrorException: "Warning: Undefined array key 0" at /var/www/revision/dev/v05.00.0750/src/Job/AvisSend.php line 87 
{
    "exception": {}
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 07:26:02 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 07:26:02 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 07:26:02 event Notified event "kernel.controller" to listener "App\EventSubscriber\MenuSubscriber::onControllerEvent". 
{
    "event": "kernel.controller",
    "listener": "App\\EventSubscriber\\MenuSubscriber::onControllerEvent"
}
DEBUG 07:26:02 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 07:26:02 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ControllerListener::onKernelController"
}
DEBUG 07:26:02 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ParamConverterListener::onKernelController"
}
DEBUG 07:26:02 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelController"
}
DEBUG 07:26:02 event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\TemplateListener::onKernelController"
}
DEBUG 07:26:02 event 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 07:26:02 event 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 07:26:02 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
DEBUG 07:26:02 event Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\SecurityListener::onKernelControllerArguments"
}
DEBUG 07:26:02 event Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\IsGrantedListener::onKernelControllerArguments"
}

Stack Trace

ErrorException 
ErrorException:
Warning: Undefined array key 0

  at src/Job/AvisSend.php:87
  at App\Job\AvisSend->run()
     (src/Controller/RunController.php:100)
  at App\Controller\RunController->run()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  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:29)
  at require_once('/var/www/revision/dev/v05.00.0750/vendor/autoload_runtime.php')
     (public/index.php:5)
Loading…
Loading the web debug toolbar…
Attempt #


0
https://dev.wunschliefertag.de/run/ExportMessageCreator/af2fb8969502bdd7401fedc0ef35b2cd380e446f641153b086


0
https://dev.wunschliefertag.de/run/CalendarBookableDate/a8596f5affe5d705700aca641ac95b591e72dbf3df5750a00f


0
https://dev.wunschliefertag.de/run/SendHinting/8fb4f5da7bec770d546a9c00d280e343eca8e53c69fa842812


0