Symfony DQL syntax error

Question

I'm trying to do DQL query, but having some troubles with it...

$user = $this->getUser();

$query = $em->createQuery(
    'SELECT p
       FROM AppBundle:User u
         JOIN AppBundle:Follower f
         JOIN AppBundle:Photo p 
           WHERE u.id = :id
           AND f.follower_id = :id
           AND p.user_id = f.user_id'
)->setParameter('id', $user->getId());

I am trying to get Photos (AppBundle:Photo) of those users, to whom the logged user is following.

Getting next error:

`[Syntax Error] line 0, col 128: Error: Expected =, <, <=, <>, >, >=, !=, got 'p'`

Whats wrong here with 'p' ?

p is the table alias, try to select p.*. But I think Doctrine will not allow you to select something that does not contain at least your main table, i.e. u.* — tchap
– tchap, Commented Nov 30, 2015 at 20:23

BENARD Patrick · Accepted Answer · 2015-11-30 21:41:58Z

1

I don't understand why follower are in your code, I don't see relation with photo...

After, I think you call Join but I don't see the relation you made with the photo...

$query = $em->createQuery(
'SELECT p
  FROM AppBundle:Photo p       
     JOIN p.user u
       WHERE u.id = :id ')->setParameter('id', $user->getId());

Here is a part of the official doc : Example:

Regular join of the address:

createQuery("SELECT u FROM User u JOIN u.address a WHERE a.city = 'Berlin'"); $users = $query->getResult();

Fetch join of the address:

createQuery("SELECT u, a FROM User u JOIN u.address a WHERE a.city = 'Berlin'"); $users = $query->getResult();

answered Nov 30, 2015 at 21:41

BENARD Patrick

31k16 gold badges104 silver badges109 bronze badges

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

2 Comments

Tigran Over a year ago

The task is: Get photos of THOSE users, to whom current user is following.

Tigran Over a year ago

So first of all i need to Join with Follower to get all followers then join Photo to get photos

Zorbaxis Bts Sio Slam · Accepted Answer · 2015-11-30 20:28:03Z

0

did yu try this?:

$query = $em->createQuery(
'SELECT p
  FROM AppBundle:Photo p       
     JOIN AppBundle:Follower f
     JOIN  AppBundle:User u
       WHERE u.id = :id
       AND f.follower_id = :id
       AND p.user_id = f.user_id' )->setParameter('id', $user->getId());

answered Nov 30, 2015 at 20:28

Zorbaxis Bts Sio Slam

414 bronze badges

2 Comments

Tigran Over a year ago

I did, i have almost same error - [Syntax Error] line 0, col 128: Error: Expected =, <, <=, <>, >, >=, !=, got 'u'

Zorbaxis Bts Sio Slam Over a year ago

try this: select p,f,u from etc etc ... ?

Collectives™ on Stack Overflow

Symfony DQL syntax error

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related