[Gemstracker-svn] SF.net SVN: gemstracker:[296] trunk/library/classes/Gems/Util/DbLookup.php

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

Revision: 296
          http://gemstracker.svn.sourceforge.net/gemstracker/?rev=296&view=rev
Author:   michieltcs
Date:     2011-11-28 11:55:18 +0000 (Mon, 28 Nov 2011)
Log Message:
-----------
Return all organizations if gor_has_login column does not (yet) exist

Modified Paths:
--------------
    trunk/library/classes/Gems/Util/DbLookup.php

Modified: trunk/library/classes/Gems/Util/DbLookup.php
===================================================================
--- trunk/library/classes/Gems/Util/DbLookup.php	2011-11-28 11:37:20 UTC (rev 295)
+++ trunk/library/classes/Gems/Util/DbLookup.php	2011-11-28 11:55:18 UTC (rev 296)
@@ -224,7 +224,11 @@
         static $organizations;
 
         if (! $organizations) {
-            $organizations = $this->db->fetchPairs('SELECT gor_id_organization, gor_name FROM gems__organizations WHERE gor_active=1 AND gor_has_login=1 ORDER BY gor_name');
+            try {
+                $organizations = $this->db->fetchPairs('SELECT gor_id_organization, gor_name FROM gems__organizations WHERE gor_active=1 AND gor_has_login=1 ORDER BY gor_name');
+            } catch (Exception $e) {
+                $organizations = $this->db->fetchPairs('SELECT gor_id_organization, gor_name FROM gems__organizations WHERE gor_active=1 ORDER BY gor_name');
+            }
             natsort($organizations);
         }
 

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