[Webapps-common-packages] Bug#410805: bugzilla: collectstats.pl fails on PostgreSQL

[Mathias Behrle]

Package: bugzilla
Version: 2.22.1-2
Severity: normal

Running collectstats.pl on a PostgtreSQL instance returns multiple rrors
like:
2007-02-13 13:11:53 CET bugzilla_fl ERROR:  syntax error at end of input
at character 228
... WHERE ((bugs.resolution IN ('FIXED'))) AND bugs.creation_ts IS NOT NULL
AND ((bug_group_map.group_id IS NULL)) GROUP BY bugs.bug_id,

All SQL statements finish with , instead of ;

This evtl. could be due to the heavy use of deprecated functions SendSQL
resp. FetchSQLData .


-- System Information:
Debian Release: 3.1
  APT prefers testing
  APT policy: (400, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.8-6-evms-dm-static-initrd
Locale: LANG=C, LC_CTYPE=de_DE.utf-8 (charmap=UTF-8)

Versions of packages bugzilla depends on:
ii  apache2                  2.0.54-5sarge1  next generation, scalable, extenda
ii  apache2-mpm-prefork [htt 2.0.54-5sarge1  traditional model for Apache2
ii  dbconfig-common          1.8.29~bpo.1    common framework for packaging dat
ii  debconf [debconf-2.0]    1.4.30.13       Debian configuration management sy
ii  libappconfig-perl        1.56-2          Perl module for configuration file
ii  libdbd-mysql-perl        2.9006-1        A Perl5 database interface to the 
ii  libmailtools-perl        1.74-1          Manipulate email in perl programs
ii  libmime-perl             5.417-1         Perl5 modules for MIME-compliant m
ii  libtemplate-perl         2.14-1          template processing system written
ii  libtimedate-perl         1.1600-4        Time and date functions for Perl
ii  mysql-client             4.0.24-10sarge2 mysql database client binaries
ii  patch                    2.5.9-2         Apply a diff file to an original
ii  postfix [mail-transport- 2.3.6-1~bpo.1   A high-performance mail transport 
ii  ucf                      1.17            Update Configuration File: preserv

-- debconf information excluded