Hmm, well I do not know what might be causing this error as I have never myself received an exception like this. Have you tried placing break points through out the code to isolate where exactly the code is failing? Are you able to run getEclassForStudent from a unit test and receive an expected result?
On Tue, Dec 7, 2010 at 10:04, saichand <[email protected]> wrote: > 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]> > <symfony-users%[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]<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
