Upgrade von 5.3 auf 5.6.x - Migration schlägt fehl

**magic77** · Gestern, 17:27

Liebe Community,
nachdem ich ein Upgrade von 4.13.x nach 5.3 erfolgreich umsetzten konnte, schlägt ein Upgrade auf 5.6.x fehl bei der DB Migration
Das ganze läuft unter PHP 8.2, DB Konfiguration wird aus "config/parameters.yaml" geladen

root composer.json

Code:

{
    "type": "project",
    "require": {
        "contao/calendar-bundle": "^5.6",
        "contao/comments-bundle": "^5.6",
        "contao/conflicts": "@dev",
        "contao/faq-bundle": "^5.6",
        "contao/listing-bundle": "^5.6",
        "contao/manager-bundle": "5.6.*",
        "contao/news-bundle": "^5.6",
        "contao/newsletter-bundle": "^5.6",
        "alnv/catalog-manager-bundle": "^3.0",
        "codefog/contao-news_categories": "^4.0",
        "do-while/contao-backupdb-bundle": "^2.1",
        "madeyourday/contao-rocksolid-columns": "^2.0",
        "madeyourday/contao-rocksolid-custom-elements": "^2.4",
        "magic77/spreeprint-bundle": "dev-upgrade_to_5@dev",
        "terminal42/contao-fineuploader": "^3.5",
        "terminal42/contao-url-rewrite": "^1.8",
        "terminal42/notification_center": "^2.0"
    },
    "extra": {
        "public-dir": "web",
        "contao-component-dir": "assets"
    },
    "scripts": {
        "post-install-cmd": [
            "@php vendor/bin/contao-setup"
        ],
        "post-update-cmd": [
            "@php vendor/bin/contao-setup"
        ]
    },
    "config": {
        "github-oauth": {
            "github.com": "XYZ"
        },
        "allow-plugins": {
            "contao-components/installer": true,
            "contao/manager-plugin": true,
            "contao-community-alliance/composer-plugin": true,
            "php-http/discovery": true
        }
    },
    "repositories": {
        "magic77/spreeprint-bundle": {
            "type": "vcs",
            "url": "https://github.com/magic-77/contao-spreeprint-bundle"
        }
    }
}

Code:

