6.0.0-beta1
8/5/25

[#887] whups/lib/Driver/sql.php not getting listener list correctly
Summary whups/lib/Driver/sql.php not getting listener list correctly
Queue Whups
Type Bug
State Resolved
Priority 2. Medium
Owners chuck (at) horde (dot) org
Requester ctnpublic-horde (at) yahoo (dot) com
Created 11/24/2004 (7559 days ago)
Due
Updated 12/03/2004 (7550 days ago)
Assigned 11/25/2004 (7558 days ago)
Resolved 12/03/2004 (7550 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
12/03/2004 07:49:04 PM Chuck Hagenbuch Comment #2
State ⇒ Resolved
Reply to this comment
fix committed - thanks!
11/25/2004 03:25:43 PM Jan Schneider Assigned to Chuck Hagenbuch
State ⇒ Assigned
 
11/24/2004 05:06:57 PM ctnpublic-horde (at) yahoo (dot) com Comment #1
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ whups/lib/Driver/sql.php not getting listener list correctly
Queue ⇒ Whups
Reply to this comment
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'];


Saved Queries