Hi, Issue Solved :)
I upgraded PHP - 5.2.9 to 5.3.3 , MYSQL - 5.0.9 to 5.1.41 , PDO, PDO_MYSQL - 5.0.91 to 5.1.41 , and APACHE to 2.2.14 Solved my Problem. On Dec 7, 8:18 pm, Alex Pilon <[email protected]> wrote: > 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%2bunsubscr...@goog > > legroups.com> > > <symfony-users%[email protected]<symfony-users%252Bunsubscribe > > @googlegroups.com> > > > > > 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%2bunsubscr...@goog > > legroups.com> > > 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
