2.13.2 - 2.13.3 | Enum column - Object of class x could not be converted to x #7046

New Issue

Closed

opened 2026-01-22 15:43:39 +01:00 by admin · 14 comments

admin commented 2026-01-22 15:43:39 +01:00

Owner

Copy Link

Originally created by @ThomasGoffart on GitHub (Sep 26, 2022).

Bug Report

Q	A
BC Break	yes
Version	2.13.2 - 2.13.3

Summary

When having an enum column like this:

#[ORM\Column(enumType: Color::class)]
private Color $color;

This error occurred when you load the entity from a query from the Query Builder (repository):

Warning: Object of class App\Enum\Color could not be converted to int

Workaround

Downgrade doctrine/orm to 2.13.1 version while waiting for a fix.

Originally created by @ThomasGoffart on GitHub (Sep 26, 2022). ### Bug Report <!-- Fill in the relevant information below to help triage your issue. --> | Q | A |------------ | ------ | BC Break | yes | Version | 2.13.2 - 2.13.3 #### Summary When having an enum column like this: ```php #[ORM\Column(enumType: Color::class)] private Color $color; ``` This error occurred when you load the entity from a query from the Query Builder (repository): > Warning: Object of class App\Enum\Color could not be converted to int #### Workaround Downgrade `doctrine/orm` to 2.13.1 version while waiting for a fix.

admin closed this issue 2026-01-22 15:43:40 +01:00

admin commented 2026-01-22 15:43:41 +01:00

Author

Owner

Copy Link

@michnovka commented on GitHub (Sep 26, 2022):

This is also likely to be fixed with https://github.com/doctrine/orm/pull/10058 . Please confirm

@michnovka commented on GitHub (Sep 26, 2022): This is also likely to be fixed with https://github.com/doctrine/orm/pull/10058 . Please confirm

admin commented 2026-01-22 15:43:41 +01:00

Author

Owner

Copy Link

@NotionCommotion commented on GitHub (Sep 26, 2022):

I am getting the same error, and when I comment out $this->rsm->addEnumResult($columnAlias, $mapping['enumType']); on line number 1525 added by this commit, I no longer get the error.

namespace Doctrine\ORM\Query;
class SqlWalker implements TreeWalker
{
    public function walkSelectExpression($selectExpression)
    {
                    ...
                    if (! empty($mapping['enumType'])) {
                        $this->rsm->addEnumResult($columnAlias, $mapping['enumType']);
                    }
                    ...
	}
}

Note that for my case, Doctrine tries to typecast PermissionEnum to an integer

namespace Doctrine\DBAL\Types;
class SmallIntType extends Type implements PhpIntegerMappingType
{
    ...
	public function convertToPHPValue($value, AbstractPlatform $platform)
    {
        return $value === null ? null : (int) $value;
    }
    ...
}

resulting in error Warning: Object of class App\\Entity\AccessControl\Acl\PermissionEnum could not be converted to int.

However, as shown below, PermissionEnum is never intended to be directly persisted in the database but only as a subpart in Permission.

namespace App\Doctrine\Types;

use App\Entity\AccessControl\Acl\Permission;
use Doctrine\DBAL\Platforms\AbstractPlatform;
use Doctrine\DBAL\Types\ConversionException;
use Doctrine\DBAL\Types\Type;

final class PermissionType extends Type
{
    private const PERMISSION = 'permission';

    public function getSQLDeclaration(array $fieldDeclaration, AbstractPlatform $platform): string
    {
        return $platform->getSmallIntTypeDeclarationSQL($fieldDeclaration);
    }

    public function convertToPHPValue($value, AbstractPlatform $platform): mixed
    {
        if (null === $value) {
            return null;
        }

        if (\is_int($value)) {
            return Permission::createFromValue($value);
        }

        throw ConversionException::conversionFailedInvalidType($value, $this->getName(), ['int', 'null']);
    }

    public function convertToDatabaseValue($value, AbstractPlatform $platform): mixed
    {
        if (null === $value) {
            return null;
        }

        if ($value instanceof Permission) {
            return $value->getValue();
        }

        throw ConversionException::conversionFailedInvalidType($value, $this->getName(), [Permission::class, 'null']);
    }

    public function requiresSQLCommentHint(AbstractPlatform $platform): bool
    {
        return true;
    }

    public function getName(): string
    {
        return self::PERMISSION;
    }
}

class Permission
{
    private const READ      = 0b0000000011;
    private const CREATE    = 0b0000001100;
    private const MODIFY    = 0b0000110000;
    private const DELETE    = 0b0011000000;
    private const COWORKER  = 0b0100000000; // Not currently used.
    private const OWNER     = 0b1000000000; // Not currently used.

