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
_______________________________________________
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/
