Florent Guiliani a écrit :
All was working right but I don't know wky, from a couple a hours it's
don't work anymore :(
In adittion I've got errors from $HOME/bin/UnlockTickets.pl in
crontabs. The errors seems to come from "ticket_state_id".
I remember changing some parameters with SysConfig in Core::Ticket and
the problem appears juste after an aborted saving
(error cannot write parameters or something like)
DBD::Pg::st execute failed: ERROR: parser: parse error at or near ")" at character
219 at /home/otrs/Kernel/System/DB.pm line 440, <PRODUCT> line 4.
ERROR: OTRS-UnlockTickets-10 Perl: 5.8.0 OS: linux Time: Tue Jan 10 12:35:01
2006
Message: ERROR: parser: parse error at or near ")" at character 219, SQL:
'SELECT st.tn, st.ticket_answered, st.id, st.timeout, sq.unlock_timeout FROM ticket
st, queue sq WHERE st.queue_id = sq.id AND st.ticket_answered != 1 AND
sq.unlock_timeout != 0 AND st.ticket_state_id IN ( ) AND st.ticket_lock_id NOT IN (
1, 3 ) '
Traceback (23163):
Module: /home/otrs/bin/UnlockTickets.pl (v1.19) Line: 127
DBD::Pg::st fetchrow_array failed: no statement executing at
/home/otrs/Kernel/System/DB.pm line 477, <PRODUCT> line 4.
Thank you,
Michael W. Belz
Jr. Systems Administrator, Sky River Management
(702) 336-9418
AIM: SimbaSRM
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Florent Guiliani
Sent: Monday, January 09, 2006 9:04 AM
To: User questions and discussions about OTRS.org
Subject: Re: [otrs] No Permission!
And in /var/log/httpd/errors_log I've got:
ERROR: OTRS-CGI-10 Perl: 5.8.0 OS: linux Time: Mon Jan 9 18:03:03 2006
Message: Need module!
Traceback (32402):
Module: Kernel::System::Main::Require (v1.1) Line: 44
Module: Kernel::System::Ticket::Permission (v1.194) Line: 1499
Module: Kernel::Modules::AgentTicketZoom::Run (v1.14) Line: 85
Module: Kernel::System::Web::InterfaceAgent::Run (v1.8) Line: 651
Module:
ModPerl::ROOT::ModPerl::Registry::home_otrs_bin_cgi_2dbin_index_2epl::ha
ndler (v) Line: 48
Module: (eval) (v1.80) Line: 187
Module: ModPerl::RegistryCooker::run (v1.80) Line: 187
Module: ModPerl::RegistryCooker::default_handler (v1.80) Line: 159
Module: ModPerl::Registry::handler (v1.99) Line: 16
ERROR: OTRS-CGI-10 Perl: 5.8.0 OS: linux Time: Mon Jan 9 18:03:03 2006
Message: Module '' not found!
Traceback (32402):
Module: Kernel::System::Ticket::Permission (v1.194) Line: 1499
Module: Kernel::Modules::AgentTicketZoom::Run (v1.14) Line: 85
Module: Kernel::System::Web::InterfaceAgent::Run (v1.8) Line: 651
Module:
ModPerl::ROOT::ModPerl::Registry::home_otrs_bin_cgi_2dbin_index_2epl::ha
ndler (v) Line: 48
Module: (eval) (v1.80) Line: 187
Module: ModPerl::RegistryCooker::run (v1.80) Line: 187
Module: ModPerl::RegistryCooker::default_handler (v1.80) Line: 159
Module: ModPerl::Registry::handler (v1.99) Line: 16
ERROR: OTRS-CGI-10 Perl: 5.8.0 OS: linux Time: Mon Jan 9 18:03:03 2006
Message: Need module!
Traceback (32402):
Module: Kernel::System::Main::Require (v1.1) Line: 44
Module: Kernel::System::Ticket::Permission (v1.194) Line: 1499
Module: Kernel::Modules::AgentTicketZoom::Run (v1.14) Line: 85
Module: Kernel::System::Web::InterfaceAgent::Run (v1.8) Line: 651
Module:
ModPerl::ROOT::ModPerl::Registry::home_otrs_bin_cgi_2dbin_index_2epl::ha
ndler (v) Line: 48
Module: (eval) (v1.80) Line: 187
Module: ModPerl::RegistryCooker::run (v1.80) Line: 187
Module: ModPerl::RegistryCooker::default_handler (v1.80) Line: 159
Module: ModPerl::Registry::handler (v1.99) Line: 16
ERROR: OTRS-CGI-10 Perl: 5.8.0 OS: linux Time: Mon Jan 9 18:03:03 2006
Message: Module '' not found!
Traceback (32402):
Module: Kernel::System::Ticket::Permission (v1.194) Line: 1499
Module: Kernel::Modules::AgentTicketZoom::Run (v1.14) Line: 85
Module: Kernel::System::Web::InterfaceAgent::Run (v1.8) Line: 651
Module:
ModPerl::ROOT::ModPerl::Registry::home_otrs_bin_cgi_2dbin_index_2epl::ha
ndler (v) Line: 48
Module: (eval) (v1.80) Line: 187
Module: ModPerl::RegistryCooker::run (v1.80) Line: 187
Module: ModPerl::RegistryCooker::default_handler (v1.80) Line: 159
Module: ModPerl::Registry::handler (v1.99) Line: 16
Florent Guiliani a écrit :
Hi all,
I don't know what I've changed but when I click on 'Zoom' on a ticket
in the queue I've got "No Permission!"
even if I try with [EMAIL PROTECTED] (admin user)
What's wrong?
Florent,
_______________________________________________
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 oder Consulting f?r Ihr OTRS System?
=> http://www.otrs.de/
--
<http://www.perinfo.com> * Florent GUILIANI - Développement Système*
41, avenue Jean Jaurès - 67100 STRASBOURG
/Tel :/ 03.88.44.96.00 /- Fax :/ 03.88.44.96.29
/E-mail :/ [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
/Site Web :/ http://www.perinfo.com
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
