“Unknown database type point requested” on schema update

[jaikdean]

I have the following setup in a Symfony 3.3 app:

# config.yml
doctrine:
    dbal:
        types:
            geography_point: CrEOF\Spatial\DBAL\Types\Geography\PointType

class Outlet
{
    /**
     * @var CrEOF\Spatial\PHP\Types\Geography\Point
     * @ORM\Column(name="location", type="geography_point", nullable=true)
     */
    private $location;
}

This works as expected, creating the following table:

CREATE TABLE `outlet` (
  `location` point DEFAULT NULL COMMENT '(DC2Type:geography_point)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

However, when I run a php bin/console doctrine:schema:update I get the following exception:

[Doctrine\DBAL\DBALException]                                                                     
Unknown database type point requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it.

Any ideas what to try?

[mikysan]

run into same problem!

[kmusiclife]

same problem I detected.

[braianj]

same here. Any news?

[alejandrososa]

It´s work for me

http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/cookbook/advanced-field-value-conversion-using-custom-mapping-types.html

doctrine:
    dbal:
        types:
            point:  CommonBundle\Type\PointType
        default_connection: app
        connections:
            app:
                driver: pdo_mysql
                host:   '%database_host%'
                port:   '%database_port%'
                dbname: '%database_name%'
                user:   '%database_user%'
                password: '%database_password%'
                charset: UTF8
                mapping_types:
                    enum: string
                    set: string
                    point: point

[jsampedro77]

As @alejandrososa sated, I had to declare the mapping type to get rid of this problem

doctrine:
    dbal:
        mapping_types:
            point: point

[alexislefebvre]

We had a smilar problem with Symfony 4.1.1 and doctrine/orm 2.6.1

We installed this bundle in order to use the CrEOF\Spatial\DBAL\Types\Geography\PointType type.

But generating Doctrine migration triggered the following error:

Unknown database type geometry requested, Doctrine\DBAL\Platforms\PostgreSQL94Platform may not support it.

We had similar errors so we had to declare other types:

doctrine:
    dbal:
        # configure these for your database server
        driver: 'pdo_pgsql'
        server_version: '9.4'

        # With Symfony 3.3, remove the `resolve:` prefix
        url: '%env(resolve:DATABASE_URL)%'
        types:
            geometry:   CrEOF\Spatial\DBAL\Types\GeometryType
            point:      CrEOF\Spatial\DBAL\Types\Geometry\PointType
            geography:  CrEOF\Spatial\DBAL\Types\GeographyType
        mapping_types:
            _text: string # see https://groups.google.com/d/msg/doctrine-user/1F6M3NHmwak/bcpJD4DXxzIJ
    orm:
        auto_generate_proxy_classes: '%kernel.debug%'
        naming_strategy: doctrine.orm.naming_strategy.underscore
        auto_mapping: true
        mappings:
            # …

And it worked for us.