Package: dbmail
Version: 2.2.9-1
Severity: important
Tags: patch
-- System Information:
Debian Release: lenny/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.18-4-xen-vserver-amd64 (SMP w/1 CPU core)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/bash
Versions of packages dbmail depends on:
ii adduser 3.106 add and remove users and groups
ii debconf [debconf-2.0] 1.5.19 Debian configuration management sy
ii libc6 2.7-6 GNU C Library: Shared libraries
ii libglib2.0-0 2.14.6-1 The GLib library of C routines
ii libgmime-2.0-2 2.2.17-1 MIME library
ii libldap-2.4-2 2.4.7-5 OpenLDAP libraries
ii libsieve2-1 2.2.3-1 a library for parsing, sorting and
ii libsqlite3-0 3.5.6-3 SQLite 3 shared library
ii ucf 3.005 Update Configuration File: preserv
ii zlib1g 1:1.2.3.3.dfsg-11 compression library - runtime
dbmail recommends no packages.
-- debconf information excluded
Typical Error Message :
Mar 16 23:52:35 vserver1.local dbmail-users[7120]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT alias FROM dbmail_aliases WHERE
deliver_to = 5 ORDER BY alias DESC] : [ERROR: operator does not exist:
character
varying = integer
LINE 1: SELECT alias FROM dbmail_aliases WHERE deliver_to = 5 ORDER ...
^
HINT: No operator matches the given name and argument type(s). You might need
to
add explicit type casts.
]
The attached Patch fixes the issue - and allows dbmail-2.2.9-1 to work
flawlessly.
