Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Internal Server Error when creating new Part #803

Closed
BangerTech opened this issue Dec 12, 2024 · 3 comments
Closed

Internal Server Error when creating new Part #803

BangerTech opened this issue Dec 12, 2024 · 3 comments
Labels
bug Something isn't working

Comments

@BangerTech
Copy link

BangerTech commented Dec 12, 2024 •
edited
Loading

Describe the bug
I just set up a new freshly installed docker container.
migrated the database from default to mariadb/mysql.
setting up user and attachment types and categories is no problem, but if i create a new part and click on save changes this error occurs.

To Reproduce
Steps to reproduce the behavior:

  1. Go to 'create new part'
  2. Click on 'save changes'
  3. Scroll down to '....'
  4. See error

Expected behavior
the ability to create a new part.

Screenshots
Bildschirmfoto 2024-12-12 um 19 42 12

Server Side

  • Part-DB Version: latest
  • PHP Version: latest docker & docker-compose
  • Database Server latest mariadb database
    all in a seperate container which are all on the same docker network

Desktop (please complete the following information):

  • OS: macOS
  • Browser chrome,thorium, safari
  • Version [e.g. 22]

`
services:
partdb:
container_name: partdb
# By default Part-DB will be running under Port 8080, you can change it here
ports:
- '8034:80'
volumes:
# By default
- ./uploads:/var/www/html/uploads
- ./public_media:/var/www/html/public/media
- ./db:/var/www/html/var/db

restart: unless-stopped
image: jbtronics/part-db1:latest


environment:

  - DATABASE_URL=mysql://partdb:root@mariadb:3306/partdb
  - APP_ENV=docker
  - DEFAULT_LANG=de
  - DEFAULT_TIMEZONE=Europe/Berlin
  - BASE_CURRENCY=EUR
  - INSTANCE_NAME=Part-DB
  - ALLOW_ATTACHMENT_DOWNLOADS=0
  - USE_GRAVATAR=0
  - PROVIDER_MOUSER_KEY=233b86cd-8c7a-4299-a722-e1616f5b3cf2
  - DEFAULT_URI=https://parts.server24-7.net
  - TRUSTED_PROXIES=192.168.2.55,192.168.2.182,192.168.2.1,192.168.2.83  
networks:
  - proxy

networks:
proxy:
external: true`

`services:
mariadb:
image: mariadb:latest
container_name: mariadb
restart: unless-stopped
environment:
- MYSQL_ROOT_PASSWORD=root
- MYSQL_DATABASE=partdb
- MYSQL_USER=partdb
- MYSQL_PASSWORD=root
volumes:
- ./mariadb-data:/var/lib/mysql
ports:
- "3306:3306"
networks:
- proxy

networks:
proxy:
external: true
`
@BangerTech BangerTech added the bug Something isn't working label Dec 12, 2024
@jbtronics
Copy link
Member

you should check the docker logs

@BangerTech
Copy link
Author

