-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Christian Schoepplein schrieb:
my $SQL = "SELECT i.id, count( v.item_id ) AS votes, avg( v.rate ) AS result".
instead of:
my $SQL = "SELECT i.id, count( v.item_id ) votes, avg( v.rate ) result".
At least PostgreSQL will complain, otherwise.
Can you open a bug report on
for this issue please? Our developers watch the bugzilla and the report will not be lost.
the bug and the workaround is already known: http://bugs.otrs.org/show_bug.cgi?id=1421 (and some duplicates) regards, Torsten - -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFG+MdOvXo8m5PgoXQRAioTAJ4sbqbdNV8ELuqLX+0xkKg5x4KR4ACcDBPa CoEsp3ksaTrd+TOkG34+vIE= =z7aA -----END PGP SIGNATURE-----