Skip to content

Error setting up Doctrine transport for Messenger with MS SQL Server #37532

Closed
@gubler

Description

@gubler

Symfony version(s) affected: 5.1.2

Description
I added a doctrine transport to an existing application using doctrine://default. When Messenger tries to create the table I receive the error SQLSTATE[IMSSP]: This function is not implemented by this driver.

SQL Server works fine with Doctrine, Migrations, and Fixtures.

How to reproduce

Using SQL Server 2019 with MS SQL Server Drivers for PHP, add an async transport to messenger with the connection string of doctrine://default.

Possible Solution

Looking at the error trace, the error is at Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransportFactory line 50.

This is not a solution per-se, but when I comment out the PostgreSQL checks in Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransportFactory (lines 50-52, 53) and only run the connection on line 53, the table was created without a problem.

I don't want to create a pull request removing that code (reverting it back to the original code before #35485) because I don't have enough knowledge of surrounding code :/

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions