I am on a new install of otrs-2.1.2-01.i386.rpm with postgres on SUSE 10.1., FAQ Module version 1.08. I have some problems with the FAQ version: When I try to create a category following error apears: Message: ERROR: invalid input syntax for integer: "" , SQL: 'INSERT INTO faq_category (name, parent_id, comments, created, created_by, changed, changed_by) VALUES ('test', '', 'test', current_timestamp, 2, current_timestamp, 2)' Similar error here, versión 1.0.8 of the FAQ module with otrs-2.1.2-01.i386.rpm on SUSE 10 Traceback (22625): Module: Kernel::System::FAQ::CategoryAdd (v1.3) Line: 1227 Module: Kernel::Modules::AgentFAQ::Run (v1.6) Line: 460 Module: Kernel::System::Web::InterfaceAgent::Run (v1.14) Line: 666 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (v) Line: 47 Module: (eval) (v1.81) Line: 203 Module: ModPerl::RegistryCooker::run (v1.81) Line: 203 Module: ModPerl::RegistryCooker::default_handler (v1.81) Line: 169 Module: ModPerl::Registry::handler (v1.99) Line: 30 (http://bugs.otrs.org/show_bug.cgi?id=1372) As a workaround I created a category directly in the database. Now I am able to create subcategories and FAQ entries. But I cant see them. Apache logs show: [Thu Oct 19 11:11:05 2006] -e: DBD::Pg::st fetchrow_array failed: no statement executing [Thu Oct 19 11:11:05 2006] -e: DBD::Pg::st execute failed: ERROR: syntax error at or near "votes" at character 33 ERROR: OTRS-CGI-01 Perl: 5.8.8 OS: linux Time: Thu Oct 19 11:11:05 2006 Message: ERROR: syntax error at or near "votes" at character 33 , 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 (1)) 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.changed DESC LIMIT 3' Traceback (27130): Module: Kernel::System::FAQ::FAQSearch (v1.3) Line: 1940 Module: Kernel::Modules::FAQ::_GetExplorerLastCreateItems (v1.3) Line: 384 Module: Kernel::Modules::FAQ::GetExplorer (v1.3) Line: 168 Module: Kernel::Modules::AgentFAQ::Run (v1.6) Line: 875 Module: Kernel::System::Web::InterfaceAgent::Run (v1.14) Line: 666 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (v) Line: 47 Module: (eval) (v1.81) Line: 203 Module: ModPerl::RegistryCooker::run (v1.81) Line: 203 Module: ModPerl::RegistryCooker::default_handler (v1.81) Line: 169 Module: ModPerl::Registry::handler (v1.99) Line: 30 [Thu Oct 19 11:11:05 2006] -e: DBD::Pg::st fetchrow_array failed: no statement executing I tried downgrading to FAQ 1.0.6 but the result was exactly the same. Any help is appreciated. -- Dirk Enrique Seiffert - Lintec S.A. Ed. Torre del Reloj - Of. 401 Plaza de los Coches, Centro Cartagena - Colombia http://www.lintecsa.com -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio. http://www.lintecsa.com