con4gis/maps: Base table or view not found: 1146 Table 'd0403618.tl_image

con4gis/maps: Base table or view not found: 1146 Table 'd0403618.tl_image_size' doesn

Zitat:

Zitat von Spooky

In der Contao Installation folgendes Kommando durchführen:

Code:

php vendor/bin/contao-console contao:migrate --no-interaction

Danach die Konsolenausgabe davon posten.

php musst du ggf. mit dem Pfad oder dem Alias zum richtigen PHP CLI ersetzen.

Ich habe ein ähnliches Problem.

Contao Manager 1.8.4
PHP 8.2
Contao 5.3.7
Server: Mit All Inkl, Lokal mit Mamp Pro und auf einem anderen Server getestet, überall das Gleiche

Die Datenbank wird nicht erstellt. Im Manager dreht "Datenbank-Änderungen" ewig vor sich hin.
Verbinde ich mich bei All Inkl per SSH und führe zB "/usr/bin/php82 vendor/bin/contao-console contao:migrate --no-interaction" aus, kommt:

An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd0403618.tl_image_size' doesn't exist.
Die Datenbank ist ja auch noch leer!?

Hänge -v an und poste die Ausgabe inkl Aufruf.

Code:

try 15:23:50 CRITICAL [console] Error thrown while running command "contao:migrate --no-interaction -v". Message: "An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd0403618.tl_image_size' doesn't exist" ["exception" => Doctrine\DBAL\Exception\TableNotFoundException^ { …},"command" => "contao:migrate --no-interaction -v","message" => "An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd0403618.tl_image_size' doesn't exist"] In ExceptionConverter.php line 49: [Doctrine\DBAL\Exception\TableNotFoundException (1146)] An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd0403618.tl_image_size' doesn't exist Exception trace: at /www/htdocs/w00XXXXX/demo/kunde/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:49 Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() at /www/htdocs/w00XXXXX/demo/kunde/vendor/doctrine/dbal/src/Connection.php:1943 Doctrine\DBAL\Connection->handleDriverException() at /www/htdocs/w00XXXXX/demo/kunde/vendor/doctrine/dbal/src/Connection.php:1885 Doctrine\DBAL\Connection->convertExceptionDuringQuery() at /www/htdocs/w00XXXXX/demo/kunde/vendor/doctrine/dbal/src/Connection.php:1106 Doctrine\DBAL\Connection->executeQuery() at /www/htdocs/w00XXXXX/demo/kunde/vendor/doctrine/dbal/src/Connection.php:902 Doctrine\DBAL\Connection->fetchAllAssociative() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Image/ImageSizes.php:103 Contao\CoreBundle\Image\ImageSizes->loadOptions() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Image/ImageSizes.php:55 Contao\CoreBundle\Image\ImageSizes->getAllOptions() at /www/htdocs/w00XXXXX/demo/kunde/vendor/con4gis/maps/src/Resources/contao/dca/tl_c4g_map_locstyles.php:19 include() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/DcaLoader.php:122 Contao\DcaLoader->loadDcaFiles() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/DcaLoader.php:82 Contao\DcaLoader->load() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/Controller.php:1197 Contao\Controller::loadDataContainer() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/DcaExtractor.php:360 Contao\DcaExtractor->createExtract() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/DcaExtractor.php:118 Contao\DcaExtractor->__construct() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/DcaExtractor.php:140 Contao\DcaExtractor::getInstance() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/Database/Installer.php:185 Contao\Database\Installer->getFromDca() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Doctrine/Schema/DcaSchemaProvider.php:306 Contao\CoreBundle\Doctrine\Schema\DcaSchemaProvider->getSqlDefinitions() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Doctrine/Schema/DcaSchemaProvider.php:42 Contao\CoreBundle\Doctrine\Schema\DcaSchemaProvider->appendToSchema() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/EventListener/DoctrineSchemaListener.php:38 Contao\CoreBundle\EventListener\DoctrineSchemaListener->postGenerateSchema() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/doctrine-bridge/ContainerAwareEventManager.php:63 Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent() at /www/htdocs/w00XXXXX/demo/kunde/vendor/doctrine/orm/src/Tools/SchemaTool.php:421 Doctrine\ORM\Tools\SchemaTool->getSchemaFromMetadata() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Doctrine/Schema/SchemaProvider.php:35 Contao\CoreBundle\Doctrine\Schema\SchemaProvider->createSchema() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Migration/CommandCompiler.php:38 Contao\CoreBundle\Migration\CommandCompiler->compileCommands() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Command/MigrateCommand.php:217 Contao\CoreBundle\Command\MigrateCommand->hasWorkToDo() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Command/MigrateCommand.php:115 Contao\CoreBundle\Command\MigrateCommand->backup() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Command/MigrateCommand.php:88 Contao\CoreBundle\Command\MigrateCommand->execute() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/console/Command/Command.php:326 Symfony\Component\Console\Command\Command->run() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/console/Application.php:1096 Symfony\Component\Console\Application->doRunCommand() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/framework-bundle/Console/Application.php:126 Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/console/Application.php:324 Symfony\Component\Console\Application->doRun() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/framework-bundle/Console/Application.php:80 Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/console/Application.php:175 Symfony\Component\Console\Application->run() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/manager-bundle/bin/contao-console:40 include() at /www/htdocs/w00XXXXX/demo/kunde/vendor/bin/contao-console:119 In Exception.php line 28: [Doctrine\DBAL\Driver\PDO\Exception (1146)] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd0403618.tl_image_size' doesn't exist Exception trace: at /www/htdocs/w00XXXXX/demo/kunde/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28 Doctrine\DBAL\Driver\PDO\Exception::new() at /www/htdocs/w00XXXXX/demo/kunde/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:76 Doctrine\DBAL\Driver\PDO\Connection->query() at /www/htdocs/w00XXXXX/demo/kunde/vendor/doctrine/dbal/src/Connection.php:1101 Doctrine\DBAL\Connection->executeQuery() at /www/htdocs/w00XXXXX/demo/kunde/vendor/doctrine/dbal/src/Connection.php:902 Doctrine\DBAL\Connection->fetchAllAssociative() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Image/ImageSizes.php:103 Contao\CoreBundle\Image\ImageSizes->loadOptions() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Image/ImageSizes.php:55 Contao\CoreBundle\Image\ImageSizes->getAllOptions() at /www/htdocs/w00XXXXX/demo/kunde/vendor/con4gis/maps/src/Resources/contao/dca/tl_c4g_map_locstyles.php:19 include() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/DcaLoader.php:122 Contao\DcaLoader->loadDcaFiles() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/DcaLoader.php:82 Contao\DcaLoader->load() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/Controller.php:1197 Contao\Controller::loadDataContainer() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/DcaExtractor.php:360 Contao\DcaExtractor->createExtract() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/DcaExtractor.php:118 Contao\DcaExtractor->__construct() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/DcaExtractor.php:140 Contao\DcaExtractor::getInstance() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/Database/Installer.php:185 Contao\Database\Installer->getFromDca() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Doctrine/Schema/DcaSchemaProvider.php:306 Contao\CoreBundle\Doctrine\Schema\DcaSchemaProvider->getSqlDefinitions() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Doctrine/Schema/DcaSchemaProvider.php:42 Contao\CoreBundle\Doctrine\Schema\DcaSchemaProvider->appendToSchema() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/EventListener/DoctrineSchemaListener.php:38 Contao\CoreBundle\EventListener\DoctrineSchemaListener->postGenerateSchema() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/doctrine-bridge/ContainerAwareEventManager.php:63 Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent() at /www/htdocs/w00XXXXX/demo/kunde/vendor/doctrine/orm/src/Tools/SchemaTool.php:421 Doctrine\ORM\Tools\SchemaTool->getSchemaFromMetadata() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Doctrine/Schema/SchemaProvider.php:35 Contao\CoreBundle\Doctrine\Schema\SchemaProvider->createSchema() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Migration/CommandCompiler.php:38 Contao\CoreBundle\Migration\CommandCompiler->compileCommands() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Command/MigrateCommand.php:217 Contao\CoreBundle\Command\MigrateCommand->hasWorkToDo() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Command/MigrateCommand.php:115 Contao\CoreBundle\Command\MigrateCommand->backup() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Command/MigrateCommand.php:88 Contao\CoreBundle\Command\MigrateCommand->execute() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/console/Command/Command.php:326 Symfony\Component\Console\Command\Command->run() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/console/Application.php:1096 Symfony\Component\Console\Application->doRunCommand() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/framework-bundle/Console/Application.php:126 Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/console/Application.php:324 Symfony\Component\Console\Application->doRun() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/framework-bundle/Console/Application.php:80 Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/console/Application.php:175 Symfony\Component\Console\Application->run() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/manager-bundle/bin/contao-console:40 include() at /www/htdocs/w00XXXXX/demo/kunde/vendor/bin/contao-console:119 In Connection.php line 71: [PDOException (42S02)] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd0403618.tl_image_size' doesn't exist Exception trace: at /www/htdocs/w00XXXXX/demo/kunde/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71 PDO->query() at /www/htdocs/w00XXXXX/demo/kunde/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71 Doctrine\DBAL\Driver\PDO\Connection->query() at /www/htdocs/w00XXXXX/demo/kunde/vendor/doctrine/dbal/src/Connection.php:1101 Doctrine\DBAL\Connection->executeQuery() at /www/htdocs/w00XXXXX/demo/kunde/vendor/doctrine/dbal/src/Connection.php:902 Doctrine\DBAL\Connection->fetchAllAssociative() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Image/ImageSizes.php:103 Contao\CoreBundle\Image\ImageSizes->loadOptions() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Image/ImageSizes.php:55 Contao\CoreBundle\Image\ImageSizes->getAllOptions() at /www/htdocs/w00XXXXX/demo/kunde/vendor/con4gis/maps/src/Resources/contao/dca/tl_c4g_map_locstyles.php:19 include() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/DcaLoader.php:122 Contao\DcaLoader->loadDcaFiles() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/DcaLoader.php:82 Contao\DcaLoader->load() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/Controller.php:1197 Contao\Controller::loadDataContainer() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/DcaExtractor.php:360 Contao\DcaExtractor->createExtract() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/DcaExtractor.php:118 Contao\DcaExtractor->__construct() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/DcaExtractor.php:140 Contao\DcaExtractor::getInstance() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/contao/library/Contao/Database/Installer.php:185 Contao\Database\Installer->getFromDca() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Doctrine/Schema/DcaSchemaProvider.php:306 Contao\CoreBundle\Doctrine\Schema\DcaSchemaProvider->getSqlDefinitions() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Doctrine/Schema/DcaSchemaProvider.php:42 Contao\CoreBundle\Doctrine\Schema\DcaSchemaProvider->appendToSchema() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/EventListener/DoctrineSchemaListener.php:38 Contao\CoreBundle\EventListener\DoctrineSchemaListener->postGenerateSchema() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/doctrine-bridge/ContainerAwareEventManager.php:63 Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent() at /www/htdocs/w00XXXXX/demo/kunde/vendor/doctrine/orm/src/Tools/SchemaTool.php:421 Doctrine\ORM\Tools\SchemaTool->getSchemaFromMetadata() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Doctrine/Schema/SchemaProvider.php:35 Contao\CoreBundle\Doctrine\Schema\SchemaProvider->createSchema() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Migration/CommandCompiler.php:38 Contao\CoreBundle\Migration\CommandCompiler->compileCommands() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Command/MigrateCommand.php:217 Contao\CoreBundle\Command\MigrateCommand->hasWorkToDo() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Command/MigrateCommand.php:115 Contao\CoreBundle\Command\MigrateCommand->backup() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/core-bundle/src/Command/MigrateCommand.php:88 Contao\CoreBundle\Command\MigrateCommand->execute() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/console/Command/Command.php:326 Symfony\Component\Console\Command\Command->run() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/console/Application.php:1096 Symfony\Component\Console\Application->doRunCommand() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/framework-bundle/Console/Application.php:126 Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/console/Application.php:324 Symfony\Component\Console\Application->doRun() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/framework-bundle/Console/Application.php:80 Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /www/htdocs/w00XXXXX/demo/kunde/vendor/symfony/console/Application.php:175 Symfony\Component\Console\Application->run() at /www/htdocs/w00XXXXX/demo/kunde/vendor/contao/manager-bundle/bin/contao-console:40 include() at /www/htdocs/w00XXXXX/demo/kunde/vendor/bin/contao-console:119 contao:migrate [--with-deletes] [--schema-only] [--migrations-only] [--dry-run] [--format FORMAT] [--no-backup] [--hash HASH]

