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]