An exception occurred while exec... #468

New issue

Open

opened 2025-06-13 12:38:20 +02:00 by support-bot · 2 comments

support-bot commented

2025-06-13 12:38:20 +02:00

(Migrated from gitlab.weber-bodman.de)

An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'RE-2506-13-101' for key 'number_idx'

https://max.handwertig.com/documents/index/add/contactId/4888/orderId/3068:

An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'RE-2506-13-101' for key 'number_idx'\n\n#0 /var/www/invoice-max/vendor/doctrine/dbal/src/Connection.php(1939): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
#1 /var/www/invoice-max/vendor/doctrine/dbal/src/Connection.php(1881): Doctrine\DBAL\Connection->handleDriverException()
#2 /var/www/invoice-max/vendor/doctrine/dbal/src/Statement.php(194): Doctrine\DBAL\Connection->convertExceptionDuringQuery()
#3 /var/www/invoice-max/vendor/doctrine/dbal/src/Statement.php(249): Doctrine\DBAL\Statement->execute()
#4 /var/www/invoice-max/vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php(285): Doctrine\DBAL\Statement->executeStatement()
#5 /var/www/invoice-max/vendor/doctrine/orm/src/UnitOfWork.php(1183): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
#6 /var/www/invoice-max/vendor/doctrine/orm/src/UnitOfWork.php(447): Doctrine\ORM\UnitOfWork->executeInserts()
#7 /var/www/invoice-max/vendor/doctrine/orm/src/EntityManager.php(403): Doctrine\ORM\UnitOfWork->commit()
#8 /var/www/invoice-max/application/modules/documents/controllers/IndexController.php(347): Doctrine\ORM\EntityManager->flush()
#9 /var/www/invoice-max/vendor/shardj/zf1-future/library/Zend/Controller/Action.php(522): Documents_IndexController->addAction()
#10 /var/www/invoice-max/vendor/shardj/zf1-future/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch()
#11 /var/www/invoice-max/vendor/shardj/zf1-future/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
#12 /var/www/invoice-max/vendor/shardj/zf1-future/library/Zend/Application/Bootstrap/Bootstrap.php(106): Zend_Controller_Front->dispatch()
#13 /var/www/invoice-max/vendor/shardj/zf1-future/library/Zend/Application.php(400): Zend_Application_Bootstrap_Bootstrap->run()
#14 /var/www/invoice-max/public/index.php(35): Zend_Application->run()
#15 {main}

An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'RE-2506-13-101' for key 'number_idx' https://max.handwertig.com/documents/index/add/contactId/4888/orderId/3068: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'RE-2506-13-101' for key 'number_idx'\n\n#0 /var/www/invoice-max/vendor/doctrine/dbal/src/Connection.php(1939): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() #1 /var/www/invoice-max/vendor/doctrine/dbal/src/Connection.php(1881): Doctrine\DBAL\Connection->handleDriverException() #2 /var/www/invoice-max/vendor/doctrine/dbal/src/Statement.php(194): Doctrine\DBAL\Connection->convertExceptionDuringQuery() #3 /var/www/invoice-max/vendor/doctrine/dbal/src/Statement.php(249): Doctrine\DBAL\Statement->execute() #4 /var/www/invoice-max/vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php(285): Doctrine\DBAL\Statement->executeStatement() #5 /var/www/invoice-max/vendor/doctrine/orm/src/UnitOfWork.php(1183): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts() #6 /var/www/invoice-max/vendor/doctrine/orm/src/UnitOfWork.php(447): Doctrine\ORM\UnitOfWork->executeInserts() #7 /var/www/invoice-max/vendor/doctrine/orm/src/EntityManager.php(403): Doctrine\ORM\UnitOfWork->commit() #8 /var/www/invoice-max/application/modules/documents/controllers/IndexController.php(347): Doctrine\ORM\EntityManager->flush() #9 /var/www/invoice-max/vendor/shardj/zf1-future/library/Zend/Controller/Action.php(522): Documents_IndexController->addAction() #10 /var/www/invoice-max/vendor/shardj/zf1-future/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch() #11 /var/www/invoice-max/vendor/shardj/zf1-future/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch() #12 /var/www/invoice-max/vendor/shardj/zf1-future/library/Zend/Application/Bootstrap/Bootstrap.php(106): Zend_Controller_Front->dispatch() #13 /var/www/invoice-max/vendor/shardj/zf1-future/library/Zend/Application.php(400): Zend_Application_Bootstrap_Bootstrap->run() #14 /var/www/invoice-max/public/index.php(35): Zend_Application->run() #15 {main}

maxi commented

2025-06-13 13:08:14 +02:00

(Migrated from gitlab.weber-bodman.de)

Das passiert eigentlich höchstens, wenn man am Nummerngenerator schraubt.

Wurde folgendes Dokument erstellt, obwohl es eine Fehlermeldung gab, danach oder Bestand es bereits zuvor?

https://max.handwertig.com/documents/documents/view/contactId/4888/orderId/3068/documentId/1759

Das passiert eigentlich höchstens, wenn man am Nummerngenerator schraubt. Wurde folgendes Dokument erstellt, obwohl es eine Fehlermeldung gab, danach oder Bestand es bereits zuvor? https://max.handwertig.com/documents/documents/view/contactId/4888/orderId/3068/documentId/1759

maxi commented

2025-06-13 15:47:12 +02:00

(Migrated from gitlab.weber-bodman.de)

Besteht akuter Handlungsbedarf?