Wenn du schon SSH Zugriff hast, führe mal ein contao:migrate durch :)

Zitat:

Zitat von zoglo

Wenn du schon SSH Zugriff hast, führe mal ein contao:migrate durch :)

Hab ich doch?

Code:

/usr/bin/php82 vendor/bin/contao-console contao:migrate --no-interaction -v

Schlechtes Internet, hab die Nachricht nicht gesehen.

Die Datenbank ist aber verbunden?

Zitat:

Zitat von zoglo

Schlechtes Internet, hab die Nachricht nicht gesehen.

Die Datenbank ist aber verbunden?

Ja, ich habe Testweise, damit ich voran komme, die Struktur einer anderen Contao 5 Installation importiert. Danach konnte ich auch alle Änderungen durchführen. Vorher wurde jedoch keine einzige Tabelle erstellt.
Die Datenbank war angelegt, die Daten stimmen auch, habe nichts weiter geändert und nach dem Import ging es.

Das ist ein Fehler in con4gis/maps. Welche Version hast du installiert?

Jedenfalls wirst du als Workaround con4gis/maps zuerst deinstallieren müssen, dann die Datenbank einrichten, dann erst wieder con4gis/maps installieren.

Moderation: Posts aus dem ursprünglichen Thread in das richtige Unterforum verschoben.

Zitat:

Zitat von Spooky

Jedenfalls wirst du als Workaround con4gis/maps zuerst deinstallieren müssen, dann die Datenbank einrichten, dann erst wieder con4gis/maps installieren.

Okay, so bin ich ja quasi vorgekommen jetzt.
Installiert hatte ich die neuste Version v8.2.25