就是这句代码报的错：
$q = doctrine_query::create()->from('fzanswerquestionresult r')->leftjoin('r.fzusers u on r.fb_id = u.user_id') ->groupby('r.fb_id')->where('r.is_delete = 0 and u.province = '.$province.' and r.end_time >= '.$starttime.' and r.end_time
500 | internal server error | doctrine_table_exceptionunknown relation alias fzusersstack trace at () in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\relation\parser.php line 237 ... return $this->getrelation($alias, false); } else { throw new doctrine_table_exception('unknown relation alias ' . $alias); } } at doctrine_relation_parser->getrelation('fzusers', ) in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\relation\parser.php line 235 ... at doctrine_relation_parser->getrelation('fzusers', 1) in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\table.php line 1001 ... at doctrine_table->getrelation('fzusers') in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\query.php line 1762 ... at doctrine_query->load('r.fzusers u on r.fb_id = u.user_id') in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\query\from.php line 88 ... at doctrine_query_from->parse('left join r.fzusers u on r.fb_id = u.user_id') in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\query\abstract.php line 2084 ... at doctrine_query_abstract->_processdqlquerypart('from', array('fzanswerquestionresult r', 'left join r.fzusers u on r.fb_id = u.user_id')) in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\query.php line 1183 ... at doctrine_query->buildsqlquery() in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\query.php line 1149 ... at doctrine_query->getsqlquery(array(), ) in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\query.php line 2042 ... at doctrine_query->getcountsqlquery() in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\query.php line 2132 ... at doctrine_query->count() in sf_root_dir\lib\model\doctrine\fzanswerquestionresult.class.php line 400 ... at fzanswerquestionresult->getfbthisissueusernumbyprovince('北京', 1388332800, 1397475117) in sf_root_dir\apps\frontend\modules\exam\actions\actions.class.php line 1313 ... at examactions->executefbexamprovincerank(object('sfwebrequest')) in sf_root_dir\lib\symfony\lib\action\sfactions.class.php line 60 ... } // run action return $this->$actiontorun($request); } } at sfactions->execute(object('sfwebrequest')) in sf_root_dir\lib\symfony\lib\filter\sfexecutionfilter.class.php line 92 ... at sfexecutionfilter->executeaction(object('examactions')) in sf_root_dir\lib\symfony\lib\filter\sfexecutionfilter.class.php line 78 ... at sfexecutionfilter->handleaction(object('sffilterchain'), object('examactions')) in sf_root_dir\lib\symfony\lib\filter\sfexecutionfilter.class.php line 53 ... at sfexecutionfilter->execute(object('sffilterchain')) in sf_root_dir\lib\symfony\lib\filter\sffilterchain.class.php line 53 ... at sffilterchain->execute() in sf_root_dir\lib\symfony\lib\filter\sfrenderingfilter.class.php line 33 ... at sfrenderingfilter->execute(object('sffilterchain')) in sf_root_dir\lib\symfony\lib\filter\sffilterchain.class.php line 53 ... at sffilterchain->execute() in sf_root_dir\lib\symfony\lib\controller\sfcontroller.class.php line 238 ... at sfcontroller->forward('exam', 'fbexamprovincerank') in sf_root_dir\lib\symfony\lib\controller\sffrontwebcontroller.class.php line 48 ... at sffrontwebcontroller->dispatch() in sf_root_dir\lib\symfony\lib\util\sfcontext.class.php line 170 ... at sfcontext->dispatch() in sf_root_dir\web\index.php line 7 ...symfony settings ...request ...response ...user ...global vars ...symfony v.1.4.17 - php 5.2.6for help resolving this issue, please visit http://www.symfony-project.org/.
回复内容：
就是这句代码报的错：
$q = doctrine_query::create()->from('fzanswerquestionresult r')->leftjoin('r.fzusers u on r.fb_id = u.user_id') ->groupby('r.fb_id')->where('r.is_delete = 0 and u.province = '.$province.' and r.end_time >= '.$starttime.' and r.end_time
500 | internal server error | doctrine_table_exceptionunknown relation alias fzusersstack trace at () in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\relation\parser.php line 237 ... return $this->getrelation($alias, false); } else { throw new doctrine_table_exception('unknown relation alias ' . $alias); } } at doctrine_relation_parser->getrelation('fzusers', ) in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\relation\parser.php line 235 ... at doctrine_relation_parser->getrelation('fzusers', 1) in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\table.php line 1001 ... at doctrine_table->getrelation('fzusers') in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\query.php line 1762 ... at doctrine_query->load('r.fzusers u on r.fb_id = u.user_id') in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\query\from.php line 88 ... at doctrine_query_from->parse('left join r.fzusers u on r.fb_id = u.user_id') in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\query\abstract.php line 2084 ... at doctrine_query_abstract->_processdqlquerypart('from', array('fzanswerquestionresult r', 'left join r.fzusers u on r.fb_id = u.user_id')) in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\query.php line 1183 ... at doctrine_query->buildsqlquery() in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\query.php line 1149 ... at doctrine_query->getsqlquery(array(), ) in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\query.php line 2042 ... at doctrine_query->getcountsqlquery() in sf_root_dir\lib\symfony\lib\plugins\sfdoctrineplugin\lib\vendor\doctrine\doctrine\query.php line 2132 ... at doctrine_query->count() in sf_root_dir\lib\model\doctrine\fzanswerquestionresult.class.php line 400 ... at fzanswerquestionresult->getfbthisissueusernumbyprovince('北京', 1388332800, 1397475117) in sf_root_dir\apps\frontend\modules\exam\actions\actions.class.php line 1313 ... at examactions->executefbexamprovincerank(object('sfwebrequest')) in sf_root_dir\lib\symfony\lib\action\sfactions.class.php line 60 ... } // run action return $this->$actiontorun($request); } } at sfactions->execute(object('sfwebrequest')) in sf_root_dir\lib\symfony\lib\filter\sfexecutionfilter.class.php line 92 ... at sfexecutionfilter->executeaction(object('examactions')) in sf_root_dir\lib\symfony\lib\filter\sfexecutionfilter.class.php line 78 ... at sfexecutionfilter->handleaction(object('sffilterchain'), object('examactions')) in sf_root_dir\lib\symfony\lib\filter\sfexecutionfilter.class.php line 53 ... at sfexecutionfilter->execute(object('sffilterchain')) in sf_root_dir\lib\symfony\lib\filter\sffilterchain.class.php line 53 ... at sffilterchain->execute() in sf_root_dir\lib\symfony\lib\filter\sfrenderingfilter.class.php line 33 ... at sfrenderingfilter->execute(object('sffilterchain')) in sf_root_dir\lib\symfony\lib\filter\sffilterchain.class.php line 53 ... at sffilterchain->execute() in sf_root_dir\lib\symfony\lib\controller\sfcontroller.class.php line 238 ... at sfcontroller->forward('exam', 'fbexamprovincerank') in sf_root_dir\lib\symfony\lib\controller\sffrontwebcontroller.class.php line 48 ... at sffrontwebcontroller->dispatch() in sf_root_dir\lib\symfony\lib\util\sfcontext.class.php line 170 ... at sfcontext->dispatch() in sf_root_dir\web\index.php line 7 ...symfony settings ...request ...response ...user ...global vars ...symfony v.1.4.17 - php 5.2.6for help resolving this issue, please visit http://www.symfony-project.org/.
http://docs.doctrine-project.org/en/2.0.x/reference/query-builder.html
应该是这样的吧：
doctrine_query::create()->from('fzanswerquestionresult r')->leftjoin('r.fzusers', 'u')