# Artikel Import nach update 6.5.0 nicht möglich
**URL:** https://forum.shopware.com/t/artikel-import-nach-update-6-5-0-nicht-moeglich/99591
**Category:** Shopware 6 (German)
**Created:** [8. Mai 2023 um 10:51 UTC](https://forum.shopware.com/t/artikel-import-nach-update-6-5-0-nicht-moeglich/99591 "2023-05-08T10:51:21Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@concept24](https://forum.shopware.com/u/concept24)
#### Post date: [8. Mai 2023 um 10:51 UTC](https://forum.shopware.com/t/artikel-import-nach-update-6-5-0-nicht-moeglich/99591/1 "2023-05-08T10:51:21Z")
Artikel Import nach update 6.5.0 nicht möglich
---
### Author:  [@autostar-handel](https://forum.shopware.com/u/autostar-handel)
#### Post date: [8. Mai 2023 um 11:25 UTC](https://forum.shopware.com/t/artikel-import-nach-update-6-5-0-nicht-moeglich/99591/2 "2023-05-08T11:25:03Z")
na prima mir zerschießt es das ganze System bei Update auf 6.5.0
---
### Author:  [@concept24](https://forum.shopware.com/u/concept24)
#### Post date: [8. Mai 2023 um 12:01 UTC](https://forum.shopware.com/t/artikel-import-nach-update-6-5-0-nicht-moeglich/99591/3 "2023-05-08T12:01:28Z")
alle Plugin deaktiviert auch Themes, ansonsten lief das update gut nur eben kein Import von Artikeln möglich
---
### Author:  [@concept24](https://forum.shopware.com/u/concept24)
#### Post date: [8. Mai 2023 um 14:31 UTC](https://forum.shopware.com/t/artikel-import-nach-update-6-5-0-nicht-moeglich/99591/4 "2023-05-08T14:31:43Z")
hat keiner dieses Problem
---
### Author:  [@autostar-handel](https://forum.shopware.com/u/autostar-handel)
#### Post date: [12. Mai 2023 um 11:08 UTC](https://forum.shopware.com/t/artikel-import-nach-update-6-5-0-nicht-moeglich/99591/5 "2023-05-12T11:08:18Z")
bei mir waren alle erweiterungen und themes deaktiviert, trotzdem funktioniert update nicht.
Logdatei:
ab da stoppt es:
Run Post Update
Get collection for identifier: „core“
migrate Migrations
0/11 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░] 0% \< 1 sec/\< 1 sec 103.0 MiB06:58:40 ERROR [app] Migration: „Shopware\Core\Migration\V6\_5\Migration1673420896RemoveUndefinedSalutation“ failed: „An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP FOREIGN KEY `fk.customer_address.salutation_id`; check that it exists“
* * *
Action Number of migrations
* * *
Migrated 0 out of 11
* * *
06:58:40 CRITICAL [console] Error thrown while running command „system:update:finish --no-interaction“. Message: "
Migration error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP FOREIGN KEY `fk.customer_address.salutation_id`; check that it exists\n
Trace: \n
#0 /usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Connection.php(1935): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter-\>convert()\n
#1 /usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Connection.php(1878): Doctrine\DBAL\Connection-\>handleDriverException()\n
#2 /usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Connection.php(1206): Doctrine\DBAL\Connection-\>convertExceptionDuringQuery()\n
#3 /usr/www/users/swonline/shopware6/vendor/shopware/core/Migration/V6\_5/Migration1673420896RemoveUndefinedSalutation.php(38): Doctrine\DBAL\Connection-\>executeStatement()\n
#4 /usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/MigrationRuntime.php(38): Shopware\Core\Migration\V6\_5\Migration1673420896RemoveUndefinedSalutation-\>update()\n
#5 /usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(55): Shopware\Core\Framework\Migration\MigrationRuntime-\>migrate()\n
#6 /usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(157): Shopware\Core\Framework\Migration\Command\MigrationCommand-\>getMigrationGenerator()\n
#7 /usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(99): Shopware\Core\Framework\Migration\Command\MigrationCommand-\>runMigrationForIdentifier()\n
#8 /usr/www/users/swonline/shopware6/vendor/symfony/console/Command/Command.php(312): Shopware\Core\Framework\Migration\Command\MigrationCommand-\>execute()\n
#9 /usr/www/users/swonline/shopware6/vendor/symfony/console/Command/LazyCommand.php(76): Symfony\Component\Console\Command\Command-\>run()\n
#10 /usr/www/users/swonline/shopware6/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php(120): Symfony\Component\Console\Command\LazyCommand-\>run()\n
#11 /usr/www/users/swonline/shopware6/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php(85): Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand-\>runMigrations()\n
#12 /usr/www/users/swonline/shopware6/vendor/symfony/console/Command/Command.php(312): Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand-\>execute()\n
#13 /usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command-\>run()\n
#14 /usr/www/users/swonline/shopware6/vendor/symfony/framework-bundle/Console/Application.php(88): Symfony\Component\Console\Application-\>doRunCommand()\n
#15 /usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php(314): Symfony\Bundle\FrameworkBundle\Console\Application-\>doRunCommand()\n
#16 /usr/www/users/swonline/shopware6/vendor/symfony/framework-bundle/Console/Application.php(77): Symfony\Component\Console\Application-\>doRun()\n
#17 /usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php(168): Symfony\Bundle\FrameworkBundle\Console\Application-\>doRun()\n
#18 /usr/www/users/swonline/shopware6/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php(54): Symfony\Component\Console\Application-\>run()\n
#19 /usr/www/users/swonline/shopware6/vendor/autoload\_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\ConsoleApplicationRunner-\>run()\n
#20 /usr/www/users/swonline/shopware6/bin/console(15): require\_once(‚/usr/www/users/…‘)\n
#21 {main}
"
[
„exception“ =\> Shopware\Core\Framework\Migration\Exception\MigrateException {
#message: „“"
Migration error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP FOREIGN KEY `fk.customer_address.salutation_id`; check that it exists\n
Trace: \n
#0 /usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Connection.php(1935): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter-\>convert()\n
#1 /usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Connection.php(1878): Doctrine\DBAL\Connection-\>handleDriverException()\n
#2 /usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Connection.php(1206): Doctrine\DBAL\Connection-\>convertExceptionDuringQuery()\n
#3 /usr/www/users/swonline/shopware6/vendor/shopware/core/Migration/V6\_5/Migration1673420896RemoveUndefinedSalutation.php(38): Doctrine\DBAL\Connection-\>executeStatement()\n
#4 /usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/MigrationRuntime.php(38): Shopware\Core\Migration\V6\_5\Migration1673420896RemoveUndefinedSalutation-\>update()\n
#5 /usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(55): Shopware\Core\Framework\Migration\MigrationRuntime-\>migrate()\n
#6 /usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(157): Shopware\Core\Framework\Migration\Command\MigrationCommand-\>getMigrationGenerator()\n
#7 /usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(99): Shopware\Core\Framework\Migration\Command\MigrationCommand-\>runMigrationForIdentifier()\n
#8 /usr/www/users/swonline/shopware6/vendor/symfony/console/Command/Command.php(312): Shopware\Core\Framework\Migration\Command\MigrationCommand-\>execute()\n
#9 /usr/www/users/swonline/shopware6/vendor/symfony/console/Command/LazyCommand.php(76): Symfony\Component\Console\Command\Command-\>run()\n
#10 /usr/www/users/swonline/shopware6/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php(120): Symfony\Component\Console\Command\LazyCommand-\>run()\n
#11 /usr/www/users/swonline/shopware6/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php(85): Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand-\>runMigrations()\n
#12 /usr/www/users/swonline/shopware6/vendor/symfony/console/Command/Command.php(312): Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand-\>execute()\n
#13 /usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command-\>run()\n
#14 /usr/www/users/swonline/shopware6/vendor/symfony/framework-bundle/Console/Application.php(88): Symfony\Component\Console\Application-\>doRunCommand()\n
#15 /usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php(314): Symfony\Bundle\FrameworkBundle\Console\Application-\>doRunCommand()\n
#16 /usr/www/users/swonline/shopware6/vendor/symfony/framework-bundle/Console/Application.php(77): Symfony\Component\Console\Application-\>doRun()\n
#17 /usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php(168): Symfony\Bundle\FrameworkBundle\Console\Application-\>doRun()\n
#18 /usr/www/users/swonline/shopware6/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php(54): Symfony\Component\Console\Application-\>run()\n
#19 /usr/www/users/swonline/shopware6/vendor/autoload\_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\ConsoleApplicationRunner-\>run()\n
#20 /usr/www/users/swonline/shopware6/bin/console(15): require\_once(‚/usr/www/users/…‘)\n
#21 {main}
„“"
#code: 0
#file: „/usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php“
#line: 164
-previous: Doctrine\DBAL\Exception\DriverException {
#message: „An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP FOREIGN KEY `fk.customer_address.salutation_id`; check that it exists“
#code: 1091
#file: „/usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php“
#line: 117
-previous: Doctrine\DBAL\Driver\PDO\Exception {
#message: „SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP FOREIGN KEY `fk.customer_address.salutation_id`; check that it exists“
#code: 1091
#file: „/usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Driver/PDO/Exception.php“
#line: 28
-previous: PDOException {
#message: „SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP FOREIGN KEY `fk.customer_address.salutation_id`; check that it exists“
#code: „42000“
#file: „/usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Driver/PDO/Connection.php“
#line: 32
+errorInfo: [
„42000“,
1091,
„Can’t DROP FOREIGN KEY `fk.customer_address.salutation_id`; check that it exists“
]
trace: {
/usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:32 { …}
/usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:46 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:74 { …}
/usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Connection.php:1204 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Migration/V6\_5/Migration1673420896RemoveUndefinedSalutation.php:38 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/MigrationRuntime.php:38 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:55 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:157 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:99 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Command/Command.php:312 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Command/LazyCommand.php:76 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:120 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:85 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Command/Command.php:312 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php:1040 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/framework-bundle/Console/Application.php:88 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php:314 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/framework-bundle/Console/Application.php:77 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php:168 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php:54 { …}
/usr/www/users/swonline/shopware6/vendor/autoload\_runtime.php:29 { …}
/usr/www/users/swonline/shopware6/bin/console:15 {
›
› require\_once **DIR**. ‚/…/vendor/autoload\_runtime.php‘;
›
arguments: {
„/usr/www/users/swonline/shopware6/vendor/autoload\_runtime.php“
}
}
}
}
-sqlState: „42000“
trace: {
/usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28 { …}
/usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:38 { …}
/usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:46 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:74 { …}
/usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Connection.php:1204 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Migration/V6\_5/Migration1673420896RemoveUndefinedSalutation.php:38 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/MigrationRuntime.php:38 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:55 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:157 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:99 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Command/Command.php:312 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Command/LazyCommand.php:76 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:120 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:85 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Command/Command.php:312 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php:1040 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/framework-bundle/Console/Application.php:88 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php:314 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/framework-bundle/Console/Application.php:77 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php:168 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php:54 { …}
/usr/www/users/swonline/shopware6/vendor/autoload\_runtime.php:29 { …}
/usr/www/users/swonline/shopware6/bin/console:15 {
›
› require\_once **DIR**. ‚/…/vendor/autoload\_runtime.php‘;
›
arguments: {
„/usr/www/users/swonline/shopware6/vendor/autoload\_runtime.php“
}
}
}
}
-query: Doctrine\DBAL\Query {
-sql: „ALTER TABLE `customer_address` DROP FOREIGN KEY `fk.customer_address.salutation_id`“
-params:
-types:
}
trace: {
/usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117 { …}
/usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Connection.php:1935 { …}
/usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Connection.php:1878 { …}
/usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Connection.php:1206 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Migration/V6\_5/Migration1673420896RemoveUndefinedSalutation.php:38 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/MigrationRuntime.php:38 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:55 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:157 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:99 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Command/Command.php:312 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Command/LazyCommand.php:76 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:120 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:85 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Command/Command.php:312 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php:1040 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/framework-bundle/Console/Application.php:88 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php:314 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/framework-bundle/Console/Application.php:77 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php:168 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php:54 { …}
/usr/www/users/swonline/shopware6/vendor/autoload\_runtime.php:29 { …}
/usr/www/users/swonline/shopware6/bin/console:15 {
›
› require\_once **DIR**. ‚/…/vendor/autoload\_runtime.php‘;
›
arguments: {
„/usr/www/users/swonline/shopware6/vendor/autoload\_runtime.php“
}
}
}
}
-statusCode: 500
-headers:
#parameters: [
„errorMessage“ =\> „“"
An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP FOREIGN KEY `fk.customer_address.salutation_id`; check that it exists\n
Trace: \n
#0 /usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Connection.php(1935): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter-\>convert()\n
#1 /usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Connection.php(1878): Doctrine\DBAL\Connection-\>handleDriverException()\n
#2 /usr/www/users/swonline/shopware6/vendor/doctrine/dbal/src/Connection.php(1206): Doctrine\DBAL\Connection-\>convertExceptionDuringQuery()\n
#3 /usr/www/users/swonline/shopware6/vendor/shopware/core/Migration/V6\_5/Migration1673420896RemoveUndefinedSalutation.php(38): Doctrine\DBAL\Connection-\>executeStatement()\n
#4 /usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/MigrationRuntime.php(38): Shopware\Core\Migration\V6\_5\Migration1673420896RemoveUndefinedSalutation-\>update()\n
#5 /usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(55): Shopware\Core\Framework\Migration\MigrationRuntime-\>migrate()\n
#6 /usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(157): Shopware\Core\Framework\Migration\Command\MigrationCommand-\>getMigrationGenerator()\n
#7 /usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(99): Shopware\Core\Framework\Migration\Command\MigrationCommand-\>runMigrationForIdentifier()\n
#8 /usr/www/users/swonline/shopware6/vendor/symfony/console/Command/Command.php(312): Shopware\Core\Framework\Migration\Command\MigrationCommand-\>execute()\n
#9 /usr/www/users/swonline/shopware6/vendor/symfony/console/Command/LazyCommand.php(76): Symfony\Component\Console\Command\Command-\>run()\n
#10 /usr/www/users/swonline/shopware6/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php(120): Symfony\Component\Console\Command\LazyCommand-\>run()\n
#11 /usr/www/users/swonline/shopware6/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php(85): Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand-\>runMigrations()\n
#12 /usr/www/users/swonline/shopware6/vendor/symfony/console/Command/Command.php(312): Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand-\>execute()\n
#13 /usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command-\>run()\n
#14 /usr/www/users/swonline/shopware6/vendor/symfony/framework-bundle/Console/Application.php(88): Symfony\Component\Console\Application-\>doRunCommand()\n
#15 /usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php(314): Symfony\Bundle\FrameworkBundle\Console\Application-\>doRunCommand()\n
#16 /usr/www/users/swonline/shopware6/vendor/symfony/framework-bundle/Console/Application.php(77): Symfony\Component\Console\Application-\>doRun()\n
#17 /usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php(168): Symfony\Bundle\FrameworkBundle\Console\Application-\>doRun()\n
#18 /usr/www/users/swonline/shopware6/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php(54): Symfony\Component\Console\Application-\>run()\n
#19 /usr/www/users/swonline/shopware6/vendor/autoload\_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\ConsoleApplicationRunner-\>run()\n
#20 /usr/www/users/swonline/shopware6/bin/console(15): require\_once(‚/usr/www/users/…‘)\n
#21 {main}
„“"
]
trace: {
/usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:164 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:99 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Command/Command.php:312 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Command/LazyCommand.php:76 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:120 { …}
/usr/www/users/swonline/shopware6/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:85 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Command/Command.php:312 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php:1040 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/framework-bundle/Console/Application.php:88 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php:314 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/framework-bundle/Console/Application.php:77 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/console/Application.php:168 { …}
/usr/www/users/swonline/shopware6/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php:54 { …}
/usr/www/users/swonline/shopware6/vendor/autoload\_runtime.php:29 { …}
/usr/www/users/swonline/shopware6/bin/console:15 {
›
› require\_once **DIR**. ‚/…/vendor/autoload\_runtime.php‘;
›
arguments: {
„/usr/www/users/swonline/shopware6/vendor/autoload\_runtime.php“
}
}
}
},
„command“ =\> „system:update:finish --no-interaction“,
„message“ =\> „“"
Migration error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP FOREIGN KEY `fk.customer_address.salutation_id`; check that it exists\n
```
"""
```
]
06:58:40 DEBUG [console] Command „system:update:finish --no-interaction“ exited with code „1“
[
„command“ =\> „system:update:finish --no-interaction“,
„code“ =\> 1
]
In MigrationCommand.php line 164:
[Shopware\Core\Framework\Migration\Exception\MigrateException]
Migration error: An exception occurred while executing a query: SQLSTATE[42
000]: Syntax error or access violation: 1091 Can’t DROP FOREIGN KEY `fk.cus tomer_address.salutation_id`; check that it exists
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 FOREIGN KEY `fk.customer_address.sal utation_id`; check that it exists
In Exception.php line 28:
[Doctrine\DBAL\Driver\PDO\Exception (1091)]
SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP FOREIGN
KEY `fk.customer_address.salutation_id`; check that it exists
In Connection.php line 32:
[PDOException (42000)]
SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP FOREIGN
KEY `fk.customer_address.salutation_id`; check that it exists
---
### Author:  [@autostar-handel](https://forum.shopware.com/u/autostar-handel)
#### Post date: [12. Mai 2023 um 11:10 UTC](https://forum.shopware.com/t/artikel-import-nach-update-6-5-0-nicht-moeglich/99591/6 "2023-05-12T11:10:27Z")
kann ich das System eigentlich neu aufsetzen und dann die Daten von der 6er Version reinziehen oder ziehe ich dann automatisch wieder Fehler mit?
---
### Author:  [@RonnyBLN](https://forum.shopware.com/u/RonnyBLN)
#### Post date: [26. Mai 2023 um 17:03 UTC](https://forum.shopware.com/t/artikel-import-nach-update-6-5-0-nicht-moeglich/99591/7 "2023-05-26T17:03:38Z")
HABE GENAU DIE GLEICHE FEHLERMELDUNG DANACH IST DER SHOP DOWN
niemand weiß was man da ändern soll oder kann.
In MigrationCommand.php line 164:
[Shopware\Core\Framework\Migration\Exception\MigrateException]
Migration error: An exception occurred while executing a query: SQLSTATE[42
000]: Syntax error or access violation: 1091 Can’t DROP FOREIGN KEY `fk.cus tomer_address.salutation_id`; check that it exists
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 FOREIGN KEY `fk.customer_address.sal utation_id`; check that it exists
In Exception.php line 28:
[Doctrine\DBAL\Driver\PDO\Exception (1091)]
SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP FOREIGN
KEY `fk.customer_address.salutation_id`; check that it exists
In Connection.php line 32:
[PDOException (42000)]
SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP FOREIGN
KEY `fk.customer_address.salutation_id`; check that it exists