Update von 6.4 auf 5.5.8.7 funktioniert nicht

[athena-soft]

Hallo zusammen,

ich bin neue hier und erstelle gerade meinen ersten Shop mit Shopware. Ich wollte ein Update machen, leider bekomme ich ein Fehler mit der unten genannten Logfile.

Nicht kompatible Plugins habe ich deaktiviert, und die Anforderungen wurden auch erfüllt. Ich habe auch nach dem Error in der Logfile gesucht, aber nichts darüber gefunden, ich hoffe Ihr könnt helfen.

Ich hätte gern die Gesamte Logfile hochgeladen aber mehr Text ist als neuer Benutzer nicht möglich, soweit ich das sehe haben aber alle mit diesem „variant_listing_config“ zu tun.

Run Post Update

Get collection for identifier: "core"
migrate Migrations
  0/52 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   0% < 1 sec/< 1 sec 34.0 MiB15:23:17 ERROR     [app] Migration: "Shopware\Core\Migration\V6_5\Migration1675082889DropUnusedTables" failed: "An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1901 Function or expression 'variant_listing_config' cannot be used in the CHECK clause of `variant_listing_config`"
 ---------- ---------------------- 
  Action     Number of migrations  
 ---------- ---------------------- 
  Migrated   0 out of 52           
 ---------- ---------------------- 

