# Update von 6.4 auf 5.5.8.7 funktioniert nicht

**URL:** <https://forum.shopware.com/t/update-von-6-4-auf-5-5-8-7-funktioniert-nicht/103312>\
**Category:** Shopware 6 (German)\
**Created:** [13. März 2024 um 15:32 UTC](https://forum.shopware.com/t/update-von-6-4-auf-5-5-8-7-funktioniert-nicht/103312 "2024-03-13T15:32:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![athena-soft](https://avatars.discourse-cdn.com/v4/letter/a/9e8a1a/32.png) [@athena-soft](https://forum.shopware.com/u/athena-soft)\
**Post date:** [13. März 2024 um 15:32 UTC](https://forum.shopware.com/t/update-von-6-4-auf-5-5-8-7-funktioniert-nicht/103312/1 "2024-03-13T15:32:15Z")

</div>

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.

```auto

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}
      """

```

---

<div class="post-metadata">

**Author:** ![area-net-gmbh](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/area-net-gmbh/32/21995_2.png) [@area-net-gmbh](https://forum.shopware.com/u/area-net-gmbh)\
**Post date:** [13. März 2024 um 15:51 UTC](https://forum.shopware.com/t/update-von-6-4-auf-5-5-8-7-funktioniert-nicht/103312/2 "2024-03-13T15:51:37Z")

</div>

> [@athena-soft](#):
>
> `Function or expression 'variant_listing_config' cannot be used in the CHECK clause`

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

---

<div class="post-metadata">

**Author:** ![athena-soft](https://avatars.discourse-cdn.com/v4/letter/a/9e8a1a/32.png) [@athena-soft](https://forum.shopware.com/u/athena-soft)\
**Post date:** [13. März 2024 um 15:57 UTC](https://forum.shopware.com/t/update-von-6-4-auf-5-5-8-7-funktioniert-nicht/103312/3 "2024-03-13T15:57:09Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Max\_Shop](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Max\_Shop](https://forum.shopware.com/u/Max_Shop)\
**Post date:** [13. März 2024 um 17:25 UTC](https://forum.shopware.com/t/update-von-6-4-auf-5-5-8-7-funktioniert-nicht/103312/4 "2024-03-13T17:25:23Z")

</div>

> [@Updatefehler 6.4.20 --\> 6.5.1: SQLSTATE\[HY000\]: General error: 1901](https://forum.shopware.com/t/updatefehler-6-4-20-6-5-1-sqlstate-hy000-general-error-1901/101197/7):
>
> 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…