Relation Columns

[Charlie-Lucas]

When i try use a one to many following the documentation, i got an weird error

[Syntax Error] line 0, col 468: Error: Expected Doctrine\ORM\Query\Lexer::T_FROM, got ':'

The query executed is :

 SELECT _a.firstname, _a.lastname, _a.email, _a.schoolName, _a.addressCity, _a.createdAt, _a.id, _a.username, _a.usernameCanonical, _a.emailCanonical, _a.enabled, _a.salt, _a.password, _a.lastLogin, _a.confirmationToken, _a.passwordRequestedAt, _a.locked, _a.expired, _a.expiresAt, _a.roles, _a.credentialsExpired, _a.credentialsExpireAt, _a.locale, _a.updatedAt, _a.birthDate, _a.addressStreet, _a.addressPostalCode, _a.schoolCity, _a.phone, _projects.name as projects::name, _a.facebookId, _a.facebook_access_token, _a.nationality, _a.country, _a.visibleOnFront FROM Wweeddoo\CoreBundle\Entity\User\User _a LEFT JOIN _a.projects _projects 

my projects atribute in author

    /**
     * @ORM\OneToMany(targetEntity="Project", mappedBy="author", cascade={"persist"})
     * @GRID\Column(field="projects.name", title="Projects")
    */
    protected $projects;

I dont understand why the Entity class replace "." by "::". Do this real work on a sql server?

[marvinhinz]

I have the same problem, did you find a solution or workaround?

Edit: For me it seems to fix it when all occurrencies of '::' in this bundle are replaced with something like '___'. Im running Doctrine on MySql, so i dont know if this impacts other databases negatively.

[DonCallisto]

The problem is not related to a particular version of symfony (as I read in other issues) but to Doctrine.
With 2.5.11 version (last tested by us) it's ok, from 2.6 probably (we're not sure of it) the problem rises.

@plfort referring to #991, this can be one of the problems I've pointed out: how can we freeze those deps?

I'm still not really sure about good practices here

[Dakhtara]

In my case I actually have doctrine/orm 2.6. I try with 2.5.11

Edit: moved to 2.5.11 works.
I fixed this versions :
apy/datagrid: 3.0.2
doctrine/orm : 2.5.11

Thanks

[DonCallisto]

@plfort I suppose we should freeze doctrine/orm to 2.5.*, WDYT?

[marvinhinz]

@DonCallisto Why not just replace the placeholder "::" with something different?

[DonCallisto]

Didn't say that's not a good idea, just saying that we should block at 2.5.* for this version and allow 2.6 from next release with :: fixed.

WDYT?

[marvinhinz]

Sounds fine, as long as there are no drawbacks/incompatibilities when using doctrine 2.5 in a symfony 3.4.4 app. Is this a bug introduced in doctrine 2.6 or is that behaviour intended?