[Tickets #10383] Re: SQL error in duplicate search

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/10383
------------------------------------------------------------------------------
  Ticket             | 10383
  Updated By         | thpo+horde at dotrc.de
  Summary            | SQL error in duplicate search
  Queue              | Turba
  Version            | 3.0.4
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


thpo+horde at dotrc.de (2011-08-03 13:40) wrote:

I had a quick look into it. The following patch resolves the problem  
(at least for me).

--- turba/lib/Driver/Sql.php    2011-08-03 15:39:05.242893493 +0200
+++ /tmp/10383.php      2011-08-03 15:38:56.482904733 +0200
@@ -257,7 +257,7 @@
              $nameFormat = 'first_last';
          }

-        $order = $this->_buildFields($fields);
+        //$order = $this->_buildFields($fields);
          $joins = $this->_buildJoin($fields);
          $where = $this->_buildWhere($fields);

@@ -274,7 +274,8 @@
                               $this->map['__owner'],
                               $this->map['__owner'],
                               $where[$i],
-                             $order[$i]);
+                             $this->map['__key']);
+                             //$order[$i]);

              /* Run query. */
              try {