Hallo,
ich versuche gerde Shopware lokal zu installieren und bekomme folgende Fehlermeldung, währen die Datenbank installiert wird:
116/385 [========░░░░░░░░░░░░░░░░░░░░] 30%15:19:49 ERROR [app] Migration: „Shopware\Core\Migration\V6_3\Migration1563805586AddLanguageToOrder“ failed: "An exception occurred while executing ‚ALTER TABLE order MODIFY COLUMN language_id BINARY(16) NOT NULL‘:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚shop.o.price‘ in ‚CHECK‘"
Action Number of migrations
Migrated 130 out of 385
In MigrationCommand.php line 162:
Migration error: An exception occurred while executing ‚ALTER TABLE order MODIFY COLUMN language_id BINARY(16) NOT NULL‘:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚shop.o.price‘ in ‚CHECK‘
Trace:
#0 /var/www/project/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
#1 /var/www/project/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException()
#2 /var/www/project/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2121): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
#3 /var/www/project/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1463): Doctrine\DBAL\Connection->handleExceptionDuringQuery()
#4 /var/www/project/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1412): Doctrine\DBAL\Connection->executeStatement()
#5 /var/www/project/vendor/shopware/core/Migration/V6_3/Migration1563805586AddLanguageToOrder.php(30): Doctrine\DBAL\Connection->executeUpdate()
#6 /var/www/project/vendor/shopware/core/Framework/Migration/MigrationRuntime.php(47): Shopware\Core\Migration\V6_3\Migration1563805586AddLanguageToOrder->update()
#7 /var/www/project/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(53): Shopware\Core\Framework\Migration\MigrationRuntime->migrate()
#8 /var/www/project/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(155): Shopware\Core\Framework\Migration\Command\MigrationCommand->getMigrationGenerator()
#9 /var/www/project/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(97): Shopware\Core\Framework\Migration\Command\MigrationCommand->runMigrationForIdentifier()
#10 /var/www/project/vendor/symfony/console/Command/Command.php(256): Shopware\Core\Framework\Migration\Command\MigrationCommand->execute()
#11 /var/www/project/src/Command/SystemInstallCommand.php(196): Symfony\Component\Console\Command\Command->run()
#12 /var/www/project/src/Command/SystemInstallCommand.php(170): Shopware\Production\Command\SystemInstallCommand->runCommands()
#13 /var/www/project/vendor/symfony/console/Command/Command.php(256): Shopware\Production\Command\SystemInstallCommand->execute()
#14 /var/www/project/vendor/symfony/console/Application.php(989): Symfony\Component\Console\Command\Command->run()
#15 /var/www/project/vendor/symfony/framework-bundle/Console/Application.php(96): Symfony\Component\Console\Application->doRunCommand()
#16 /var/www/project/vendor/symfony/console/Application.php(290): Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand()
#17 /var/www/project/vendor/symfony/framework-bundle/Console/Application.php(82): Symfony\Component\Console\Application->doRun()
#18 /var/www/project/vendor/symfony/console/Application.php(166): Symfony\Bundle\FrameworkBundle\Console\Application->doRun()
#19 /var/www/project/bin/console(70): Symfony\Component\Console\Application->run()
#20 {main}
In AbstractMySQLDriver.php line 79:
An exception occurred while executing ‚ALTER TABLE order MODIFY COLUMN language_id BINARY(16) NOT NULL‘:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚shop.o.price‘ in ‚CHECK‘
In Exception.php line 18:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚shop.o.price‘ in ‚CHECK‘
In PDOConnection.php line 52:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚shop.o.price‘ in ‚CHECK‘
Der selbe Fehler kommt auch bei der Installation über den Browser.
Meine Umgebungen, wo ich es probiert habe:
a) Ubuntu 18.04, Apache 2.4, PHP7.4, MariaDB 10.5
b) Ubuntu 18.04, Nginx, PHP7.4, MariaDB 10.5
Jeweils in einer Vagrant box
Bin mit meinem Latein am Ende und für Tipps sehr dankbar.
Grüße