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/
