Installation schlägt fehl (Datenbank)

Hallo zusammen,

wenn die Installation ausgeführt wird, legt der Installer zwar brav die Datenbank an, danach kommt jedoch sofort der untenstehende Fehler. Hat das schonmal jemand gesehen und beheben können?

Aufgerufen wurde der Installer via Subdirectory ‚/sw6/public/‘

PHP-FPM v7.2.19
MariaDB 10.1.41

Error Logs sind leer.


Error
Received an error message.
URL: importDatabase
Message: Internal Server Error

Please try to fix this error and restart the update.
Response
Slim Application Error
The application could not run because of the following error:

Details
Type: Doctrine\DBAL\DBALException
Message: An exception occurred while executing 'INSERT IGNORE INTO migration (`class`, `creation_timestamp`) VALUES [... gekuerzt wegen Forumlimit ...]

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sw6.migration' doesn't exist
File: /srv/www/default/sw6/public/recovery/common/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php
Line: 172
Trace
#0 /srv/www/default/sw6/public/recovery/common/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(145): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'An exception oc...')
#1 /srv/www/default/sw6/public/recovery/common/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1063): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'INSERT IGNORE I...', Array)
#2 /srv/www/default/sw6/vendor/shopware/core/Framework/Doctrine/MultiInsertQueryQueue.php(79): Doctrine\DBAL\Connection->executeUpdate('INSERT IGNORE I...')
#3 /srv/www/default/sw6/vendor/shopware/core/Framework/Migration/MigrationCollectionLoader.php(61): Shopware\Core\Framework\Doctrine\MultiInsertQueryQueue->execute()
#4 /srv/www/default/sw6/vendor/shopware/core/Framework/Migration/MigrationCollectionLoader.php(36): Shopware\Core\Framework\Migration\MigrationCollectionLoader->addMigrationsToTable(Array, 'Shopware\\Core\\M...')
#5 /srv/www/default/sw6/public/recovery/install/src/app.php(536): Shopware\Core\Framework\Migration\MigrationCollectionLoader->syncMigrationCollection('Shopware\\Core\\M...')
#6 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#7 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(41): call_user_func(Object(Closure), Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#8 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/Route.php(356): Slim\Handlers\Strategies\RequestResponse->__invoke(Object(Closure), Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#9 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))
#10 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/Route.php(334): Slim\Route->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response))
#11 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/App.php(515): Slim\Route->run(Object(Slim\Http\Request), Object(Slim\Http\Response))
#12 /srv/www/default/sw6/public/recovery/install/src/app.php(153): Slim\App->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))
#13 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#14 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/DeferredCallable.php(43): call_user_func_array(Object(Closure), Array)
#15 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#16 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#17 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#18 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/App.php(405): Slim\App->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response))
#19 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/App.php(313): Slim\App->process(Object(Slim\Http\Request), Object(Slim\Http\Response))
#20 /srv/www/default/sw6/public/recovery/install/index.php(51): Slim\App->run()
#21 {main}
Previous exception
Type: PDOException
Code: 42S02
Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sw6.migration' doesn't exist
File: /srv/www/default/sw6/public/recovery/common/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php
Line: 1060
Trace
#0 /srv/www/default/sw6/public/recovery/common/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1060): PDO->exec('INSERT IGNORE I...')
#1 /srv/www/default/sw6/vendor/shopware/core/Framework/Doctrine/MultiInsertQueryQueue.php(79): Doctrine\DBAL\Connection->executeUpdate('INSERT IGNORE I...')
#2 /srv/www/default/sw6/vendor/shopware/core/Framework/Migration/MigrationCollectionLoader.php(61): Shopware\Core\Framework\Doctrine\MultiInsertQueryQueue->execute()
#3 /srv/www/default/sw6/vendor/shopware/core/Framework/Migration/MigrationCollectionLoader.php(36): Shopware\Core\Framework\Migration\MigrationCollectionLoader->addMigrationsToTable(Array, 'Shopware\\Core\\M...')
#4 /srv/www/default/sw6/public/recovery/install/src/app.php(536): Shopware\Core\Framework\Migration\MigrationCollectionLoader->syncMigrationCollection('Shopware\\Core\\M...')
#5 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#6 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(41): call_user_func(Object(Closure), Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#7 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/Route.php(356): Slim\Handlers\Strategies\RequestResponse->__invoke(Object(Closure), Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#8 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))
#9 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/Route.php(334): Slim\Route->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response))
#10 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/App.php(515): Slim\Route->run(Object(Slim\Http\Request), Object(Slim\Http\Response))
#11 /srv/www/default/sw6/public/recovery/install/src/app.php(153): Slim\App->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))
#12 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#13 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/DeferredCallable.php(43): call_user_func_array(Object(Closure), Array)
#14 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#15 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#16 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#17 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/App.php(405): Slim\App->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response))
#18 /srv/www/default/sw6/public/recovery/common/vendor/slim/slim/Slim/App.php(313): Slim\App->process(Object(Slim\Http\Request), Object(Slim\Http\Response))
#19 /srv/www/default/sw6/public/recovery/install/index.php(51): Slim\App->run()
#20 {main}

 

  

Du brauchst mindestens MariaDB 10.3 - deine wäre also zu alt.

In der nächsten Version des Installers werden wir die DB-Version auch noch abfragen

1 Like

Ah… MariaDB 10.3 wird benötigt… vollkommen übersehen…

Danke für die Info, jetzt habe ich eine andere Frage bin bei all-inkl. Da meine Zugriffe sich noch sehr bescheiden, sind ca. 10 am Tag. Gibt es eine möglichkeit diese Datenbank selber zu installieren oder brauche ich da die Einwilligung von meinem behoster?

Da wird Dir Dieser nicht helfen wollen, schreib ihn doch mal an.

Abgesehen davon wirst Du mit dem sowieso nicht glücklich werden, egal wieviele Zugriffe der Shop jemals produktiv haben wird.

Um die Datenbank von z.B. 10.1.x auf 10.3.x hochzubringen brauchts Du Root-Zugriff auf den Server und das nötige Wissen dazu.

okay dankte trotzdem, muss mir das überlegen.