[pkg-horde] Bug#566610: horde3: Horde SQL cache cleanup fails due to DB error (malformed SQL)

[Kevin Easton]

Package: horde3
Version: 3.2.2+debian0-2+lenny2
Severity: normal
Tags: patch

Regular automated cleanup of expired entries in the Horde cache fails when 
using the SQL driver, due to a malformed SQL statement.  An error message is
logged to the Horde log file:

Jan 21 12:20:02 HORDE [error] [horde] DB Error: mismatch: DELETE FROM horde_cache WHERE cache_expiration <   AND cache_expiration  = 0 
[DB Error: mismatch] [pid 11943 on line 395 of "/usr/share/horde3/lib/Horde/Cache/sql.php"]

This bug has previously been reported and fixed upstream:

http://bugs.horde.org/ticket/7701

It is a one-liner patch to /var/share/horde3/lib/Horde/Cache/sql.php:

http://cvs.horde.org/diff.php/framework/Cache/Cache/sql.php?r1=1.12.2.9&r2=1.12.2.10&ty=u

(This also happens to be precisely the next revision of this source file after the
one in the current Debian stable package).

Could this fix please be backported for the next update to stable?

    - Kevin

-- System Information:
Debian Release: 5.0.3
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.26-2-686 (SMP w/1 CPU core)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages horde3 depends on:
ii  apache2            2.2.9-10+lenny6       Apache HTTP Server metapackage
ii  apache2-mpm-prefor 2.2.9-10+lenny6       Apache HTTP Server - traditional n
ii  libapache2-mod-php 5.2.6.dfsg.1-1+lenny4 server-side, HTML-embedded scripti
ii  libjs-scriptaculou 1.8.1-5               JavaScript library for dynamic web
ii  php-log            1.10.0-1              Log module for PEAR
ii  php-mail           1.1.14-1+lenny1       PHP PEAR module for sending email
ii  php-mail-mime      1.5.2-0.1             PHP PEAR module for creating MIME 
ii  php5-gd            5.2.6.dfsg.1-1+lenny4 GD module for php5
ii  php5-mcrypt        5.2.6.dfsg.1-1+lenny4 MCrypt module for php5

Versions of packages horde3 recommends:
ii  fckeditor          1:2.6.2-1lenny1       rich text format javascript web ed
ii  locales            2.7-18lenny2          GNU C Library: National Language (
ii  logrotate          3.7.1-5               Log rotation utility
ii  php-date           1.4.7-1               PHP PEAR module for date and time 
ii  php-db             1.7.13-2              PHP PEAR Database Abstraction Laye
ii  php-file           1.3.0-1               PHP Pear modules for common file a
ii  php-services-weath 1.4.2-2               acts as an interface to various on
ii  php5-cli           5.2.6.dfsg.1-1+lenny4 command-line interpreter for the p
ii  php5-mysql         5.2.6.dfsg.1-1+lenny4 MySQL module for php5
ii  php5-pgsql         5.2.6.dfsg.1-1+lenny4 PostgreSQL module for php5
ii  tinymce2           2.1.3-1               platform independent web based Jav

Versions of packages horde3 suggests:
pn  chora2               <none>              (no description available)
pn  enscript             <none>              (no description available)
pn  gettext              <none>              (no description available)
pn  gollem               <none>              (no description available)
ii  imp4                 4.2-4               webmail component for horde framew
pn  kronolith2           <none>              (no description available)
ii  libgeoip1            1.4.4.dfsg-3+lenny1 A non-DNS IP-to-country resolver l
pn  libwpd-tools         <none>              (no description available)
pn  mnemo2               <none>              (no description available)
pn  php-net-imap         <none>              (no description available)
pn  php5-auth-pam        <none>              (no description available)
pn  php5-mhash           <none>              (no description available)
pn  ppthtml              <none>              (no description available)
pn  rpm                  <none>              (no description available)
pn  source-highlight     <none>              (no description available)
ii  turba2               2.2.1-2             contact management component for h
pn  unrtf                <none>              (no description available)
pn  webcpp               <none>              (no description available)
pn  wv                   <none>              (no description available)
pn  xlhtml               <none>              (no description available)

-- no debconf information