Symfony Doctrine DBAL Error: Unknown column type "json_array" requested after upgrading to DBAL 3"

Question

I runed the command composer install in my Symfony project. However, when I attempted to run the command symfony console doctrine:schema:update, I encountered the error message:

Unknown column type "json_array" requested. Any Doctrine type that you use has to be registered with \Doctrine\DBAL\Types\Type::addType(). You can get a list of all the known types with \Doctrine\DBAL\Types\Type::getTypesMap(). If this error occurs during database introspection then you might have forgotten to register all database types for a Doctrine Type. Use AbstractPlatform#registerDoctrineTypeMapping() or have your custom types implement Type#getMappedDatabaseTypes(). If the type name is empty you might have a problem with the cache or forgot some mapping information.

I then modified my code line @ORM\Column(type="json_array") to @ORM\Column(type="json"), but the error persisted when I runed symfony console doctrine:schema:update

From what I understand, one of the sources of the problem is that when I executed the command composer show doctrine/dbal, it indicated that I was using version 3.8.2. However, just two days ago, when I executed the same command, I was still using version 2.13.2.

I came across this article https://dunglas.dev/2022/01/json-columns-and-doctrine-dbal-3-upgrade/, but unfortunately, I do not fully understand its content.

Thank you in advance for any assistance you can provide

Alec · Accepted Answer · 2024-09-03 20:37:32Z

3

First:

SELECT table_schema, table_name, column_name, column_comment
FROM information_schema.columns
WHERE column_comment LIKE '%(DC2Type:json_array)%';

Then for each of the resulting tables names:

ALTER TABLE <table_name> 
MODIFY COLUMN <column_name> longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:json)';

answered Sep 3, 2024 at 20:37

Alec

312 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jeremy Caney Over a year ago

Thank you for contributing to the Stack Overflow community. This may be a correct answer, but it’d be really useful to provide additional explanation of your code so developers can understand your reasoning. This is especially useful for new developers who aren’t as familiar with the syntax or struggling to understand the concepts. Would you kindly edit your answer to include additional details for the benefit of the community?

LordWeedlle Dec 6, 2024 at 10:37

Thanks for the answer, worked like a charm! For those wo will use it too, do not forget to adapt the part COLLATE utf8mb4_unicode_ci to what is currently being used by your column.

Collectives™ on Stack Overflow

Symfony Doctrine DBAL Error: Unknown column type "json_array" requested after upgrading to DBAL 3"

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related