Hello
I'm trying to install sonata media bundle on a symfony 3.2.7/php7/doctrine environnement.
I'm folowing this doc :
https://sonata-project.org/bundles/media/3-x/doc/reference/installation.htmlBut i have an error when i'm using this command line, to generate DB : php bin/console doctrine:schema:update --force
the error message :
[Doctrine\DBAL\DBALException]
Unknown column type "json" requested. Any Doctrine type that you use has to be registered with \Doctrine\DBAL\Types\Type::addT
ype(). You can get a list of all the known types with \Doctrine\DBAL\Types\Type::getTypesMap(). If this error occurs during da
tabase introspection then you might have forgot to register all database types for a Doctrine Type. Use AbstractPlatform#regis
terDoctrineTypeMapping() or have your custom types implement Type#getMappedDatabaseTypes(). If the type name is empty you migh
t have a problem with the cache or forgot some mapping information.
also, when i'm typing this comande line : php bin/console doctrine:schema:validate
i have the following messages :
[Mapping] FAIL - The entity-class 'Sonata\MediaBundle\Entity\BaseMedia' mapping is invalid:
* The field 'Sonata\MediaBundle\Entity\BaseMedia#providerMetadata' uses a non-existant type 'json'.
[Mapping] FAIL - The entity-class 'Application\Sonata\MediaBundle\Entity\Media' mapping is invalid:
* The field 'Application\Sonata\MediaBundle\Entity\Media#providerMetadata' uses a non-existant type 'json'.this is my composer.json :
"require": {
"php": ">=5.5.9",
"symfony/symfony": "3.2.*",
"doctrine/orm": "^2.5",
"doctrine/doctrine-bundle": "^1.6",
"doctrine/doctrine-cache-bundle": "^1.2",
"symfony/swiftmailer-bundle": "^2.3.10",
"symfony/monolog-bundle": "^3.0.2",
"symfony/polyfill-apcu": "^1.0",
"sensio/distribution-bundle": "^5.0",
"sensio/framework-extra-bundle": "^3.0.2",
"incenteev/composer-parameter-handler": "^2.0",
"symfony/intl": "^3",
"hautelook/alice-bundle": "^1.3",
"doctrine/doctrine-fixtures-bundle": "^2.3",
"friendsofsymfony/user-bundle": "~2.0@dev",
"jms/translation-bundle": "dev-master",
"jms/i18n-routing-bundle": "dev-master",
"sonata-project/admin-bundle": "^3.16",
"sonata-project/doctrine-orm-admin-bundle": "^3.1",
"sonata-project/media-bundle": "^3.5"
},
Do you know what i'm doing wrong ?
thanks in advance ;)