Hallo liebes Forum,
vor kurzem wurde (nicht von mir!!) versucht eine Shopware-Installation v6.4.20.2 auf vermutlich v6.6.* zu updaten.
Natürlich kam es wie es kommen musste, das Update schlug fehl (mir wurde erzählt auf Grund einer inkompatiblem MariaDB-Version). Und von diesem speziellen Shop ist auch kein Backup vorhanden. Nun habe ich schon seit Tagen die Aufgabe den Shop wieder zum Laufen zu bekommen…
Schritte die bisher unternommen wurden
- Shop per FTP auf den dev-server, .env angepasst
- SQL per phpMyAdmin mit deaktivierter Fremdschlüsselüberprüfung importiert
- Alle aktiven Einträge der Tabelle „plugins“ auf 0 setzen
- http://localhost/recovery/update/index.php aufgerufen >>> Datenbankmigration läuft ein Stück durch, dann
1. Fehler:
1. Fehler
Error
Received the following error message:
Class "Symfony\Component\HttpKernel\Exception\HttpException" not found
Please try to fix this error and restart the update.
Response
{"valid":false,"errorMsg":"Class \"Symfony\\Component\\HttpKernel\\Exception\\HttpException\" not found"}
nach einem Refresh:
1. Fehler nach Refresh
Error
Received the following error message:
An exception occurred while executing ' ALTER TABLE `payment_method` DROP FOREIGN KEY `fk.payment_method.availability_rule_id`; ': SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP FOREIGN KEY `fk.payment_method.availability_rule_id`; check that it exists
Please try to fix this error and restart the update.
Response
{"valid":false,"errorMsg":"An exception occurred while executing '\n ALTER TABLE `payment_method`\n DROP FOREIGN KEY `fk.payment_method.availability_rule_id`;\n ':\n\nSQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP FOREIGN KEY `fk.payment_method.availability_rule_id`; check that it exists"}
gefixt mit:
1. Fehler fix
MariaDB [shopware6]> UPDATE `payment_method`
-> SET `availability_rule_id` = NULL
-> WHERE `availability_rule_id` NOT IN (SELECT `id` FROM `rule`);
Query OK, 1 row affected (0,039 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [shopware6]> ALTER TABLE `payment_method`
-> ADD CONSTRAINT `fk.payment_method.availability_rule_id`
-> FOREIGN KEY (`availability_rule_id`)
-> REFERENCES `rule` (`id`)
-> ON DELETE RESTRICT
-> ON UPDATE CASCADE;
Query OK, 6 rows affected (0,369 sec)
Records: 6 Duplicates: 0 Warnings: 0
danach läuft die Datenbankmigration weiter durch bis
2. Fehler
2. Fehler
## Error
Received the following error message:
Tables with multi column primary keys not supported. Maybe this migration did already run.
Please try to fix this error and restart the update.
### Response
{"valid":false,"errorMsg":"Tables with multi column primary keys not supported. Maybe this migration did already run."}
Hier bleibe ich bis jetzt immer hängen und schaffe es nicht mal in die Konsole:
Konsolenausgabe
xx@xxx:/var/www/html/xxxx$ sudo php bin/console about
PHP Deprecated: ini_set(): assert.warning INI setting is deprecated in /var/www/html/xxxx/vendor/symfony/error-handler/Debug.php on line 34
Symfony\Component\Config\Exception\LoaderLoadException^ {#346
#message: "There is no extension able to load the configuration for "swiftmailer" (in "/var/www/html/xxxx/vendor/shopware/core/Framework/Resources/config/packages/swiftmailer.yaml"). Looked for namespace "swiftmailer", found ""framework", "monolog", "sensio_framework_extra", "twig", "debug", "enqueue", "enqueue_adapter", "shopware", "storefront", "elasticsearch", "web_profiler"" in /var/www/html/xxxx/vendor/shopware/core/Framework/Resources/config/packages/swiftmailer.yaml (which is loaded in resource "/var/www/html/xxxx/vendor/shopware/core/Framework/Resources/config/packages/swiftmailer.yaml")."
#code: 0
#file: "/var/www/html/xxxx/vendor/symfony/config/Loader/FileLoader.php"
#line: 174
-previous: Symfony\Component\DependencyInjection\Exception\InvalidArgumentException^ {#354
#message: "There is no extension able to load the configuration for "swiftmailer" (in "/var/www/html/xxxx/vendor/shopware/core/Framework/Resources/config/packages/swiftmailer.yaml"). Looked for namespace "swiftmailer", found ""framework", "monolog", "sensio_framework_extra", "twig", "debug", "enqueue", "enqueue_adapter", "shopware", "storefront", "elasticsearch", "web_profiler""."
#code: 0
#file: "/var/www/html/xxxx/vendor/symfony/dependency-injection/Loader/YamlFileLoader.php"
#line: 799
trace: {
/var/www/html/xxxx/vendor/symfony/dependency-injection/Loader/YamlFileLoader.php:799 { …}
/var/www/html/xxxx/vendor/symfony/dependency-injection/Loader/YamlFileLoader.php:774 { …}
/var/www/html/xxxx/vendor/symfony/dependency-injection/Loader/YamlFileLoader.php:123 { …}
/var/www/html/xxxx/vendor/symfony/config/Loader/FileLoader.php:159 { …}
/var/www/html/xxxx/vendor/symfony/config/Loader/FileLoader.php:98 { …}
/var/www/html/xxxx/vendor/symfony/dependency-injection/Loader/FileLoader.php:66 { …}
/var/www/html/xxxx/vendor/symfony/dependency-injection/Loader/GlobFileLoader.php:27 { …}
/var/www/html/xxxx/vendor/symfony/config/Loader/Delasani@xxx-Server:/var/www/html/xxxx$ sudo php bin/console about
PHP Deprecated: ini_set(): assert.warning INI setting is deprecated in /var/www/html/xxxx/vendor/symfony/error-handler/Debug.php on line 34
Symfony\Component\Config\Exception\LoaderLoadException^ {#346
#message: "There is no extension able to load the configuration for "swiftmailer" (in "/var/www/html/xxxx/vendor/shopware/core/Framework/Resources/config/packages/swiftmailer.yaml"). Looked for namespace "swiftmailer", found ""framework", "monolog", "sensio_framework_extra", "twig", "debug", "enqueue", "enqueue_adapter", "shopware", "storefront", "elasticsearch", "web_profiler"" in /var/www/html/xxxx/vendor/shopware/core/Framework/Resources/config/packages/swiftmailer.yaml (which is loaded in resource "/var/www/html/xxxx/vendor/shopware/core/Framework/Resources/config/packages/swiftmailer.yaml")."
#code: 0
#file: "/var/www/html/xxxx/vendor/symfony/config/Loader/FileLoader.php"
#line: 174
-previous: Symfony\Component\DependencyInjection\Exception\InvalidArgumentException^ {#354
#message: "There is no extension able to load the configuration for "swiftmailer" (in "/var/www/html/xxxx/vendor/shopware/core/Framework/Resources/config/packages/swiftmailer.yaml"). Looked for namespace "swiftmailer", found ""framework", "monolog", "sensio_framework_extra", "twig", "debug", "enqueue", "enqueue_adapter", "shopware", "storefront", "elasticsearch", "web_profiler""."
#code: 0
#file: "/var/www/html/xxxx/vendor/symfony/dependency-injection/Loader/YamlFileLoader.php"
#line: 799
trace: {
/var/www/html/xxxx/vendor/symfony/dependency-injection/Loader/YamlFileLoader.php:799 { …}
/var/www/html/xxxx/vendor/symfony/dependency-injection/Loader/YamlFileLoader.php:774 { …}
/var/www/html/xxxx/vendor/symfony/dependency-injection/Loader/YamlFileLoader.php:123 { …}
/var/www/html/xxxx/vendor/symfony/config/Loader/FileLoader.php:159 { …}
/var/www/html/xxxx/vendor/symfony/config/Loader/FileLoader.php:98 { …}
/var/www/html/xxxx/vendor/symfony/dependency-injection/Loader/FileLoader.php:66 { …}
/var/www/html/xxxx/vendor/symfony/dependency-injection/Loader/GlobFileLoader.php:27 { …}
/var/www/html/xxxx/vendor/symfony/config/Loader/DelegatingLoader.php:40 { …}
/var/www/html/xxxx/vendor/shopware/core/Framework/Framework.php:187 { …}
/var/www/html/xxxx/vendor/shopware/core/Framework/Framework.php:68 { …}
/var/www/html/xxxx/vendor/symfony/http-kernel/Kernel.php:676 { …}
/var/www/html/xxxx/vendor/symfony/http-kernel/Kernel.php:647 { …}
/var/www/html/xxxx/vendor/symfony/http-kernel/Kernel.php:545 { …}
/var/www/html/xxxx/vendor/shopware/core/Kernel.php:190 { …}
/var/www/html/xxxx/bin/console:74 {
› $application = new Application($kernel->getKernel());
› $kernel->getKernel()->boot();
› $application->setName('Shopware');
}
}
}
trace: {
/var/www/html/xxxx/vendor/symfony/config/Loader/FileLoader.php:174 { …}
/var/www/html/xxxx/vendor/symfony/config/Loader/FileLoader.php:98 { …}
/var/www/html/xxxx/vendor/symfony/dependency-injection/Loader/FileLoader.php:66 { …}
/var/www/html/xxxx/vendor/symfony/dependency-injection/Loader/GlobFileLoader.php:27 { …}
/var/www/html/xxxx/vendor/symfony/config/Loader/DelegatingLoader.php:40 { …}
/var/www/html/xxxx/vendor/shopware/core/Framework/Framework.php:187 { …}
/var/www/html/xxxx/vendor/shopware/core/Framework/Framework.php:68 { …}
/var/www/html/xxxx/vendor/symfony/http-kernel/Kernel.php:676 { …}
/var/www/html/xxxx/vendor/symfony/http-kernel/Kernel.php:647 { …}
/var/www/html/xxxx/vendor/symfony/http-kernel/Kernel.php:545 { …}
/var/www/html/xxxx/vendor/shopware/core/Kernel.php:190 { …}
/var/www/html/xxxx/bin/console:74 {
› $application = new Application($kernel->getKernel());
› $kernel->getKernel()->boot();
› $application->setName('Shopware');
}
}
}
2024-07-08T13:22:33+00:00 [critical] Uncaught Exception: There is no extension able to load the configuration for "swiftmailer" (in "/var/www/html/xxxx/vendor/shopware/core/Framework/Resources/config/packages/swiftmailer.yaml"). Looked for namespace "swiftmailer", found ""framework", "monolog", "sensio_framework_extra", "twig", "debug", "enqueue", "enqueue_adapter", "shopware", "storefront", "elasticsearch", "web_profiler"" in /var/www/html/xxxx/vendor/shopware/core/Framework/Resources/config/packages/swiftmailer.yaml (which is loaded in resource "/var/www/html/xxxx/vendor/shopware/core/Framework/Resources/config/packages/swiftmailer.yaml").egatingLoader.php:40 { …}
/var/www/html/xxxx/vendor/shopware/core/Framework/Framework.php:187 { …}
/var/www/html/xxxx/vendor/shopware/core/Framework/Framework.php:68 { …}
/var/www/html/xxxx/vendor/symfony/http-kernel/Kernel.php:676 { …}
/var/www/html/xxxx/vendor/symfony/http-kernel/Kernel.php:647 { …}
/var/www/html/xxxx/vendor/symfony/http-kernel/Kernel.php:545 { …}
/var/www/html/xxxx/vendor/shopware/core/Kernel.php:190 { …}
/var/www/html/xxxx/bin/console:74 {
› $application = new Application($kernel->getKernel());
› $kernel->getKernel()->boot();
› $application->setName('Shopware');
}
}
}
trace: {
/var/www/html/xxxx/vendor/symfony/config/Loader/FileLoader.php:174 { …}
/var/www/html/xxxx/vendor/symfony/config/Loader/FileLoader.php:98 { …}
/var/www/html/xxxx/vendor/symfony/dependency-injection/Loader/FileLoader.php:66 { …}
/var/www/html/xxxx/vendor/symfony/dependency-injection/Loader/GlobFileLoader.php:27 { …}
/var/www/html/xxxx/vendor/symfony/config/Loader/DelegatingLoader.php:40 { …}
/var/www/html/xxxx/vendor/shopware/core/Framework/Framework.php:187 { …}
/var/www/html/xxxx/vendor/shopware/core/Framework/Framework.php:68 { …}
/var/www/html/xxxx/vendor/symfony/http-kernel/Kernel.php:676 { …}
/var/www/html/xxxx/vendor/symfony/http-kernel/Kernel.php:647 { …}
/var/www/html/xxxx/vendor/symfony/http-kernel/Kernel.php:545 { …}
/var/www/html/xxxx/vendor/shopware/core/Kernel.php:190 { …}
/var/www/html/xxxx/bin/console:74 {
› $application = new Application($kernel->getKernel());
› $kernel->getKernel()->boot();
› $application->setName('Shopware');
}
}
}
2024-07-08T13:22:33+00:00 [critical] Uncaught Exception: There is no extension able to load the configuration for "swiftmailer" (in "/var/www/html/xxxx/vendor/shopware/core/Framework/Resources/config/packages/swiftmailer.yaml"). Looked for namespace "swiftmailer", found ""framework", "monolog", "sensio_framework_extra", "twig", "debug", "enqueue", "enqueue_adapter", "shopware", "storefront", "elasticsearch", "web_profiler"" in /var/www/html/xxxx/vendor/shopware/core/Framework/Resources/config/packages/swiftmailer.yaml (which is loaded in resource "/var/www/html/xxxx/vendor/shopware/core/Framework/Resources/config/packages/swiftmailer.yaml").
Weitere Schritte die versucht wurden:
- Ordner „vendor“ löschen oder umbenennen
composer install- danach wieder derselbe Fehler, nur in der Konsole
Konsolenausgabe
In MigrationCommand.php line 167:
[Shopware\Core\Framework\Migration\Exception\MigrateException]
Migration error: Tables with multi column primary keys not supported. Maybe this migration did already run.
Trace:
#0 /var/www/html/xxxx/vendor/shopware/core/Framework/Migration/MakeVersionableMigrationHelper.php(57): Shopware\Core\Framework\Migration\MakeVersionableMigrationHelper->crea
teModifyPrimaryKeyQuery()
#1 /var/www/html/xxxx/vendor/shopware/core/Migration/V6_4/Migration1612851765MakeCmsVersionable.php(34): Shopware\Core\Framework\Migration\MakeVersionableMigrationHelper->cr
eateSql()
#2 /var/www/html/xxxx/vendor/shopware/core/Framework/Migration/MigrationRuntime.php(46): Shopware\Core\Migration\V6_4\Migration1612851765MakeCmsVersionable->update()
#3 /var/www/html/xxxx/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(58): Shopware\Core\Framework\Migration\MigrationRuntime->migrate()
#4 /var/www/html/xxxx/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(160): Shopware\Core\Framework\Migration\Command\MigrationCommand->getMigrationGen
erator()
#5 /var/www/html/xxxx/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(102): Shopware\Core\Framework\Migration\Command\MigrationCommand->runMigrationFor
Identifier()
#6 /var/www/html/xxxx/vendor/symfony/console/Command/Command.php(298): Shopware\Core\Framework\Migration\Command\MigrationCommand->execute()
#7 /var/www/html/xxxx/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php(120): Symfony\Component\Console\Command\Command->run()
#8 /var/www/html/xxxx/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php(85): Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand->
runMigrations()
#9 /var/www/html/xxxx/vendor/symfony/console/Command/Command.php(298): Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand->execute()
#10 /var/www/html/xxxx/vendor/symfony/console/Application.php(1058): Symfony\Component\Console\Command\Command->run()
#11 /var/www/html/xxxx/vendor/symfony/framework-bundle/Console/Application.php(96): Symfony\Component\Console\Application->doRunCommand()
#12 /var/www/html/xxxx/vendor/symfony/console/Application.php(301): Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand()
#13 /var/www/html/xxxx/vendor/symfony/framework-bundle/Console/Application.php(82): Symfony\Component\Console\Application->doRun()
#14 /var/www/html/xxxx/vendor/symfony/console/Application.php(171): Symfony\Bundle\FrameworkBundle\Console\Application->doRun()
#15 /var/www/html/xxxx/bin/console(77): Symfony\Component\Console\Application->run()
#16 {main}
Exception trace:
at /var/www/html/xxxx/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:167
Shopware\Core\Framework\Migration\Command\MigrationCommand->runMigrationForIdentifier() at /var/www/html/xxxx/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:102
Shopware\Core\Framework\Migration\Command\MigrationCommand->execute() at /var/www/html/xxxx/vendor/symfony/console/Command/Command.php:298
Symfony\Component\Console\Command\Command->run() at /var/www/html/xxxx/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:120
Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand->runMigrations() at /var/www/html/xxxx/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:85
Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand->execute() at /var/www/html/xxxx/vendor/symfony/console/Command/Command.php:298
Symfony\Component\Console\Command\Command->run() at /var/www/html/xxxx/vendor/symfony/console/Application.php:1058
Symfony\Component\Console\Application->doRunCommand() at /var/www/html/xxxx/vendor/symfony/framework-bundle/Console/Application.php:96
Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand() at /var/www/html/xxxx/vendor/symfony/console/Application.php:301
Symfony\Component\Console\Application->doRun() at /var/www/html/xxxx/vendor/symfony/framework-bundle/Console/Application.php:82
Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /var/www/html/xxxx/vendor/symfony/console/Application.php:171
Symfony\Component\Console\Application->run() at /var/www/html/xxxx/bin/console:77
In MakeVersionableMigrationHelper.php line 195:
[RuntimeException]
Tables with multi column primary keys not supported. Maybe this migration did already run.
Exception trace:
at /var/www/html/xxxx/vendor/shopware/core/Framework/Migration/MakeVersionableMigrationHelper.php:195
Shopware\Core\Framework\Migration\MakeVersionableMigrationHelper->createModifyPrimaryKeyQuery() at /var/www/html/xxxx/vendor/shopware/core/Framework/Migration/MakeVersionableMigrationHelper.php:57
Shopware\Core\Framework\Migration\MakeVersionableMigrationHelper->createSql() at /var/www/html/xxxx/vendor/shopware/core/Migration/V6_4/Migration1612851765MakeCmsVersionable.php:34
Shopware\Core\Migration\V6_4\Migration1612851765MakeCmsVersionable->update() at /var/www/html/xxxx/vendor/shopware/core/Framework/Migration/MigrationRuntime.php:46
Shopware\Core\Framework\Migration\MigrationRuntime->migrate() at /var/www/html/xxxx/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:58
Shopware\Core\Framework\Migration\Command\MigrationCommand->getMigrationGenerator() at /var/www/html/xxxx/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:160
Shopware\Core\Framework\Migration\Command\MigrationCommand->runMigrationForIdentifier() at /var/www/html/xxxx/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php:102
Shopware\Core\Framework\Migration\Command\MigrationCommand->execute() at /var/www/html/xxxx/vendor/symfony/console/Command/Command.php:298
Symfony\Component\Console\Command\Command->run() at /var/www/html/xxxx/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:120
Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand->runMigrations() at /var/www/html/xxxx/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php:85
Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand->execute() at /var/www/html/xxxx/vendor/symfony/console/Command/Command.php:298
Symfony\Component\Console\Command\Command->run() at /var/www/html/xxxx/vendor/symfony/console/Application.php:1058
Symfony\Component\Console\Application->doRunCommand() at /var/www/html/xxxx/vendor/symfony/framework-bundle/Console/Application.php:96
Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand() at /var/www/html/xxxx/vendor/symfony/console/Application.php:301
Symfony\Component\Console\Application->doRun() at /var/www/html/xxxx/vendor/symfony/framework-bundle/Console/Application.php:82
Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /var/www/html/xxxx/vendor/symfony/console/Application.php:171
Symfony\Component\Console\Application->run() at /var/www/html/xxxx/bin/console:77
system:update:finish [--skip-asset-build]
Script [ ! -f vendor/autoload.php ] || $PHP_BINARY bin/console system:update:finish handling the post-install-cmd event returned with error code 1
aber bin/console about gibt jetzt
Zusammenfassung
xx@xxx:/var/www/html/xxxx$ sudo php bin/console about
[sudo] Passwort für xxxx:
-------------------- -------------------------------------------------------------
Symfony
-------------------- -------------------------------------------------------------
Version 5.4.41
Long-Term Support Yes
End of maintenance 11/2024 (in +145 days)
End of life 11/2025 (in +510 days)
-------------------- -------------------------------------------------------------
Kernel
-------------------- -------------------------------------------------------------
Type Shopware\Core\Kernel
Environment dev
Debug true
Charset UTF-8
Cache directory ./var/cache/dev_h1da1e8f2d7447d9e6e5aaf4a9c566ea4 (9.0 MiB)
Build directory ./var/cache/dev_h1da1e8f2d7447d9e6e5aaf4a9c566ea4 (9.0 MiB)
Log directory ./var/log (28 KiB)
-------------------- -------------------------------------------------------------
PHP
-------------------- -------------------------------------------------------------
Version 8.3.8
Architecture 64 bits
Intl locale de_DE
Timezone UTC (2024-07-08T13:50:11+00:00)
OPcache true
APCu false
Xdebug false
-------------------- -------------------------------------------------------------
und bin/console dal:validate
Konsolenausgabe
xx@xxx:/var/www/html/xxxx$ sudo php bin/console dal:validate
...gekürzt wegen Zeichenlimit...
[ERROR] Found 268 errors in 62 entities
Hat irgendjemand eine Idee was ich noch versuchen kann?