16:11:10 CRITICAL  [console] Error thrown while running command "contao:migrate --no-interaction -vvv". Message: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'type' in 'where clause'"
[
  "exception" => Doctrine\DBAL\Exception\InvalidFieldNameException^ {
    #message: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'type' in 'where clause'"
    #code: 1054
    #file: "./vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
    #line: 69
    -previous: Doctrine\DBAL\Driver\PDO\Exception^ {
      #message: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'type' in 'where clause'"
      #code: 1054
      #file: "./vendor/doctrine/dbal/src/Driver/PDO/Exception.php"
      #line: 24
      -previous: PDOException {
        #message: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'type' in 'where clause'"
        #code: "42S22"
        #file: "./vendor/doctrine/dbal/src/Driver/PDO/Connection.php"
        #line: 71
        +errorInfo: [
          "42S22",
          1054,
          "Unknown column 'type' in 'where clause'"
        ]
        trace: {
          ./vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71 { …}
          ./vendor/doctrine/dbal/src/Connection.php:1106 { …}
          ./vendor/doctrine/dbal/src/Connection.php:627 { …}
          ./vendor/contao/core-bundle/src/Migration/Version506/LayoutTemplateMigration.php:35 { …}
          ./vendor/contao/core-bundle/src/Migration/MigrationCollection.php:41 { …}
          ./vendor/contao/core-bundle/src/Migration/MigrationCollection.php:52 { …}
          ./vendor/contao/core-bundle/src/Command/MigrateCommand.php:229 { …}
          ./vendor/contao/core-bundle/src/Command/MigrateCommand.php:192 { …}
          ./vendor/contao/core-bundle/src/Command/MigrateCommand.php:92 { …}
          ./vendor/symfony/console/Command/Command.php:318 { …}
          ./vendor/symfony/console/Application.php:1073 { …}
          ./vendor/symfony/framework-bundle/Console/Application.php:125 { …}
          ./vendor/symfony/console/Application.php:356 { …}
          ./vendor/symfony/framework-bundle/Console/Application.php:79 { …}
          ./vendor/symfony/console/Application.php:195 { …}
          ./vendor/contao/manager-bundle/bin/contao-console:40 { …}
          ./vendor/bin/contao-console:119 { …}
        }
      }
      -sqlState: "42S22"
      trace: {
        ./vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24 { …}
        ./vendor/doctrine/dbal/src/Driver/PDO/Connection.php:76 { …}
        ./vendor/doctrine/dbal/src/Connection.php:1106 { …}
        ./vendor/doctrine/dbal/src/Connection.php:627 { …}
        ./vendor/contao/core-bundle/src/Migration/Version506/LayoutTemplateMigration.php:35 { …}
        ./vendor/contao/core-bundle/src/Migration/MigrationCollection.php:41 { …}
        ./vendor/contao/core-bundle/src/Migration/MigrationCollection.php:52 { …}
        ./vendor/contao/core-bundle/src/Command/MigrateCommand.php:229 { …}
        ./vendor/contao/core-bundle/src/Command/MigrateCommand.php:192 { …}
        ./vendor/contao/core-bundle/src/Command/MigrateCommand.php:92 { …}
        ./vendor/symfony/console/Command/Command.php:318 { …}
        ./vendor/symfony/console/Application.php:1073 { …}
        ./vendor/symfony/framework-bundle/Console/Application.php:125 { …}
        ./vendor/symfony/console/Application.php:356 { …}
        ./vendor/symfony/framework-bundle/Console/Application.php:79 { …}
        ./vendor/symfony/console/Application.php:195 { …}
        ./vendor/contao/manager-bundle/bin/contao-console:40 { …}
        ./vendor/bin/contao-console:119 { …}
      }
    }
    -query: Doctrine\DBAL\Query^ {
      -sql: "SELECT TRUE FROM tl_layout WHERE type='modern' AND template='layout/default' LIMIT 1"
      -params: []
      -types: []
    }
    trace: {
      ./vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:69 { …}
      ./vendor/doctrine/dbal/src/Connection.php:1976 { …}
      ./vendor/doctrine/dbal/src/Connection.php:1918 { …}
      ./vendor/doctrine/dbal/src/Connection.php:1111 { …}
      ./vendor/doctrine/dbal/src/Connection.php:627 { …}
      ./vendor/contao/core-bundle/src/Migration/Version506/LayoutTemplateMigration.php:35 { …}
      ./vendor/contao/core-bundle/src/Migration/MigrationCollection.php:41 { …}
      ./vendor/contao/core-bundle/src/Migration/MigrationCollection.php:52 { …}
      ./vendor/contao/core-bundle/src/Command/MigrateCommand.php:229 { …}
      ./vendor/contao/core-bundle/src/Command/MigrateCommand.php:192 { …}
      ./vendor/contao/core-bundle/src/Command/MigrateCommand.php:92 { …}
      ./vendor/symfony/console/Command/Command.php:318 { …}
      ./vendor/symfony/console/Application.php:1073 { …}
      ./vendor/symfony/framework-bundle/Console/Application.php:125 { …}
      ./vendor/symfony/console/Application.php:356 { …}
      ./vendor/symfony/framework-bundle/Console/Application.php:79 { …}
      ./vendor/symfony/console/Application.php:195 { …}
      ./vendor/contao/manager-bundle/bin/contao-console:40 { …}
      ./vendor/bin/contao-console:119 { …}
    }
  },
  "command" => "contao:migrate --no-interaction -vvv",
  "message" => "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'type' in 'where clause'"
]
16:11:10 DEBUG     [console] Command "contao:migrate --no-interaction -vvv" exited with code "1054"
[
  "command" => "contao:migrate --no-interaction -vvv",
  "code" => 1054
]

