Hi, I have got error message in otrs log:
, SQL: '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 So, what does it mean? Its a fresh copy, vithout any data... -- Valkai Jozsef +36 70 36 28 147 [EMAIL PROTECTED] [EMAIL PROTECTED] lat:N 47° lon:E 19° _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? => http://www.otrs.com/