[Gemstracker-svn] SF.net SVN: gemstracker:[14] trunk/library/classes/Gems/Tracker/Source/ LimeSurvey1m9Database.php

[<gem...@li...>]

Revision: 14
          http://gemstracker.svn.sourceforge.net/gemstracker/?rev=14&view=rev
Author:   matijsdejong
Date:     2011-09-15 09:47:09 +0000 (Thu, 15 Sep 2011)
Log Message:
-----------
- try catch statements to prevent hanging errors when a survey is no longer active.

Modified Paths:
--------------
    trunk/library/classes/Gems/Tracker/Source/LimeSurvey1m9Database.php

Modified: trunk/library/classes/Gems/Tracker/Source/LimeSurvey1m9Database.php
===================================================================
--- trunk/library/classes/Gems/Tracker/Source/LimeSurvey1m9Database.php	2011-09-14 17:45:40 UTC (rev 13)
+++ trunk/library/classes/Gems/Tracker/Source/LimeSurvey1m9Database.php	2011-09-15 09:47:09 UTC (rev 14)
@@ -540,7 +540,12 @@
         $lsTab  = $this->_getSurveyTableName($sourceSurveyId);
         $token  = $this->_getToken($tokenId);
 
-        $values = $lsDb->fetchRow("SELECT * FROM $lsTab WHERE token = ?", $token);
+        try {
+            $values = $lsDb->fetchRow("SELECT * FROM $lsTab WHERE token = ?", $token);
+        } catch (Zend_Db_Statement_Exception $exception) {
+            $this->logger->logError($exception, $this->request);
+            $values = false;
+        }
 
         if ($values) {
             return $this->_getFieldMap($sourceSurveyId)->mapKeysToTitles($values);
@@ -708,8 +713,14 @@
             $sql = 'SELECT *
                 FROM ' . $lsTokens . '
                 WHERE token = ? LIMIT 1';
-            $result = $this->getSourceDatabase()->fetchRow($sql, $tokenId);
 
+            try {
+                $result = $this->getSourceDatabase()->fetchRow($sql, $tokenId);
+            } catch (Zend_Db_Statement_Exception $exception) {
+                $this->logger->logError($exception, $this->request);
+                $result = false;
+            }
+
             $token->cacheSet(self::CACHE_TOKEN_INFO, $result);
         } else {
             $result = $token->cacheGet(self::CACHE_TOKEN_INFO);

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.