-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi there, Manuel Fernandez schrieb:
I have some trouble with the faq module. I can add and edit articles, but only it is showing the articles in the history screen.
If I search any article, even using the id, the system doesn't show anything.
where is the problem?
My system:
OTRS 2.1.7 FAQ 1.0.18
...do you use PostgreSQL (or any non-mysql DBMS)? If so this is probably the reason. There is a bug in Kernel::System::FAQ (which still exists in version 1.2.5). There are already a few bugzilla entries: http://bugs.otrs.org/show_bug.cgi?id=1421 http://bugs.otrs.org/show_bug.cgi?id=1775 http://bugs.otrs.org/show_bug.cgi?id=2324 However, this is what's wrong here... #current version... my $SQL = "SELECT i.id, count( v.item_id ) votes, avg( v.rate ) vrate". #version from FAQ-1.0.18 my $SQL = "SELECT i.id, count( v.item_id ) votes, avg( v.rate ) result" ...which is not proper SQL (but works in mySQL) - either you remove "votes"/"vrate"/"result" or you add an " AS ": #current version... my $SQL = "SELECT i.id, count( v.item_id ) AS votes, avg( v.rate ) AS vrate". #version from FAQ-1.0.18 my $SQL = "SELECT i.id, count( v.item_id ) AS votes, avg( v.rate ) AS result" regards, Torsten Thau - -- Torsten Thau, Dipl. Inform. c.a.p.e. IT GmbH - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 company pgp-key: 0x292F987D fax: +49 371 5347 625 http://www.cape-it.de AG Chemnitz - HRB 23192 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHoEIyvXo8m5PgoXQRAl+YAJ4zeyRitXcNwWh4YLDurDXZNrVT4ACeKZOR MnEDPpkqx+QkWBU9eh4AcKA= =MPYr -----END PGP SIGNATURE-----