registration error message

[craigh]

@rallek said (originally in #3720 - this content removed from there and placed here to separate issues)

Initial issue

If a zauth registration is made with an existing email address I do get this error message:

[1] Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException: An exception occurred while executing 'DELETE FROM users WHERE uid = ?' with params [24]:

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`d02726dc`.`users_attributes`, CONSTRAINT `FK_E6F031E4A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`uid`))
    at n/a
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60

    at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred while executing 'DELETE FROM users WHERE uid = ?' with params [24]:

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`d02726dc`.`users_attributes`, CONSTRAINT `FK_E6F031E4A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`uid`))', object(PDOException))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 128

    at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'DELETE FROM users WHERE uid = ?', array('24'))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 1015

    at Doctrine\DBAL\Connection->executeUpdate('DELETE FROM users WHERE uid = ?', array('24'), array('integer'))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 597

    at Doctrine\DBAL\Connection->delete('users', array('uid' => '24'), array('integer'))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php line 580

    at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->delete(object(UserEntity))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 1094

    at Doctrine\ORM\UnitOfWork->executeDeletions(object(ClassMetadata))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 406

    at Doctrine\ORM\UnitOfWork->commit(object(UserEntity))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php line 356

    at Doctrine\ORM\EntityManager->flush(object(UserEntity))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/system/UsersModule/Entity/Repository/UserRepository.php line 45

    at Zikula\UsersModule\Entity\Repository\UserRepository->removeAndFlush(object(UserEntity))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/system/UsersModule/Controller/RegistrationController.php line 155

    at Zikula\UsersModule\Controller\RegistrationController->registerAction(object(Zikula_Request_Http))
        in  line 

    at call_user_func_array(array(object(RegistrationController), 'registerAction'), array(object(Zikula_Request_Http)))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 144

    at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Zikula_Request_Http), '1')
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 64

    at Symfony\Component\HttpKernel\HttpKernel->handle(object(Zikula_Request_Http), '1', true)
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/DependencyInjection/ContainerAwareHttpKernel.php line 69

    at Symfony\Component\HttpKernel\DependencyInjection\ContainerAwareHttpKernel->handle(object(Zikula_Request_Http), '1', true)
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php line 185

    at Symfony\Component\HttpKernel\Kernel->handle(object(Zikula_Request_Http))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/index.php line 23

[2] Doctrine\DBAL\Driver\PDOException: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`d02726dc`.`users_attributes`, CONSTRAINT `FK_E6F031E4A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`uid`))
    at n/a
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php line 107

    at Doctrine\DBAL\Driver\PDOStatement->execute()
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 1006

    at Doctrine\DBAL\Connection->executeUpdate('DELETE FROM users WHERE uid = ?', array('24'), array('integer'))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 597

    at Doctrine\DBAL\Connection->delete('users', array('uid' => '24'), array('integer'))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php line 580

    at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->delete(object(UserEntity))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 1094

    at Doctrine\ORM\UnitOfWork->executeDeletions(object(ClassMetadata))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 406

    at Doctrine\ORM\UnitOfWork->commit(object(UserEntity))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php line 356

    at Doctrine\ORM\EntityManager->flush(object(UserEntity))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/system/UsersModule/Entity/Repository/UserRepository.php line 45

    at Zikula\UsersModule\Entity\Repository\UserRepository->removeAndFlush(object(UserEntity))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/system/UsersModule/Controller/RegistrationController.php line 155

    at Zikula\UsersModule\Controller\RegistrationController->registerAction(object(Zikula_Request_Http))
        in  line 

    at call_user_func_array(array(object(RegistrationController), 'registerAction'), array(object(Zikula_Request_Http)))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 144

    at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Zikula_Request_Http), '1')
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 64

    at Symfony\Component\HttpKernel\HttpKernel->handle(object(Zikula_Request_Http), '1', true)
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/DependencyInjection/ContainerAwareHttpKernel.php line 69

    at Symfony\Component\HttpKernel\DependencyInjection\ContainerAwareHttpKernel->handle(object(Zikula_Request_Http), '1', true)
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php line 185

    at Symfony\Component\HttpKernel\Kernel->handle(object(Zikula_Request_Http))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/index.php line 23

[3] PDOException: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`d02726dc`.`users_attributes`, CONSTRAINT `FK_E6F031E4A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`uid`))
    at n/a
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php line 105

    at PDOStatement->execute(null)
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php line 105

    at Doctrine\DBAL\Driver\PDOStatement->execute()
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 1006

    at Doctrine\DBAL\Connection->executeUpdate('DELETE FROM users WHERE uid = ?', array('24'), array('integer'))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 597

    at Doctrine\DBAL\Connection->delete('users', array('uid' => '24'), array('integer'))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php line 580

    at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->delete(object(UserEntity))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 1094

    at Doctrine\ORM\UnitOfWork->executeDeletions(object(ClassMetadata))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php line 406

    at Doctrine\ORM\UnitOfWork->commit(object(UserEntity))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php line 356

    at Doctrine\ORM\EntityManager->flush(object(UserEntity))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/system/UsersModule/Entity/Repository/UserRepository.php line 45

    at Zikula\UsersModule\Entity\Repository\UserRepository->removeAndFlush(object(UserEntity))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/system/UsersModule/Controller/RegistrationController.php line 155

    at Zikula\UsersModule\Controller\RegistrationController->registerAction(object(Zikula_Request_Http))
        in  line 

    at call_user_func_array(array(object(RegistrationController), 'registerAction'), array(object(Zikula_Request_Http)))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 144

    at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Zikula_Request_Http), '1')
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 64

    at Symfony\Component\HttpKernel\HttpKernel->handle(object(Zikula_Request_Http), '1', true)
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/DependencyInjection/ContainerAwareHttpKernel.php line 69

    at Symfony\Component\HttpKernel\DependencyInjection\ContainerAwareHttpKernel->handle(object(Zikula_Request_Http), '1', true)
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php line 185

    at Symfony\Component\HttpKernel\Kernel->handle(object(Zikula_Request_Http))
        in /www/htdocs/w0172993/2017.oldtimerigosnabrueck.de/Zikula_Core-1.5.0/index.php line 23

Later conversation

setting is native_either

Steps to reproduce:

• register with normal Username and email address at the site 2017.oldtimerigosnabrueck.de
• as the process is moderated the admin now is approving the registration
• next register a new user with the same email than just before
• submit and see the error

Native_either is still defined in the settings and shown for the first registered User in the zauth module

Additional information: The user is available in the UsersModule user list and shown pending But not shown in the zauth module users list

The first registration was approved. After approving I started the second user

PHP Version 5.6.30-nmm1
MySQL: 5.7.15

next try: Also if the first user is verifying his mail address I do get the same error.

[craigh]

I can reproduce this on Ralf's site, but I've tried nearly every combination of this on my home machine and cannot reproduce it.

the basic issue is that it appears on @rallek 's site, the user_attributes are not removed on cascade as part of the user entity removal (on a failed registration). But on my local site it works as expected (cascade=all is set up in the entity). Therefore I am wondering if the MySQL version is affecting this somehow - I have MySql 5.6.35

[craigh]

@Guite can you try this on your machine or do you have any input here?

[craigh]

@rallek please upload and test build >= 252 http://ci.zikula.org/job/Zikula_Core-1.5.0/lastSuccessfulBuild/

[rallek]

done with the same result :-(

I downloaded latest ci build via wget. Than tar -xpzf so it copied over the current installation. Cache is cleared.

[Guite]

One user attribute (name authentication_method) is still remaining in the attributes table when it tries to delete the user.