15:23:17 CRITICAL  [console] Error thrown while running command "database:migrate core --all=1". Message: "
Migration error: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1901 Function or expression 'variant_listing_config' cannot be used in the CHECK clause of `variant_listing_config`\n
Trace: \n
#0 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/doctrine/dbal/src/Connection.php(1943): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query))\n
#1 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/doctrine/dbal/src/Connection.php(1885): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query))\n
#2 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/doctrine/dbal/src/Connection.php(1213): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'ALTER TABLE `pr...', Array, Array)\n
#3 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/shopware/core/Migration/V6_5/Migration1675082889DropUnusedTables.php(36): Doctrine\DBAL\Connection->executeStatement('ALTER TABLE `pr...')\n
#4 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/shopware/core/Framework/Migration/MigrationRuntime.php(40): Shopware\Core\Migration\V6_5\Migration1675082889DropUnusedTables->update(Object(Doctrine\DBAL\Connection))\n
#5 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(58): Shopware\Core\Framework\Migration\MigrationRuntime->migrate(Object(Shopware\Core\Framework\Migration\MigrationSource), NULL, 0)\n
#6 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(160): Shopware\Core\Framework\Migration\Command\MigrationCommand->getMigrationGenerator(Object(Shopware\Core\Framework\Migration\MigrationCollection), NULL, 0)\n
#7 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(102): Shopware\Core\Framework\Migration\Command\MigrationCommand->runMigrationForIdentifier(Object(Symfony\Component\Console\Input\ArrayInput), 'core', 0, NULL)\n
#8 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/console/Command/Command.php(326): Shopware\Core\Framework\Migration\Command\MigrationCommand->execute(Object(Symfony\Component\Console\Input\ArrayInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
#9 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/console/Application.php(1096): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
#10 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/framework-bundle/Console/Application.php(126): Symfony\Component\Console\Application->doRunCommand(Object(Shopware\Core\Framework\Migration\Command\MigrationCommand), Object(Symfony\Component\Console\Input\ArrayInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
#11 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/console/Application.php(324): Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand(Object(Shopware\Core\Framework\Migration\Command\MigrationCommand), Object(Symfony\Component\Console\Input\ArrayInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
#12 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/framework-bundle/Console/Application.php(80): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArrayInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
#13 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php(129): Symfony\Bundle\FrameworkBundle\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArrayInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
#14 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php(107): Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand->runCommand(Object(Symfony\Bundle\FrameworkBundle\Console\Application), Object(Symfony\Component\Console\Command\LazyCommand), Array, Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
#15 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php(84): Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand->runMigrations(Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
#16 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/console/Command/Command.php(326): Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
#17 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/console/Application.php(1096): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n
#18 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/framework-bundle/Console/Application.php(126): Symfony\Component\Console\Application->doRunCommand(Object(Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n
#19 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/console/Application.php(324): Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand(Object(Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n
#20 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/framework-bundle/Console/Application.php(80): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n
#21 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/console/Application.php(175): Symfony\Bundle\FrameworkBundle\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n
#22 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php(49): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n
#23 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\ConsoleApplicationRunner->run()\n
#24 /www/htdocs/w01d9324/swissoil.athena-soft.de/bin/console(15): require_once('/www/htdocs/w01...')\n
#25 {main}
"
[
  "exception" => Shopware\Core\Framework\Migration\Exception\MigrateException {
    #message: """
      Migration error: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1901 Function or expression 'variant_listing_config' cannot be used in the CHECK clause of `variant_listing_config`\n
      Trace: \n
      #0 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/doctrine/dbal/src/Connection.php(1943): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query))\n
      #1 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/doctrine/dbal/src/Connection.php(1885): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query))\n
      #2 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/doctrine/dbal/src/Connection.php(1213): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'ALTER TABLE `pr...', Array, Array)\n
      #3 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/shopware/core/Migration/V6_5/Migration1675082889DropUnusedTables.php(36): Doctrine\DBAL\Connection->executeStatement('ALTER TABLE `pr...')\n
      #4 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/shopware/core/Framework/Migration/MigrationRuntime.php(40): Shopware\Core\Migration\V6_5\Migration1675082889DropUnusedTables->update(Object(Doctrine\DBAL\Connection))\n
      #5 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(58): Shopware\Core\Framework\Migration\MigrationRuntime->migrate(Object(Shopware\Core\Framework\Migration\MigrationSource), NULL, 0)\n
      #6 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(160): Shopware\Core\Framework\Migration\Command\MigrationCommand->getMigrationGenerator(Object(Shopware\Core\Framework\Migration\MigrationCollection), NULL, 0)\n
      #7 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(102): Shopware\Core\Framework\Migration\Command\MigrationCommand->runMigrationForIdentifier(Object(Symfony\Component\Console\Input\ArrayInput), 'core', 0, NULL)\n
      #8 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/console/Command/Command.php(326): Shopware\Core\Framework\Migration\Command\MigrationCommand->execute(Object(Symfony\Component\Console\Input\ArrayInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
      #9 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/console/Application.php(1096): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
      #10 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/framework-bundle/Console/Application.php(126): Symfony\Component\Console\Application->doRunCommand(Object(Shopware\Core\Framework\Migration\Command\MigrationCommand), Object(Symfony\Component\Console\Input\ArrayInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
      #11 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/console/Application.php(324): Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand(Object(Shopware\Core\Framework\Migration\Command\MigrationCommand), Object(Symfony\Component\Console\Input\ArrayInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
      #12 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/framework-bundle/Console/Application.php(80): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArrayInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
      #13 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php(129): Symfony\Bundle\FrameworkBundle\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArrayInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
      #14 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php(107): Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand->runCommand(Object(Symfony\Bundle\FrameworkBundle\Console\Application), Object(Symfony\Component\Console\Command\LazyCommand), Array, Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
      #15 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/shopware/core/Maintenance/System/Command/SystemUpdateFinishCommand.php(84): Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand->runMigrations(Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
      #16 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/console/Command/Command.php(326): Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n
      #17 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/console/Application.php(1096): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n
      #18 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/framework-bundle/Console/Application.php(126): Symfony\Component\Console\Application->doRunCommand(Object(Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n
      #19 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/console/Application.php(324): Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand(Object(Shopware\Core\Maintenance\System\Command\SystemUpdateFinishCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n
      #20 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/framework-bundle/Console/Application.php(80): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n
      #21 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/console/Application.php(175): Symfony\Bundle\FrameworkBundle\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n
      #22 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php(49): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n
      #23 /www/htdocs/w01d9324/swissoil.athena-soft.de/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\ConsoleApplicationRunner->run()\n
      #24 /www/htdocs/w01d9324/swissoil.athena-soft.de/bin/console(15): require_once('/www/htdocs/w01...')\n
      #25 {main}
      """

[area-net-gmbh]

@athena-soft

Function or expression 'variant_listing_config' cannot be used in the CHECK clause

Welche DB? MySQL oder MariaDB - und welche Version genau?

[athena-soft]

Danke für die schnelle Antwort. Mariadb 10.6.16

Bin bei all-inkl und wollte schon die neuste Version haben, sie meinen aber das wäre die aktuellste, zumindest bei denen. Zur Info eine Neuinstallation von Shopware funktioniert, auch diese Updatetn geht.

Edit:Natürlich beginnt die Neuinstallation bei 6.5
Soweit ich gerade lese macht das Update von 6.4 auf 6.5 mit Mariadb Probleme, schlau bin ich daraus noch nicht geworden.

[Max_Shop]

Updatefehler 6.4.20 --> 6.5.1: SQLSTATE[HY000]: General error: 1901

Version 6.4.14.0 auf 6.4.20 Guten Morgen zusammen - wir haben jetzt MariaDB 10.11.7 im Einsatz und der Shop läuft immer noch auf diese Fehlermeldung: Received the following error message: An exception occurred while executing ‚ALTER TABLE product ADD COLUMN variant_listing_config JSON GENERATED ALWAYS AS (CASE WHEN display_parent IS NOT NULL OR main_variant_id IS NOT NULL OR configurator_group_config IS NOT NULL THEN (JSON_OBJECT( ‚displayParent‘, display_parent, ‚mainVariantId‘, LOWER(HEX(ma…