SQL typo in FAQSearch() in Kernel/System/FAQ.pm (FAQ-1.2.4)
Hi, line 1827 should be: 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. Felix
Hi Felix, thanks for your help! On Mo, Sep 24, 2007 at 02:07:36 +0200, Felix J. Ogris wrote:
line 1827 should be:
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 http://bugs.otrs.org for this issue please? Our developers watch the bugzilla and the report will not be lost.
Felix
Kind regards, Christian -- ((otrs)) :: OTRS GmbH :: Norsk-Data-Strasse 1 :: 61352 Bad Homburg Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Geschäftsführer: André Mindermann, Martin Edenhofer Handelsregister: HRB 9452 Bad Homburg Steuernummer: 003/240/97521
-----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-----
participants (3)
-
Christian Schoepplein -
Felix J. Ogris -
Torsten Thau