Hi Alex,
Here is the code,
public function getEclassForStudent($eclassId, $studentId)
{
return $this->createQuery('e')
->where('e.id = ?', $eclassId)
->leftJoin('e.EclassStudent es WITH es.student_id = ? AND
es.status = ? ', array($studentId,
EclassStudentTable::STATUS_SUBSCRIBED))
->innerJoin('e.Mentor')
->fetchOne()
;
}
On Dec 7, 12:09 am, Alex Pilon <[email protected]> wrote:
> Can you show us the code that is being called that is generating this
> exception?
>
>
>
> On Mon, Dec 6, 2010 at 13:01, saichand <[email protected]> wrote:
> > Hi ,
>
> > I am using Operating System : centOs.
>
> > And using PHP Version - 5.2.9 , Mysql Version - 5.
>
> > Symfony Vertion - 1.4.1
>
> > Facing the following Exception in my project :
>
> > " 500 | Internal Server Error | Doctrine_Connection_Mysql_Exception
>
> > SQLSTATE[HY000]: General error: 2014 Cannot execute queries while
> > other unbuffered queries are active. Consider using
> > PDOStatement::fetchAll(). Alternatively, if your code is only ever
> > going to run against mysql, you may enable query buffering by setting
> > the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute. "
>
> > " Exception occured exception 'Doctrine_Connection_Mysql_Exception'
> > with message 'SQLSTATE[HY000]: General error: 2014 Cannot execute
> > queries while other unbuffered queries are active. Consider using
> > PDOStatement::fetchAll(). Alternatively, if your code is only ever
> > going to run against mysql, you may enable query buffering by setting
> > the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.. Failing Query:
> > "SELECT e.id AS e__id, e.start_date AS e__start_date, e.end_date AS
> > e__end_date FROM eclass e WHERE (e.id = 1)"' in /home/wwwgoque/inet/
> > lib/vendor/symfony/plugins/sfDoctrinePlugin/lib/vendor/doctrine/
> > Doctrine/Connection.php:1082 "
>
> > Is there any idea how to fix this.
> > thanks in advance
>
> > --
> > 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
> > [email protected]
> > To unsubscribe from this group, send email
> > to>[email protected]<symfony-users%[email protected]>
> > For more options, visit this group at
> >http://groups.google.com/group/symfony-users?hl=en
>
> --
> Alex Pilon
> (613) 608-1480
--
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
