# 500er Fehler bei der Installation der Datenbank

**URL:** <https://forum.shopware.com/t/500er-fehler-bei-der-installation-der-datenbank/87653>\
**Category:** Installation / Einstieg\
**Created:** [13. Mai 2021 um 17:26 UTC](https://forum.shopware.com/t/500er-fehler-bei-der-installation-der-datenbank/87653 "2021-05-13T17:26:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![FlorianG](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/floriang/32/13769_2.png) [@FlorianG](https://forum.shopware.com/u/FlorianG)\
**Post date:** [13. Mai 2021 um 17:26 UTC](https://forum.shopware.com/t/500er-fehler-bei-der-installation-der-datenbank/87653/1 "2021-05-13T17:26:41Z")

</div>

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.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/2X/b/b040e20abdabe24e79eea433db90de99123978cf.png)

Grüße

---

<div class="post-metadata">

**Author:** ![archery-analytics](https://avatars.discourse-cdn.com/v4/letter/a/f04885/32.png) [@archery-analytics](https://forum.shopware.com/u/archery-analytics)\
**Post date:** [13. Mai 2021 um 20:50 UTC](https://forum.shopware.com/t/500er-fehler-bei-der-installation-der-datenbank/87653/2 "2021-05-13T20:50:05Z")

</div>

Hallo Florian,  
Du bist nicht allein, das wird gerade in mehreren Posts diskutiert:  
[Shopware 6.4.0.0 Update Fehler](https://forum.shopware.com/t/shopware-6-4-0-0-update-fehler/87386)  
[Fehler beim Import Datenbank](https://forum.shopware.com/t/fehler-beim-import-datenbank/87596)  
und weitere (einfach mal nach `AddLanguageToOrder` suchen).  
Es scheint mit der MariaDB zusammenzuhängen und bei allen Versionen \>6.3 zu Problemen zu kommen.