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

[kalterwind]

In der Contao Installation folgendes Kommando durchführen:

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!?

[Spooky]

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

[kalterwind]

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]

[zoglo]

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

[kalterwind]

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

Hab ich doch?

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

[zoglo]

Schlechtes Internet, hab die Nachricht nicht gesehen.

Die Datenbank ist aber verbunden?

[kalterwind]

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.

[Spooky]

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

[Spooky]

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

[Spooky]

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

[kalterwind]

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