Daraufhin habe ich die Tabelle entsprechend angepasst

Code:

ALTER TABLE tl_layout ADD COLUMN type varchar(16) NOT NULL DEFAULT 'modern';

dann wie in der Migration gegenprüfen

Code:

SELECT TRUE FROM tl_layout WHERE type='modern' AND template='layout/default' LIMIT 1

liefert :TRUE

Das ist die Migration die es betrifft "vendor/contao/core-bundle/src/Migration/Version506/LayoutTemplateMigration.php"

Code:

<?php

declare(strict_types=1);

/*
 * This file is part of Contao.
 *
 * (c) Leo Feyer
 *
 * @license LGPL-3.0-or-later
 */

namespace Contao\CoreBundle\Migration\Version506;

use Contao\CoreBundle\Migration\AbstractMigration;
use Contao\CoreBundle\Migration\MigrationResult;
use Contao\CoreBundle\Twig\ContaoTwigUtil;
use Contao\CoreBundle\Twig\Loader\ContaoFilesystemLoader;
use Doctrine\DBAL\Connection;
use Symfony\Component\Filesystem\Exception\IOException;
use Symfony\Component\Filesystem\Filesystem;
use Symfony\Component\Filesystem\Path;

class LayoutTemplateMigration extends AbstractMigration
{
    public function __construct(
        private readonly Connection $connection,
        private readonly ContaoFilesystemLoader $filesystemLoader,
        private readonly Filesystem $filesystem,
    ) {
    }

    public function shouldRun(): bool
    {
        $test = $this->connection->fetchOne("SELECT TRUE FROM tl_layout WHERE type='modern' AND template='layout/default' LIMIT 1");

        return false !== $test;
    }

    public function run(): MigrationResult
    {
        $this->connection->update(
            'tl_layout',
            [
                'template' => 'page/layout',
            ],
            [
                'type' => 'modern',
                'template' => 'layout/default',
            ],
        );

        $error = false;

        foreach ($this->getOldTemplatePaths() as $oldPath) {
            $newPath = Path::join(Path::getDirectory($oldPath), '../page/layout.html.twig');

            try {
                if (!$this->filesystem->exists($targetDirectory = Path::getDirectory($newPath))) {
                    $this->filesystem->mkdir($targetDirectory);
                }

                $this->filesystem->dumpFile(
                    $newPath,
                    $this->updateTemplateContent($this->filesystem->readFile($oldPath)),
                );

                $this->filesystem->remove($oldPath);
            } catch (IOException) {
                $error = true;
            }
        }

        return $this->createResult(!$error);
    }

    private function getOldTemplatePaths(): \Generator
    {
        foreach ($this->filesystemLoader->getInheritanceChains()['layout/default'] ?? [] as $path => $logicalName) {
            if (\in_array(ContaoTwigUtil::parseContaoName($logicalName)[0], ['Contao_App', 'Contao_Global'], true)) {
                yield $path;
            }
        }
    }

    private function updateTemplateContent(string $content): string
    {
        return str_replace(
            '@Contao/layout/default.html.twig',
            '@Contao/page/layout.html.twig',
            $content,
        );
    }
}

Migration nochmal laufenlassen - der Fehler bleibt - was übersehe ich hier?
Hat jemand ne Idee?

**Spooky** · Gestern, 17:32

https://github.com/contao/contao/issues/9047

**magic77** · Gestern, 17:37

Danke für den Hinweis.
Werde es erstmal auf 5.5 upgraden

**Spooky** · Gestern, 18:41

Du könntest auch auf 5.6.6 aktualisieren und dann die Änderungen von hier manuell einspielen, bevor du contao:migrate ausführst.

Thema: Upgrade von 5.3 auf 5.6.x - Migration schlägt fehl

Themen-Optionen

Thema durchsuchen

Upgrade von 5.3 auf 5.6.x - Migration schlägt fehl

Aktive Benutzer

Aktive Benutzer

Berechtigungen