I have got error message in otrs log:
SELECT i.id, count( v.item_id ) votes, avg( v.rate ) result FROM faq_item i LEFT JOIN faq_voting v ON v.item_id = i.id LEFT JOIN faq_state s ON s.id = i.state_id WHERE ( LOWER(i.f_subject) LIKE LOWER('%') OR LOWER(i.f_field1) LIKE LOWER('%') OR LOWER(i.f_field2) LIKE LOWER('%') OR LOWER(i.f_field3) LIKE LOWER('%') OR LOWER(i.f_field4) LIKE LOWER('%') OR LOWER(i.f_field5) LIKE LOWER('%') OR LOWER(i.f_field6) LIKE LOWER('%') ) AND (i.category_id IN (0)) AND s.type_id IN (1,3,2) GROUP BY i.id, i.f_subject, i.f_language_id, i.created, i.changed, s.name, v.item_id ORDER BY i.f_subject ASC LIMIT 300
[Fri Jan 5 13:51:26 2007][Error][Kernel::System::FAQ::FAQSearch][1918] ERROR: syntax error at or near "votes" at character 33
I answer my trouble, there are two mistake in this query, in the FAQ.pm if you use PostreSQL database engine:: Wrong: ...SELECT i.id, count( v.item_id ) votes, avg( v.rate ) result... Correct: ...SELECT i.id, count( v.item_id ) as votes, avg( v.rate ) as result... -- Valkai Jozsef +36 70 36 28 147 valkaij@externet.hu jvalkai@gmail.com lat:N 47° lon:E 19°