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