    public function __construct(
        private ?PermissionEnum $read=null,
        private ?PermissionEnum $create=null,
        private ?PermissionEnum $modify=null,
        private ?PermissionEnum $delete=null,
        private ?bool $restrictToOwner=null,
        private ?bool $coworkers=null
    ) {
    }

    public function getValue(): ?int
    {
        if($this->hasNullValue()) {
            throw new Exception('Permission has NULL values.');
        }
        $rs = $this->read->value | $this->create->value << 2 | $this->modify->value << 4 | $this->delete->value << 6;
        $rs = $this->coworkers ? $rs | self::COWORKER : $rs & ~self::COWORKER;

        return $this->restrictToOwner ? $rs | self::OWNER : $rs & ~self::OWNER;
    }
}

enum PermissionEnum: int
{
    case public     = 0b00;
    case owner      = 0b01;
    case restrict   = 0b10;
    case extra      = 0b11; 
}

@NotionCommotion commented on GitHub (Sep 26, 2022): I am getting the same error, and when I comment out `$this->rsm->addEnumResult($columnAlias, $mapping['enumType']);` on line number 1525 added by [this commit](https://github.com/doctrine/orm/commit/bc7e252f00858950bd1fdc24c82ab1042b587288), I no longer get the error. ```php namespace Doctrine\ORM\Query; class SqlWalker implements TreeWalker { public function walkSelectExpression($selectExpression) { ... if (! empty($mapping['enumType'])) { $this->rsm->addEnumResult($columnAlias, $mapping['enumType']); } ... } } ``` Note that for my case, Doctrine tries to typecast `PermissionEnum` to an integer ```php namespace Doctrine\DBAL\Types; class SmallIntType extends Type implements PhpIntegerMappingType { ... public function convertToPHPValue($value, AbstractPlatform $platform) { return $value === null ? null : (int) $value; } ... } ``` resulting in error `Warning: Object of class App\\Entity\AccessControl\Acl\PermissionEnum could not be converted to int`. However, as shown below, `PermissionEnum` is never intended to be directly persisted in the database but only as a subpart in `Permission`. ```php namespace App\Doctrine\Types; use App\Entity\AccessControl\Acl\Permission; use Doctrine\DBAL\Platforms\AbstractPlatform; use Doctrine\DBAL\Types\ConversionException; use Doctrine\DBAL\Types\Type; final class PermissionType extends Type { private const PERMISSION = 'permission'; public function getSQLDeclaration(array $fieldDeclaration, AbstractPlatform $platform): string { return $platform->getSmallIntTypeDeclarationSQL($fieldDeclaration); } public function convertToPHPValue($value, AbstractPlatform $platform): mixed { if (null === $value) { return null; } if (\is_int($value)) { return Permission::createFromValue($value); } throw ConversionException::conversionFailedInvalidType($value, $this->getName(), ['int', 'null']); } public function convertToDatabaseValue($value, AbstractPlatform $platform): mixed { if (null === $value) { return null; } if ($value instanceof Permission) { return $value->getValue(); } throw ConversionException::conversionFailedInvalidType($value, $this->getName(), [Permission::class, 'null']); } public function requiresSQLCommentHint(AbstractPlatform $platform): bool { return true; } public function getName(): string { return self::PERMISSION; } } ``` ```php class Permission { private const READ = 0b0000000011; private const CREATE = 0b0000001100; private const MODIFY = 0b0000110000; private const DELETE = 0b0011000000; private const COWORKER = 0b0100000000; // Not currently used. private const OWNER = 0b1000000000; // Not currently used. public function __construct( private ?PermissionEnum $read=null, private ?PermissionEnum $create=null, private ?PermissionEnum $modify=null, private ?PermissionEnum $delete=null, private ?bool $restrictToOwner=null, private ?bool $coworkers=null ) { } public function getValue(): ?int { if($this->hasNullValue()) { throw new Exception('Permission has NULL values.'); } $rs = $this->read->value | $this->create->value << 2 | $this->modify->value << 4 | $this->delete->value << 6; $rs = $this->coworkers ? $rs | self::COWORKER : $rs & ~self::COWORKER; return $this->restrictToOwner ? $rs | self::OWNER : $rs & ~self::OWNER; } } ``` ```php enum PermissionEnum: int { case public = 0b00; case owner = 0b01; case restrict = 0b10; case extra = 0b11; } ```

admin commented 2026-01-22 15:43:41 +01:00

Author

Owner

Copy Link

@derrabus commented on GitHub (Sep 27, 2022):

@NotionCommotion Please provide a small application or a functional test case that reproduces your issue.

@derrabus commented on GitHub (Sep 27, 2022): @NotionCommotion Please provide a small application or a functional test case that reproduces your issue.

admin commented 2026-01-22 15:43:41 +01:00

Author

Owner

Copy Link

@kshtompel commented on GitHub (Sep 27, 2022):

I see fix of this issue in this commit
d69a0fa2cf
but it was not released as 2.13.3
when to expect the release?

@kshtompel commented on GitHub (Sep 27, 2022): I see fix of this issue in this commit https://github.com/doctrine/orm/commit/d69a0fa2cfd3b883200a6324829945509f4ecc07 but it was not released as 2.13.3 when to expect the release?

admin commented 2026-01-22 15:43:42 +01:00

Author

Owner

Copy Link

@devtronic commented on GitHub (Sep 28, 2022):

See also #10057

@devtronic commented on GitHub (Sep 28, 2022): See also #10057

admin commented 2026-01-22 15:43:42 +01:00

Author

Owner

Copy Link

@NotionCommotion commented on GitHub (Sep 28, 2022):

@derrabus I spent about 4 hours yesterday trying to isolate the issue so I may provide it, but was unsuccessful. Didn't try everything such as checking whether some 3rd party app such as doctrine extensions is also involved. Any thoughts how one best troubleshoots and isolates issues such as this?

@NotionCommotion commented on GitHub (Sep 28, 2022): @derrabus I spent about 4 hours yesterday trying to isolate the issue so I may provide it, but was unsuccessful. Didn't try everything such as checking whether some 3rd party app such as doctrine extensions is also involved. Any thoughts how one best troubleshoots and isolates issues such as this?

admin commented 2026-01-22 15:43:43 +01:00

Author

Owner

Copy Link

@kshtompel commented on GitHub (Oct 9, 2022):

@ThomasGoffart is it resolved now?

@kshtompel commented on GitHub (Oct 9, 2022): @ThomasGoffart is it resolved now?

admin commented 2026-01-22 15:43:43 +01:00

Author

Owner

Copy Link

@greg0ire commented on GitHub (Oct 9, 2022):

Let me know if it is not resolved and I will reopen this.

@greg0ire commented on GitHub (Oct 9, 2022): Let me know if it is not resolved and I will reopen this.

admin commented 2026-01-22 15:43:43 +01:00

Author

Owner

Copy Link

@ThomasGoffart commented on GitHub (Oct 11, 2022):

This issue is still on my side (doctrine/orm v2.13.3 )

@ThomasGoffart commented on GitHub (Oct 11, 2022): > This issue is still on my side (`doctrine/orm` v2.13.3 )

admin commented 2026-01-22 15:43:44 +01:00

Author

Owner

Copy Link

@michnovka commented on GitHub (Oct 11, 2022):

Can you please provide your Color enum definition?

@michnovka commented on GitHub (Oct 11, 2022): Can you please provide your `Color` enum definition?

admin commented 2026-01-22 15:43:44 +01:00

Author

Owner

Copy Link

@ThomasGoffart commented on GitHub (Oct 11, 2022):

This error occurs with a classic enum.
Here is a common example of enum that causes this problem.

<?php

namespace App\Enum;

enum Color: int {

    case Red = 1;
    case Green = 2;
    case Blue = 3;

}

@ThomasGoffart commented on GitHub (Oct 11, 2022): This error occurs with a classic enum. Here is a common example of enum that causes this problem. ```php <?php namespace App\Enum; enum Color: int { case Red = 1; case Green = 2; case Blue = 3; } ```

admin commented 2026-01-22 15:43:45 +01:00

Author

Owner

Copy Link

@michnovka commented on GitHub (Oct 11, 2022):

Just out of curiosity, when using string backed enums, can you also reproduce the issue?

@michnovka commented on GitHub (Oct 11, 2022): Just out of curiosity, when using `string` backed enums, can you also reproduce the issue?

admin commented 2026-01-22 15:43:45 +01:00

Author

Owner

Copy Link

@ThomasGoffart commented on GitHub (Oct 11, 2022):

Yes, I tested it and it also happens.

@ThomasGoffart commented on GitHub (Oct 11, 2022): Yes, I tested it and it also happens.

admin commented 2026-01-22 15:43:45 +01:00

Author

Owner

Copy Link

@michnovka commented on GitHub (Oct 11, 2022):

Do these tests you submitted fail - https://github.com/doctrine/orm/pull/10111 ?

If they do not, can you please push PR with failing tests? I will work on it then.

@michnovka commented on GitHub (Oct 11, 2022): Do these tests you submitted fail - https://github.com/doctrine/orm/pull/10111 ? If they do not, can you please push PR with failing tests? I will work on it then.

admin referenced this issue 2026-01-22 16:07:05 +01:00

[PR #7046] [CS] Fix CS in tests #10289

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

3.6.x

2.20.x

dependabot/github_actions/2.20.x/doctrine/dot-github/dot-github/workflows/composer-lint.yml-14.0.0

3.7.x

4.0.x

2.21.x

old-prototype-3.x

3.6.2

3.6.1

3.6.0

2.20.9

3.5.8

3.5.7

3.5.6

3.5.5

2.20.8

3.5.4

3.5.3

2.20.7

3.5.2

2.20.6

3.5.1

3.5.0

3.4.4

3.4.3

3.4.2

2.20.5

3.4.1

3.4.0

3.3.4

2.20.4

3.3.3

2.20.3

3.3.2

2.20.2

3.3.1

2.20.1

3.3.0

3.2.3

2.20.0

2.19.8

3.2.2

2.19.7

3.2.1

2.19.6

3.2.0

3.1.4

3.1.3

2.19.5

3.1.2

2.19.4

3.1.1

2.19.3

2.19.2

2.19.1

3.1.0

2.19.0

3.0.3

2.18.3

3.0.2

2.18.2

3.0.1

2.18.1

3.0.0

2.18.0

2.17.5

3.0.0-RC1

2.17.4

2.17.3

2.17.2

2.17.1

3.0.0-beta2

2.17.0

2.16.3

3.0.0-beta1

2.16.2

2.16.1

2.16.0

2.15.5

2.15.4

2.15.3

2.15.2

2.15.1

2.15.0

2.14.3

2.14.2

2.14.1

2.14.0

2.13.5

2.13.4

2.13.3

2.13.2

2.13.1

2.13.0

2.12.4

2.12.3

2.12.2

2.12.1

2.12.0

2.11.3

2.11.2

2.11.1

2.11.0

2.10.5

2.10.4

2.10.3

2.10.2

2.10.1

2.10.0

2.9.6

2.9.5

2.9.4

2.9.3

2.9.2

2.9.1

2.9.0

2.8.5

2.8.4

2.8.3

2.8.2

2.8.1

2.8.0

2.7.5

2.7.4

v2.7.3

v2.7.2

v2.7.1

v2.7.0

v2.6.6

v2.6.5

v2.6.4

v2.6.3

v2.6.2

v2.6.1

v2.6.0

v2.5.14

v2.5.13

v2.5.12

v2.5.11

v2.5.10

v2.5.9

v2.5.8

v2.5.7

v2.5.6

v2.5.5

v2.5.4

v2.5.3

v2.5.2

v2.4.8

v2.5.1

v2.5.0

v2.5.0-RC2

v2.5.0-RC1

v2.5.0-beta1

v2.5.0-alpha2

v2.5.0-alpha1

v2.4.7

v2.4.6

v2.4.5

v2.4.4

v2.4.3

v2.3.6

v2.4.2

2.3.5

v2.4.1

v2.4.0

2.4.0-RC2

2.4.0-RC1

2.4.0-BETA2

2.3.4

2.3.3

2.4.0-BETA1

2.3.2

2.3.1

2.3.0

2.3.0-RC4

2.3.0-RC3

2.3.0-RC2

2.2.3

2.3.0-RC1

2.3.0-BETA1

2.1.7

2.2.2

2.2.1

2.1.6

2.2.0

2.2.0-RC1

2.2.0-BETA2

2.2.0-BETA1

2.1.5

2.1.4

2.1.3

2.1.2

2.1.1

2.0.7

2.1.0

2.1.0RC3

2.1.0RC2

2.1.0RC1

2.0.6

2.1.0BETA1

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

2.0.0RC2

2.0.0RC1

2.0.0-BETA4

2.0.0-BETA3

2.0.0-BETA2

2.0.0-BETA1

Labels

Clear labels

BC Break

Bug

Can't Fix

Deprecation

Documentation

DQL

Duplicate

Failing Test

Hacktoberfest

Improvement

Improvement

Incomplete

Invalid

Missing Tests

New Feature

PR Created

pull-request

Mirrored from GitHub Pull Request

Question

Regression

Status: Waiting feedback

Waiting feedback

WIP

Won't Fix

No Label

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

admin

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#7046