# Shopware 6.4.20.2 zu 6.5.0.0 nicht möglich

**URL:** <https://forum.shopware.com/t/shopware-6-4-20-2-zu-6-5-0-0-nicht-moeglich/99857>\
**Category:** Allgemein\
**Created:** [26. Mai 2023 um 14:37 UTC](https://forum.shopware.com/t/shopware-6-4-20-2-zu-6-5-0-0-nicht-moeglich/99857 "2023-05-26T14:37:34Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![RonnyBLN](https://avatars.discourse-cdn.com/v4/letter/r/34f0e0/32.png) [@RonnyBLN](https://forum.shopware.com/u/RonnyBLN)\
**Post date:** [26. Mai 2023 um 14:37 UTC](https://forum.shopware.com/t/shopware-6-4-20-2-zu-6-5-0-0-nicht-moeglich/99857/1 "2023-05-26T14:37:34Z")

</div>

Hallo, hat jemand auch das Problem? Es sind irgendwie bei der Clean Neuinstallation (6.5.00) 3 Anreden drin und bei der anderen sind 4 Anreden drin gewesen. Habe die undefinied gelöscht aber es geht trotzdem nicht.

Hier ein Auszug aus der Log Datei es geht um einen Foreign Key Salutation - für mich hat das was mit Anrede zu tun und unten sind dann auch 3 Fehler dazu. (vielleicht die 3 Anreden: Herr, Frau und Bitte wählen)

Wer hat das gleiche oder hat ne Ahnung was man da machen kann?

Exception trace:  
at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:164  
Shopware\Core\Framework\Migration\Command\MigrationCommand-\>runMigrationForIdentifier() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:99  
Shopware\Core\Framework\Migration\Command\MigrationCommand-\>execute() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Command/Command.php:312  
Symfony\Component\Console\Command\Command-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Command/LazyCommand.php:76  
Symfony\Component\Console\Command\LazyCommand-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:120  
Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand-\>runMigrations() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:85  
Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand-\>execute() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Command/Command.php:312  
Symfony\Component\Console\Command\Command-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Application.php:1040  
Symfony\Component\Console\Application-\>doRunCommand() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/framework-bundle/Console/Application.php:88  
Symfony\Bundle\FrameworkBundle\Console\Application-\>doRunCommand() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Application.php:314  
Symfony\Component\Console\Application-\>doRun() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/framework-bundle/Console/Application.php:77  
Symfony\Bundle\FrameworkBundle\Console\Application-\>doRun() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Application.php:168  
Symfony\Component\Console\Application-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php:54  
Symfony\Component\Runtime\Runner\Symfony\ConsoleApplicationRunner-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/autoload\_runtime.php:29  
require\_once() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/bin/console:15

In ExceptionConverter.php line 117:

[Doctrine\DBAL\Exception\DriverException (1091)]  
An exception occurred while executing a query: SQLSTATE[42000]: Syntax erro  
r or access violation: 1091 Can’t DROP ‚fk.customer\_address.salutation\_id‘;  
check that column/key exists

Exception trace:  
at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117  
Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter-\>convert() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/doctrine/dbal/src/Connection.php:1935  
Doctrine\DBAL\Connection-\>handleDriverException() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/doctrine/dbal/src/Connection.php:1878  
Doctrine\DBAL\Connection-\>convertExceptionDuringQuery() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/doctrine/dbal/src/Connection.php:1206  
Doctrine\DBAL\Connection-\>executeStatement() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Migration/V6\_5/Migration1673420896RemoveUndefinedSalutation.php:38  
Shopware\Core\Migration\V6\_5\Migration1673420896RemoveUndefinedSalutation-\>update() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Framework/Migration/MigrationRuntime.php:38  
Shopware\Core\Framework\Migration\MigrationRuntime-\>migrate() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:55  
Shopware\Core\Framework\Migration\Command\MigrationCommand-\>getMigrationGenerator() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:157  
Shopware\Core\Framework\Migration\Command\MigrationCommand-\>runMigrationForIdentifier() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:99  
Shopware\Core\Framework\Migration\Command\MigrationCommand-\>execute() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Command/Command.php:312  
Symfony\Component\Console\Command\Command-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Command/LazyCommand.php:76  
Symfony\Component\Console\Command\LazyCommand-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:120  
Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand-\>runMigrations() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:85  
Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand-\>execute() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Command/Command.php:312  
Symfony\Component\Console\Command\Command-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Application.php:1040  
Symfony\Component\Console\Application-\>doRunCommand() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/framework-bundle/Console/Application.php:88  
Symfony\Bundle\FrameworkBundle\Console\Application-\>doRunCommand() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Application.php:314  
Symfony\Component\Console\Application-\>doRun() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/framework-bundle/Console/Application.php:77  
Symfony\Bundle\FrameworkBundle\Console\Application-\>doRun() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Application.php:168  
Symfony\Component\Console\Application-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php:54  
Symfony\Component\Runtime\Runner\Symfony\ConsoleApplicationRunner-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/autoload\_runtime.php:29  
require\_once() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/bin/console:15

In Exception.php line 28:

[Doctrine\DBAL\Driver\PDO\Exception (1091)]  
SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‚fk.cust  
omer\_address.salutation\_id‘; check that column/key exists

Exception trace:  
at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28  
Doctrine\DBAL\Driver\PDO\Exception::new() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:38  
Doctrine\DBAL\Driver\PDO\Connection-\>exec() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:46  
Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware-\>exec() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:74  
Symfony\Bridge\Doctrine\Middleware\Debug\Connection-\>exec() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/doctrine/dbal/src/Connection.php:1204  
Doctrine\DBAL\Connection-\>executeStatement() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Migration/V6\_5/Migration1673420896RemoveUndefinedSalutation.php:38  
Shopware\Core\Migration\V6\_5\Migration1673420896RemoveUndefinedSalutation-\>update() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Framework/Migration/MigrationRuntime.php:38  
Shopware\Core\Framework\Migration\MigrationRuntime-\>migrate() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:55  
Shopware\Core\Framework\Migration\Command\MigrationCommand-\>getMigrationGenerator() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:157  
Shopware\Core\Framework\Migration\Command\MigrationCommand-\>runMigrationForIdentifier() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:99  
Shopware\Core\Framework\Migration\Command\MigrationCommand-\>execute() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Command/Command.php:312  
Symfony\Component\Console\Command\Command-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Command/LazyCommand.php:76  
Symfony\Component\Console\Command\LazyCommand-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:120  
Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand-\>runMigrations() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:85  
Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand-\>execute() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Command/Command.php:312  
Symfony\Component\Console\Command\Command-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Application.php:1040  
Symfony\Component\Console\Application-\>doRunCommand() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/framework-bundle/Console/Application.php:88  
Symfony\Bundle\FrameworkBundle\Console\Application-\>doRunCommand() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Application.php:314  
Symfony\Component\Console\Application-\>doRun() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/framework-bundle/Console/Application.php:77  
Symfony\Bundle\FrameworkBundle\Console\Application-\>doRun() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Application.php:168  
Symfony\Component\Console\Application-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php:54  
Symfony\Component\Runtime\Runner\Symfony\ConsoleApplicationRunner-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/autoload\_runtime.php:29  
require\_once() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/bin/console:15

In Connection.php line 32:

[PDOException (42000)]  
SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‚fk.cust  
omer\_address.salutation\_id‘; check that column/key exists

Exception trace:  
at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:32  
PDO-\>exec() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:32  
Doctrine\DBAL\Driver\PDO\Connection-\>exec() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:46  
Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware-\>exec() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:74  
Symfony\Bridge\Doctrine\Middleware\Debug\Connection-\>exec() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/doctrine/dbal/src/Connection.php:1204  
Doctrine\DBAL\Connection-\>executeStatement() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Migration/V6\_5/Migration1673420896RemoveUndefinedSalutation.php:38  
Shopware\Core\Migration\V6\_5\Migration1673420896RemoveUndefinedSalutation-\>update() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Framework/Migration/MigrationRuntime.php:38  
Shopware\Core\Framework\Migration\MigrationRuntime-\>migrate() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:55  
Shopware\Core\Framework\Migration\Command\MigrationCommand-\>getMigrationGenerator() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:157  
Shopware\Core\Framework\Migration\Command\MigrationCommand-\>runMigrationForIdentifier() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:99  
Shopware\Core\Framework\Migration\Command\MigrationCommand-\>execute() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Command/Command.php:312  
Symfony\Component\Console\Command\Command-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Command/LazyCommand.php:76  
Symfony\Component\Console\Command\LazyCommand-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:120  
Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand-\>runMigrations() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:85  
Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand-\>execute() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Command/Command.php:312  
Symfony\Component\Console\Command\Command-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Application.php:1040  
Symfony\Component\Console\Application-\>doRunCommand() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/framework-bundle/Console/Application.php:88  
Symfony\Bundle\FrameworkBundle\Console\Application-\>doRunCommand() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Application.php:314  
Symfony\Component\Console\Application-\>doRun() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/framework-bundle/Console/Application.php:77  
Symfony\Bundle\FrameworkBundle\Console\Application-\>doRun() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/console/Application.php:168  
Symfony\Component\Console\Application-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php:54  
Symfony\Component\Runtime\Runner\Symfony\ConsoleApplicationRunner-\>run() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/vendor/autoload\_runtime.php:29  
require\_once() at /var/www/vhosts/hx8pckcj.web3.alfahosting-server.de/sneakfreaxx.store/bin/console:15

system:update:finish [–skip-asset-build]