[Tickets #2419] NEW: Local SQL doesn't work (with fix)

[bugs@bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=2419
-----------------------------------------------------------------------
 Ticket             | 2419
 Created By         | erland at lewin.nu
 Summary            | Local SQL doesn't work (with fix)
 Queue              | Turba
 Version            | HEAD
 State              | Unconfirmed
 Priority           | 3. High
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


erland at lewin.nu (2005-08-10 02:38) wrote:

I just installed Turba h3-2.0.3 on Horde 3.0.2, configured to use my local
MySQL database.

I added a contact without problems, but the lists didn't show the contact,
just empty entries called 'D' and another single letter name.

I tracked it down the file turba/lib/Driver/sql.php and the section around
line 310:

                    $binds = Horde_SQL::buildClause($this->_db,
$vals['field'],\
 $vals['op'], $rhs, true);
                    $clause .= $binds[0];
                    $values = array_merge($values, $binds[1]);

Horde_SQL::buildClause returns a string, not an array. Changing the clause
line above to:

$clause .= $binds

and removing the "$values=..." line fixes the problem.

The bug was apparently introduced in CVS version 1.72 of the file on June
9.

Cheers!