Avisota 2: Fatal error beim Anlegen einer Anrede

[rusty]

Wenn ich eine neue Regel zu den Anreden hinzufügen möchte, kommt folgender fataler Fehler. Das Feld sorting darf nicht NULL sein.

Fatal error: Uncaught exception Doctrine\DBAL\DBALException with message An exception occurred while executing 'INSERT INTO orm_avisota_salutation (id, createdAt, updatedAt, sorting, salutation, enableGenderFilter, genderFilter, enableRequiredFieldsFilter, requiredFieldsFilter, salutationGroup) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["d8fe5e22-f7d9-11e3-b1c3-005056bb7e8b", "2014-06-19 17:47:57", "2014-06-19 17:47:57", null, "Liebe(r) ##title## ##forename## ##surname##", "", null, "1", "a:3:{i:0;s:5:\"title\";i:1;s:8:\"forename\";i:2;s :7:\"surname\";}", "141f23a8-f0ad-11e3-9cc1-005056bb7e8b"]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'sorting' cannot be null thrown in composer/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 91

#0 composer/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(167): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'INSERT INTO orm...', Array)
#1 composer/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php(279): Doctrine\DBAL\Statement->execute()
#2 composer/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(965): Doctrine\ORM\Persisters\BasicEntityPersister->executeInserts()
#3 composer/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(335): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata))
#4 composer/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(389): Doctrine\ORM\UnitOfWork->commit(NULL)
#5 composer/vendor/bit3/contao-doctrine-orm/src/Contao/Doctrine/ORM/DataContainer/General/EntityDataProvider.php(391): Doctrine\ORM\EntityManager->flush()
#6 composer/vendor/contao-community-alliance/dc-general/src/ContaoCommunityAlliance/DcGeneral/Contao/View/Contao2BackendView/BaseView.php(1632): Contao\Doctrine\ORM\DataContainer\General\EntityDataProvider->save(Object(Contao\Doctrine\ORM\DataContainer\General\EntityModel))
#7 composer/vendor/contao-community-alliance/dc-general/src/ContaoCommunityAlliance/DcGeneral/Contao/View/Contao2BackendView/BaseView.php(964): ContaoCommunityAlliance\DcGeneral\Contao\View\Contao2BackendView\BaseView->createEditMask(Object(Contao\Doctrine\ORM\DataContainer\General\EntityModel), NULL, Object(Closure), Object(Closure))
#8 [internal function]: ContaoCommunityAlliance\DcGeneral\Contao\View\Contao2BackendView\BaseView->create()
#9 composer/vendor/contao-community-alliance/dc-general/src/ContaoCommunityAlliance/DcGeneral/Contao/View/Contao2BackendView/BaseView.php(155): call_user_func_array(Array, Array)
#10 [internal function]: ContaoCommunityAlliance\DcGeneral\Contao\View\Contao2BackendView\BaseView->handleAction(Object(ContaoCommunityAlliance\DcGeneral\Event\ActionEvent))
#11 composer/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php(164): call_user_func(Array, Object(ContaoCommunityAlliance\DcGeneral\Event\ActionEvent))
#12 composer/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php(53): Symfony\Component\EventDispatcher\EventDispatcher->doDispatch(Array, 'dc-general.acti...', Object(ContaoCommunityAlliance\DcGeneral\Event\ActionEvent))
#13 composer/vendor/contao-community-alliance/dc-general/src/ContaoCommunityAlliance/DcGeneral/Event/EventPropagator.php(120): Symfony\Component\EventDispatcher\EventDispatcher->dispatch('dc-general.acti...', Object(ContaoCommunityAlliance\DcGeneral\Event\ActionEvent))
#14 composer/vendor/contao-community-alliance/dc-general/src/ContaoCommunityAlliance/DcGeneral/Event/EventPropagator.php(72): ContaoCommunityAlliance\DcGeneral\Event\EventPropagator->dispatch('dc-general.acti...', Object(ContaoCommunityAlliance\DcGeneral\Event\ActionEvent))
#15 composer/vendor/contao-community-alliance/dc-general/src/ContaoCommunityAlliance/DcGeneral/Controller/DefaultController.php(122): ContaoCommunityAlliance\DcGeneral\Event\EventPropagator->propagate('dc-general.acti...', Object(ContaoCommunityAlliance\DcGeneral\Event\ActionEvent), Array)
#16 composer/vendor/contao-community-alliance/dc-general/src/ContaoCommunityAlliance/DcGeneral/DC_General.php(233): ContaoCommunityAlliance\DcGeneral\Controller\DefaultController->handle(Object(ContaoCommunityAlliance\DcGeneral\Action))
#17 composer/vendor/contao-community-alliance/dc-general/src/ContaoCommunityAlliance/DcGeneral/DC_General.php(257): ContaoCommunityAlliance\DcGeneral\DC_General->callAction()
#18 system/modules/core/classes/Backend.php(430): ContaoCommunityAlliance\DcGeneral\DC_General->create()
#19 contao/main.php(142): Contao\Backend->getBackendModule('avisota_salutat...')
#20 contao/main.php(293): Main->run()
#21 {main}

[tril]

Das ist jetzt behoben.
https://avisota.atlassian.net/browse/CTO-71

[elwega]

Hallo erst mal.
Avisote wäre im Moment mal eine gute Lösung für einen Wunsch.
Aber ich bekomme den Fehler unten.

Das ist jetzt behoben.
https://avisota.atlassian.net/browse/CTO-71

Fatal error: Uncaught exception Doctrine\DBAL\DBALException with message An exception occurred while executing 'INSERT INTO orm_avisota_salutation (id, createdAt, updatedAt, sorting, salutation, enableGenderFilter, genderFilter, enableRequiredFieldsFilter, requiredFieldsFilter, salutationGroup) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["8abf2624-d848-11e4-9ffd-525400fb9b5a", "2015-04-01 10:24:40", "2015-04-01 10:24:40", null, "s##id##", 0, null, 0, null, "34510058-d845-11e4-9ffd-525400fb9b5a"]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'sorting' cannot be null thrown in system/modules/!avisota-nightly-build/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 91

Das geht wohl in die gleiche Richtung und ich kann da selbst nicht viel tun.
Kann jemand da helfen?