[Tickets #887] NEW: whups/lib/Driver/sql.php not getting listener list correctly

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=887
-----------------------------------------------------------------------
 Ticket     | 887
 Created By | ctnpublic-horde at yahoo.com
 Summary    | whups/lib/Driver/sql.php not getting listener list correctly
 Queue      | Whups
 State      | Unconfirmed
 Priority   | 2. Medium
 Type       | Bug
 Owners     | 
-----------------------------------------------------------------------


ctnpublic-horde at yahoo.com (2004-11-24 09:06) wrote:

I understand from the outstanding tickets that you're working on significant
enhancements to whup's listener management. 

Meanwhile, we're manually registering listeners via
whups_tickets_listeners.

But whups/lib/Driver/sql.php needs to retrieve this list of user_uids into
an array, not array of arrays, viz.

diff -u -r1.200 sql.php
--- whups/lib/Driver/sql.php    23 Oct 2004 13:36:20 -0000      1.200
+++ whups/lib/Driver/sql.php    24 Nov 2004 17:05:49 -0000
@@ -1659,7 +1659,7 @@
         $where = "(l.ticket_id = $ticket)";
         $query = "SELECT DISTINCT l.user_uid FROM $tables WHERE $where";
         Horde::logMessage('SQL Query by Whups_Driver_sql::getListeners(): '
. $query, __FILE__, __LINE__, PEAR_LOG_DEBUG);
-        $users = $this->_db->getAll($query, null, DB_FETCHMODE_ASSOC);
+        $users = $this->_db->getCol($query);

         $tinfo = $this->getTicketDetails($ticket);
         $requester = $tinfo['user_id_requester'];