You'll also need to select "s.id" like the error message says: "The root class
of the query (alias s) must have at least one field selected." – but you also
might need to select "p.id", too.
Does that help?
Cheers, Daniel
On 16.11.2010, at 09:59, man mixi wrote:
> Hi, experts.
> I set up a simple relationship using sfGuardUserProfile.
> But it does not work properly.
>
> Remove 'p.name' from select method, In this case it works.
> Why?
> I do not understand the meaning of the error message.
>
> Please help me.
>
> ---
>
> ERROR MESSAGE
>> 500 | Internal Server Error | Doctrine_Query_Exception
>> The root class of the query (alias s) must have at least one field selected.
>
>
> #action.php
>
> $this->saless = Doctrine_Query::create()
> ->select('s.user_id as userid,p.name, sum(s.amount) as amount')
> ->from('Sales s')
> // ->where('s.created_at between ? and ?',array($start,$end))
> ->leftJoin('s.Profile p')
> ->groupBy('userid')
> ->execute();
>
> #schema.yml
> Sales:
> tableName: sales
> actAs: { Timestampable: ~ }
> columns:
> user_id:
> type: integer
> amount: integer
> relations:
> User:
> class: sfGuardUser
> foreign: id
> local: use_id
> type: many
> onDelete: cascade
> foreignType: many
> foreignAlias: Sales
> Profile:
> class: sfGuardUserProfile
> foreign: user_id
> local: user_id
> type: many
> onDelete: cascade
> foreignType: many
> foreignAlias: Sales
>
> sfGuardUserProfile:
> tableName: sf_guard_user_profile
> actAs: { Timestampable: ~ }
> columns:
> id: integer
> user_id:
> type: integer
> primary: true
> name: varchar(50)
> relations:
> User:
> class: sfGuardUser
> foreign: id
> local: user_id
> type: one
> onDelete: cascade
> foreignType: one
> foreignAlias: Profile
>
> --
> If you want to report a vulnerability issue on symfony, please send it to
> security at symfony-project.com
>
> You received this message because you are subscribed to the Google
> Groups "symfony users" group.
> To post to this group, send email to symfony-users@googlegroups.com
> To unsubscribe from this group, send email to
> symfony-users+unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/symfony-users?hl=en
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
