Project

General

Profile

Actions

Bug #81264

closed

Doctrine exception prevents display of Install tool

Added by Stephan Großberndt almost 7 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2017-05-19
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
8
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

When using TYPO3 8.7 on PostgreSQL/PostGIS and having a geometry column on a table registered in TCA leads to

Uncaught TYPO3 Exception
Unknown database type geometry requested, Doctrine\DBAL\Platforms\PostgreSQL92Platform may not support it.

Doctrine\DBAL\DBALException thrown in file
/typo3_src-8.7.1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/AbstractPlatform.php in line 423.

14 Doctrine\DBAL\Platforms\AbstractPlatform::getDoctrineTypeMapping("geometry")
/typo3_src-8.7.1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/PostgreSqlSchemaManager.php:
00347:         }
00348: 
00349:         $type = $this->_platform->getDoctrineTypeMapping($dbType);
00350:         $type = $this->extractDoctrineTypeFromComment($tableColumn['comment'], $type);
00351:         $tableColumn['comment'] = $this->removeDoctrineTypeFromComment($tableColumn['comment'], $type);

13 Doctrine\DBAL\Schema\PostgreSqlSchemaManager::_getPortableTableColumnDefinition(array)
/typo3_src-8.7.1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractSchemaManager.php:
00818: 
00819:             if ( ! $defaultPrevented) {
00820:                 $column = $this->_getPortableTableColumnDefinition($tableColumn);
00821:             }
00822: 

12 Doctrine\DBAL\Schema\AbstractSchemaManager::_getPortableTableColumnList("tx_myextension_mytable", "myschema", array)
/typo3_src-8.7.1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractSchemaManager.php:
00173:         $tableColumns = $this->_conn->fetchAll($sql);
00174: 
00175:         return $this->_getPortableTableColumnList($table, $database, $tableColumns);
00176:     }
00177: 

11 Doctrine\DBAL\Schema\AbstractSchemaManager::listTableColumns("tx_myextension_mytable")
/typo3_src-8.7.1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractSchemaManager.php:
00279:     public function listTableDetails($tableName)
00280:     {
00281:         $columns = $this->listTableColumns($tableName);
00282:         $foreignKeys = array();
00283:         if ($this->_platform->supportsForeignKeyConstraints()) {

10 Doctrine\DBAL\Schema\AbstractSchemaManager::listTableDetails("tx_myextension_mytable")
/typo3_src-8.7.1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractSchemaManager.php:
00266:         $tables = array();
00267:         foreach ($tableNames as $tableName) {
00268:             $tables[] = $this->listTableDetails($tableName);
00269:         }
00270: 

9 Doctrine\DBAL\Schema\AbstractSchemaManager::listTables()
/typo3_src-8.7.1/typo3/sysext/install/Classes/Controller/Action/Tool/ImportantActions.php:
00098:                 'port' => $connection->getPort(),
00099:                 'socket' => $connectionParameters['unix_socket'] ?? '',
00100:                 'numberOfTables' => count($connection->getSchemaManager()->listTables()),
00101:                 'numberOfMappedTables' => 0,
00102:             ];

8 TYPO3\CMS\Install\Controller\Action\Tool\ImportantActions::executeAction()
/typo3_src-8.7.1/typo3/sysext/install/Classes/Controller/Action/AbstractAction.php:
00066:     {
00067:         $this->initializeHandle();
00068:         return $this->executeAction();
00069:     }
00070: 

Having table columns Doctrine\DBAL does not recognize must not lead to a completely unusable Install tool.

How to reproduce:

ALTER TABLE tx_myextension_mytable ADD COLUMN koordinate geometry(Point,3857);

Actions #1

Updated by Gerrit Code Review almost 7 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52858

Actions #2

Updated by Gerrit Code Review almost 7 years ago

Patch set 1 for branch TYPO3_8-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52907

Actions #3

Updated by Stephan Großberndt almost 7 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #4

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF