Skip to content

Unknown column 'gender' in 'field list' #77

@virgilwashere

Description

@virgilwashere

mautic:integration:enhancer:installgendernames had been previously run on initial installation. Just hadn't gotten around to adding a new contact to this instance.

NB extended-fields is also installed.

[2019-01-16 13:08:47] mautic.NOTICE: PHP Notice - Undefined index: gender - in file /var/www/torpedo/mautic/plugins/MauticExtendedFieldBundle/Entity/ExtendedFieldRepositoryTrait.php - at line 249
[2019-01-16 13:08:47] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE leads SET preferred_locale = ?, gender = ? WHERE id = ?' with params ["en_AU", "M", 27]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'gender' in 'field list'" at /var/www/torpedo/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE leads SET preferred_locale = ?, gender = ? WHERE id = ?' with params [\"en_AU\", \"M\", 27]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'gender' in 'field list' at /var/www/torpedo/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'gender' in 'field list' at /var/www/torpedo/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'gender' in 'field list' at /var/www/torpedo/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)
[stacktrace]
#0 /var/www/torpedo/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))
#1 /var/www/torpedo/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1015): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'UPDATE leads SE...', Array)
#2 /var/www/torpedo/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(678): Doctrine\\DBAL\\Connection->executeUpdate('UPDATE leads SE...', Array, Array)
#3 /var/www/torpedo/mautic/plugins/MauticExtendedFieldBundle/Entity/ExtendedFieldRepositoryTrait.php(265): Doctrine\\DBAL\\Connection->update('leads', Array, Array)
#4 /var/www/torpedo/mautic/plugins/MauticExtendedFieldBundle/Model/OverrideLeadModel.php(251): MauticPlugin\\MauticExtendedFieldBundle\\Entity\\OverrideLeadRepository->saveEntity(Object(Mautic\\LeadBundle\\Entity\\Lead))
#5 /var/www/torpedo/mautic/app/bundles/LeadBundle/Controller/LeadController.php(449): MauticPlugin\\MauticExtendedFieldBundle\\Model\\OverrideLeadModel->saveEntity(Object(Mautic\\LeadBundle\\Entity\\Lead))
#6 /var/www/torpedo/mautic/app/bundles/CoreBundle/Controller/CommonController.php(475): Mautic\\LeadBundle\\Controller\\LeadController->newAction(0, '')
#7 /var/www/torpedo/mautic/vendor/symfony/http-kernel/HttpKernel.php(135): Mautic\\CoreBundle\\Controller\\CommonController->executeAction('new', 0, 0, '')
#8 /var/www/torpedo/mautic/vendor/symfony/http-kernel/HttpKernel.php(57): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 1)
#9 /var/www/torpedo/mautic/vendor/symfony/http-kernel/DependencyInjection/ContainerAwareHttpKernel.php(67): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)
#10 /var/www/torpedo/mautic/vendor/symfony/http-kernel/Kernel.php(183): Symfony\\Component\\HttpKernel\\DependencyInjection\\ContainerAwareHttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)
#11 /var/www/torpedo/mautic/app/AppKernel.php(141): Symfony\\Component\\HttpKernel\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)
#12 /var/www/torpedo/mautic/app/middlewares/CORSMiddleware.php(93): AppKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)
#13 /var/www/torpedo/mautic/app/middlewares/CatchExceptionMiddleware.php(45): Mautic\\Middleware\\CORSMiddleware->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)
#14 /var/www/torpedo/mautic/app/middlewares/VersionCheckMiddleware.php(57): Mautic\\Middleware\\CatchExceptionMiddleware->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)
#15 /var/www/torpedo/mautic/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Mautic\\Middleware\\VersionCheckMiddleware->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)
#16 /var/www/torpedo/mautic/vendor/stack/run/src/Stack/run.php(13): Stack\\StackedHttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))
#17 /var/www/torpedo/mautic/index.php(37): Stack\^Mun(Object(Stack\\StackedHttpKernel))
#18 {main}
"}
[2019-01-16 03:13:09] mautic.INFO: names.zip downloaded
[2019-01-16 03:13:09] mautic.INFO: Archive extracted to /tmp/genderNames/

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions