Faq articles don't show
Hello, 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 Thank you in advance. blocked::http://www.esi.es/ -- Manuel Fernandez R&D Projects Area European Software Institute (ESI) Tecnalia - Technology Corporation Parque Tecnológico #204 E-48170 Zamudio, Bizkaia - Spain Tel.: +34-94 420 95 19 Fax: +34-94 420 94 20 E-mail: manuel[dot]fernandez[at]esi[dot]es mailto:joseba.laka@esi[dot]es URL: www.esi.es blocked::http://www.esi.es/ ********************************** DISCLAIMER ******************************* This message may contain confidential, proprietary or legally privileged information. If you are not the intended recipient of this message, please notify it to the sender and delete without resending or backing it, as it is legally prohibited. ********************************** AVISO LEGAL ****************************** Este mensaje puede contener información confidencial, en propiedad o legalmente protegida. Si usted no es el destinatario, le rogamos lo comunique al remitente y proceda a borrarlo, sin reenviarlo ni conservarlo, ya que su uso no autorizado está prohibido legalmente. ******************************************************************************
-----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-----
participants (2)
-
Manuel Fernandez -
Torsten Thau