partdb | 192.168.2.182 - - [12/Dec/2024:18:52:24 +0000] "GET /de/part/new?category=3 HTTP/1.1" 200 15713 "https://parts.server24-7.net/de/category/3/parts" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36"
partdb | [2024-12-12T18:52:27.705839+00:00] request.INFO: Matched route "part_new". {"route":"part_new","route_parameters":{"_route":"part_new","_controller":"App\Controller\PartController::new","_locale":"de"},"request_uri":"https://parts.server24-7.net/de/part/new?category=3","method":"POST"} {"token":null,"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.708305+00:00] deprecation.INFO: User Deprecated: Since api-platform/core 3.3: Use a "ApiPlatform\State\ProviderInterface" as first argument in "ApiPlatform\Symfony\EventListener\QueryParameterValidateListener" instead of "ApiPlatform\ParameterValidator\ParameterValidator". {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since api-platform/core 3.3: Use a "ApiPlatform\State\ProviderInterface" as first argument in "ApiPlatform\Symfony\EventListener\QueryParameterValidateListener" instead of "ApiPlatform\ParameterValidator\ParameterValidator". at /var/www/html/vendor/api-platform/core/src/Symfony/EventListener/QueryParameterValidateListener.php:47)
partdb | [stacktrace]
partdb | #0 /var/www/html/var/cache/docker/ContainerOveKFnc/App_KernelDockerContainer.php(1309): ApiPlatform\Symfony\EventListener\QueryParameterValidateListener->__construct()
partdb | #1 /var/www/html/var/cache/docker/ContainerOveKFnc/App_KernelDockerContainer.php(398): ContainerOveKFnc\App_KernelDockerContainer::getApiPlatform_Listener_View_ValidateQueryParametersService()
partdb | #2 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(257): ContainerOveKFnc\App_KernelDockerContainer::ContainerOveKFnc\{closure}()
partdb | #3 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(220): Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure}()
partdb | #4 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
partdb | #5 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(157): Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
partdb | #6 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
partdb | #7 /var/www/html/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
partdb | #8 /var/www/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()
partdb | #9 /var/www/html/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
partdb | #10 /var/www/html/public/index.php(5): require_once()
partdb | #11 {main}
partdb | "} {"token":null,"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.710988+00:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"} {"token":null,"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.713365+00:00] deprecation.INFO: User Deprecated: Support for MySQL < 8 is deprecated and will be removed in DBAL 5 (AbstractMySQLDriver.php:70 called by AbstractDriverMiddleware.php:32, doctrine/dbal#6343, package doctrine/dbal) {"exception":"[object] (ErrorException(code: 0): User Deprecated: Support for MySQL < 8 is deprecated and will be removed in DBAL 5 (AbstractMySQLDriver.php:70 called by AbstractDriverMiddleware.php:32, doctrine/dbal#6343, package doctrine/dbal) at /var/www/html/vendor/doctrine/deprecations/lib/Doctrine/Deprecations/Deprecation.php:210)
partdb | [stacktrace]
partdb | #0 /var/www/html/vendor/doctrine/deprecations/lib/Doctrine/Deprecations/Deprecation.php(108): Doctrine\Deprecations\Deprecation::delegateTriggerToBackend()
partdb | #1 /var/www/html/vendor/doctrine/dbal/src/Driver/AbstractMySQLDriver.php(70): Doctrine\Deprecations\Deprecation::trigger()
partdb | #2 /var/www/html/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php(32): Doctrine\DBAL\Driver\AbstractMySQLDriver->getDatabasePlatform()
partdb | #3 /var/www/html/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php(32): Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform()
partdb | #4 /var/www/html/vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php(32): Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform()
partdb | #5 /var/www/html/vendor/doctrine/doctrine-bundle/src/ConnectionFactory.php(122): Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->getDatabasePlatform()
partdb | #6 /var/www/html/var/cache/docker/ContainerOveKFnc/App_KernelDockerContainer.php(269): Doctrine\Bundle\DoctrineBundle\ConnectionFactory->createConnection()
partdb | #7 /var/www/html/var/cache/docker/ContainerOveKFnc/App_KernelDockerContainer.php(341): ContainerOveKFnc\App_KernelDockerContainer::getDoctrine_Dbal_DefaultConnectionService()
partdb | #8 /var/www/html/var/cache/docker/ContainerOveKFnc/App_KernelDockerContainer.php(301): ContainerOveKFnc\App_KernelDockerContainer::getDoctrine_Orm_DefaultEntityManagerService()
partdb | #9 /var/www/html/vendor/symfony/var-exporter/Internal/LazyObjectState.php(100): ContainerOveKFnc\App_KernelDockerContainer::ContainerOveKFnc\{closure}()
partdb | #10 /var/www/html/vendor/symfony/var-exporter/LazyGhostTrait.php(178): Symfony\Component\VarExporter\Internal\LazyObjectState->initialize()
partdb | #11 /var/www/html/vendor/doctrine/orm/src/EntityManager.php(495): ContainerOveKFnc\EntityManagerGhost7633962->__get()
partdb | #12 /var/www/html/vendor/symfony/doctrine-bridge/Security/User/EntityUserProvider.php(136): Doctrine\ORM\EntityManager->getRepository()
partdb | #13 /var/www/html/vendor/symfony/doctrine-bridge/Security/User/EntityUserProvider.php(80): Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->getRepository()
partdb | #14 /var/www/html/vendor/symfony/security-http/Firewall/ContextListener.php(207): Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser()
partdb | #15 /var/www/html/vendor/symfony/security-http/Firewall/ContextListener.php(127): Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser()
partdb | #16 /var/www/html/vendor/symfony/security-http/Firewall/AbstractListener.php(26): Symfony\Component\Security\Http\Firewall\ContextListener->authenticate()
partdb | #17 /var/www/html/vendor/symfony/security-bundle/Security/LazyFirewallContext.php(60): Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke()
partdb | #18 /var/www/html/vendor/symfony/security-http/Firewall.php(128): Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke()
partdb | #19 /var/www/html/vendor/symfony/security-http/Firewall.php(95): Symfony\Component\Security\Http\Firewall->callListeners()
partdb | #20 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(260): Symfony\Component\Security\Http\Firewall->onKernelRequest()
partdb | #21 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(220): Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure}()
partdb | #22 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
partdb | #23 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(157): Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
partdb | #24 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
partdb | #25 /var/www/html/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
partdb | #26 /var/www/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()
partdb | #27 /var/www/html/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
partdb | #28 /var/www/html/public/index.php(5): require_once()
partdb | #29 {main}
partdb | "} {"token":null,"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.719513+00:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\Bridge\Doctrine\Security\User\EntityUserProvider","username":"BangerTECH"} {"token":null,"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.719597+00:00] security.DEBUG: Checking for authenticator support. {"firewall_name":"main","authenticators":5} {"token":{"authenticated":true,"roles":["ROLE_USER"],"user_identifier":"BangerTECH"},"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.719647+00:00] security.DEBUG: Checking support on authenticator. {"firewall_name":"main","authenticator":"App\Security\ApiTokenAuthenticator"} {"token":{"authenticated":true,"roles":["ROLE_USER"],"user_identifier":"BangerTECH"},"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.719683+00:00] security.DEBUG: Authenticator does not support the request. {"firewall_name":"main","authenticator":"App\Security\ApiTokenAuthenticator"} {"token":{"authenticated":true,"roles":["ROLE_USER"],"user_identifier":"BangerTECH"},"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.719704+00:00] security.DEBUG: Checking support on authenticator. {"firewall_name":"main","authenticator":"Scheb\TwoFactorBundle\Security\Http\Authenticator\TwoFactorAuthenticator"} {"token":{"authenticated":true,"roles":["ROLE_USER"],"user_identifier":"BangerTECH"},"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.719736+00:00] security.DEBUG: Authenticator does not support the request. {"firewall_name":"main","authenticator":"Scheb\TwoFactorBundle\Security\Http\Authenticator\TwoFactorAuthenticator"} {"token":{"authenticated":true,"roles":["ROLE_USER"],"user_identifier":"BangerTECH"},"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.719754+00:00] security.DEBUG: Checking support on authenticator. {"firewall_name":"main","authenticator":"Nbgrp\OneloginSamlBundle\Security\Http\Authenticator\SamlAuthenticator"} {"token":{"authenticated":true,"roles":["ROLE_USER"],"user_identifier":"BangerTECH"},"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.719775+00:00] security.DEBUG: Authenticator does not support the request. {"firewall_name":"main","authenticator":"Nbgrp\OneloginSamlBundle\Security\Http\Authenticator\SamlAuthenticator"} {"token":{"authenticated":true,"roles":["ROLE_USER"],"user_identifier":"BangerTECH"},"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.719791+00:00] security.DEBUG: Checking support on authenticator. {"firewall_name":"main","authenticator":"Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"} {"token":{"authenticated":true,"roles":["ROLE_USER"],"user_identifier":"BangerTECH"},"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.719810+00:00] security.DEBUG: Authenticator does not support the request. {"firewall_name":"main","authenticator":"Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"} {"token":{"authenticated":true,"roles":["ROLE_USER"],"user_identifier":"BangerTECH"},"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.719826+00:00] security.DEBUG: Checking support on authenticator. {"firewall_name":"main","authenticator":"Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"} {"token":{"authenticated":true,"roles":["ROLE_USER"],"user_identifier":"BangerTECH"},"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.719845+00:00] security.DEBUG: Authenticator does not support the request. {"firewall_name":"main","authenticator":"Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"} {"token":{"authenticated":true,"roles":["ROLE_USER"],"user_identifier":"BangerTECH"},"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.720359+00:00] deprecation.INFO: User Deprecated: Since web-auth/webauthn-symfony-bundle 4.9.0: The "Webauthn\AttestationStatement\AndroidSafetyNetAttestationStatementSupport" service is deprecated and will be removed in version 5.0.0. Android SafetyNet is now deprecated. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since web-auth/webauthn-symfony-bundle 4.9.0: The "Webauthn\AttestationStatement\AndroidSafetyNetAttestationStatementSupport" service is deprecated and will be removed in version 5.0.0. Android SafetyNet is now deprecated. at /var/www/html/var/cache/docker/ContainerOveKFnc/getAndroidSafetyNetAttestationStatementSupportService.php:23)
partdb | [stacktrace]
partdb | #0 /var/www/html/var/cache/docker/ContainerOveKFnc/App_KernelDockerContainer.php(201): ContainerOveKFnc\getAndroidSafetyNetAttestationStatementSupportService::do()
partdb | #1 /var/www/html/var/cache/docker/ContainerOveKFnc/App_KernelDockerContainer.php(932): ContainerOveKFnc\App_KernelDockerContainer->load()
partdb | #2 /var/www/html/var/cache/docker/ContainerOveKFnc/App_KernelDockerContainer.php(2497): ContainerOveKFnc\App_KernelDockerContainer::getAttestationStatementSupportManagerService()
partdb | #3 /var/www/html/var/cache/docker/ContainerOveKFnc/App_KernelDockerContainer.php(1236): ContainerOveKFnc\App_KernelDockerContainer::getSerializerService()
partdb | #4 /var/www/html/var/cache/docker/ContainerOveKFnc/App_KernelDockerContainer.php(393): ContainerOveKFnc\App_KernelDockerContainer::getApiPlatform_Listener_Request_DeserializeService()
partdb | #5 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(257): ContainerOveKFnc\App_KernelDockerContainer::ContainerOveKFnc\{closure}()
partdb | #6 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(220): Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure}()
partdb | #7 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
partdb | #8 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(157): Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
partdb | #9 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
partdb | #10 /var/www/html/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
partdb | #11 /var/www/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()
partdb | #12 /var/www/html/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
partdb | #13 /var/www/html/public/index.php(5): require_once()
partdb | #14 {main}
partdb | "} {"token":{"authenticated":true,"roles":["ROLE_USER"],"user_identifier":"BangerTECH"},"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.771098+00:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1442 Can't update table 'parts' in stored function/trigger because it is already used by statement which invoked this stored function/trigger" at ExceptionConverter.php line 91 {"exception":"[object] (Doctrine\DBAL\Exception\DriverException(code: 1442): An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1442 Can't update table 'parts' in stored function/trigger because it is already used by statement which invoked this stored function/trigger at /var/www/html/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:91)
partdb | [stacktrace]
partdb | #0 /var/www/html/vendor/doctrine/dbal/src/Connection.php(1373): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
partdb | #1 /var/www/html/vendor/doctrine/dbal/src/Connection.php(1315): Doctrine\DBAL\Connection->handleDriverException()
partdb | #2 /var/www/html/vendor/doctrine/dbal/src/Statement.php(108): Doctrine\DBAL\Connection->convertExceptionDuringQuery()
partdb | #3 /var/www/html/vendor/doctrine/dbal/src/Statement.php(133): Doctrine\DBAL\Statement->execute()
partdb | #4 /var/www/html/vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php(249): Doctrine\DBAL\Statement->executeStatement()
partdb | #5 /var/www/html/vendor/doctrine/orm/src/UnitOfWork.php(1051): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
partdb | #6 /var/www/html/vendor/doctrine/orm/src/UnitOfWork.php(400): Doctrine\ORM\UnitOfWork->executeInserts()
partdb | #7 /var/www/html/vendor/doctrine/orm/src/EntityManager.php(264): Doctrine\ORM\UnitOfWork->commit()
partdb | #8 /var/www/html/src/Controller/PartController.php(329): Doctrine\ORM\EntityManager->flush()
partdb | #9 /var/www/html/src/Controller/PartController.php(221): App\Controller\PartController->renderPartForm()
partdb | #10 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\PartController->new()
partdb | #11 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
partdb | #12 /var/www/html/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
partdb | #13 /var/www/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()
partdb | #14 /var/www/html/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
partdb | #15 /var/www/html/public/index.php(5): require_once('...')
partdb | #16 {main}
partdb | [previous exception] [object] (Doctrine\DBAL\Driver\PDO\Exception(code: 1442): SQLSTATE[HY000]: General error: 1442 Can't update table 'parts' in stored function/trigger because it is already used by statement which invoked this stored function/trigger at /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)
partdb | [stacktrace]
partdb | #0 /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Statement.php(57): Doctrine\DBAL\Driver\PDO\Exception::new()
partdb | #1 /var/www/html/vendor/doctrine/dbal/src/Statement.php(104): Doctrine\DBAL\Driver\PDO\Statement->execute()
partdb | #2 /var/www/html/vendor/doctrine/dbal/src/Statement.php(133): Doctrine\DBAL\Statement->execute()
partdb | #3 /var/www/html/vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php(249): Doctrine\DBAL\Statement->executeStatement()
partdb | #4 /var/www/html/vendor/doctrine/orm/src/UnitOfWork.php(1051): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
partdb | #5 /var/www/html/vendor/doctrine/orm/src/UnitOfWork.php(400): Doctrine\ORM\UnitOfWork->executeInserts()
partdb | #6 /var/www/html/vendor/doctrine/orm/src/EntityManager.php(264): Doctrine\ORM\UnitOfWork->commit()
partdb | #7 /var/www/html/src/Controller/PartController.php(329): Doctrine\ORM\EntityManager->flush()
partdb | #8 /var/www/html/src/Controller/PartController.php(221): App\Controller\PartController->renderPartForm()
partdb | #9 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\PartController->new()
partdb | #10 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
partdb | #11 /var/www/html/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
partdb | #12 /var/www/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()
partdb | #13 /var/www/html/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
partdb | #14 /var/www/html/public/index.php(5): require_once('...')
partdb | #15 {main}
partdb | [previous exception] [object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 1442 Can't update table 'parts' in stored function/trigger because it is already used by statement which invoked this stored function/trigger at /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:55)
partdb | [stacktrace]
partdb | #0 /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Statement.php(55): PDOStatement->execute()
partdb | #1 /var/www/html/vendor/doctrine/dbal/src/Statement.php(104): Doctrine\DBAL\Driver\PDO\Statement->execute()
partdb | #2 /var/www/html/vendor/doctrine/dbal/src/Statement.php(133): Doctrine\DBAL\Statement->execute()
partdb | #3 /var/www/html/vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php(249): Doctrine\DBAL\Statement->executeStatement()
partdb | #4 /var/www/html/vendor/doctrine/orm/src/UnitOfWork.php(1051): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
partdb | #5 /var/www/html/vendor/doctrine/orm/src/UnitOfWork.php(400): Doctrine\ORM\UnitOfWork->executeInserts()
partdb | #6 /var/www/html/vendor/doctrine/orm/src/EntityManager.php(264): Doctrine\ORM\UnitOfWork->commit()
partdb | #7 /var/www/html/src/Controller/PartController.php(329): Doctrine\ORM\EntityManager->flush()
partdb | #8 /var/www/html/src/Controller/PartController.php(221): App\Controller\PartController->renderPartForm()
partdb | #9 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\PartController->new()
partdb | #10 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
partdb | #11 /var/www/html/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
partdb | #12 /var/www/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()
partdb | #13 /var/www/html/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
partdb | #14 /var/www/html/public/index.php(5): require_once('...')
partdb | #15 {main}
partdb | "} {"token":{"authenticated":true,"roles":["ROLE_USER"],"user_identifier":"BangerTECH"},"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.775544+00:00] deprecation.INFO: User Deprecated: Since nelmio/security-bundle 3.4.0: The "Nelmio\SecurityBundle\EventListener\XssProtectionListener" class is deprecated, use Content Security Policy without allowing "unsafe-inline" scripts instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since nelmio/security-bundle 3.4.0: The "Nelmio\SecurityBundle\EventListener\XssProtectionListener" class is deprecated, use Content Security Policy without allowing "unsafe-inline" scripts instead. at /var/www/html/vendor/nelmio/security-bundle/src/EventListener/XssProtectionListener.php:35)
partdb | [stacktrace]
partdb | #0 /var/www/html/vendor/nelmio/security-bundle/src/EventListener/XssProtectionListener.php(80): Nelmio\SecurityBundle\EventListener\XssProtectionListener->__construct()
partdb | #1 /var/www/html/var/cache/docker/ContainerOveKFnc/App_KernelDockerContainer.php(2016): Nelmio\SecurityBundle\EventListener\XssProtectionListener::fromConfig()
partdb | #2 /var/www/html/var/cache/docker/ContainerOveKFnc/App_KernelDockerContainer.php(475): ContainerOveKFnc\App_KernelDockerContainer::getNelmioSecurity_XssProtectionListenerService()
partdb | #3 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(257): ContainerOveKFnc\App_KernelDockerContainer::ContainerOveKFnc\{closure}()
partdb | #4 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(220): Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure}()
partdb | #5 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
partdb | #6 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(214): Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
partdb | #7 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(202): Symfony\Component\HttpKernel\HttpKernel->filterResponse()
partdb | #8 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
partdb | #9 /var/www/html/vendor/symfony/http-kernel/EventListener/ErrorListener.php(117): Symfony\Component\HttpKernel\HttpKernel->handle()
partdb | #10 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(260): Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException()
partdb | #11 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(220): Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure}()
partdb | #12 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
partdb | #13 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(239): Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
partdb | #14 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(91): Symfony\Component\HttpKernel\HttpKernel->handleThrowable()
partdb | #15 /var/www/html/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
partdb | #16 /var/www/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()
partdb | #17 /var/www/html/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
partdb | #18 /var/www/html/public/index.php(5): require_once()
partdb | #19 {main}
partdb | "} {"token":{"authenticated":true,"roles":["ROLE_USER"],"user_identifier":"BangerTECH"},"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | [2024-12-12T18:52:27.776348+00:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} {"token":{"authenticated":true,"roles":["ROLE_USER"],"user_identifier":"BangerTECH"},"url":"/de/part/new?category=3","ip":"192.168.2.11","http_method":"POST","server":"parts.server24-7.net","referrer":"https://parts.server24-7.net/de/part/new?category=3"}
partdb | 192.168.2.182 - - [12/Dec/2024:18:52:27 +0000] "POST /de/part/new?category=3 HTTP/1.1" 500 4570 "https://parts.server24-7.net/de/part/new?category=3" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36"
partdb | - - 12/Dec/2024:18:52:27 +0000 "POST /index.php" 500

@BangerTech
Copy link
Author

sorry for the bad formatting ;-) found the error in one of my Triggers

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@jbtronics @BangerTech