
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: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] 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 root@localhost (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 :/ fguiliani@perinfo.com mailto:fguiliani@perinfo.com /Site Web :/ http://www.perinfo.com