Re: [otrs] Illegal division by zero at ../..//Kernel/System/Ticket.pm line 1720.

8 Sep 2008

      Here is the piece of code that that error refers too..

# set notification if notfy % is reached
                if ( $Escalation{ $Map{$Key} . 'Notify' } ) {
                    my $Reached = 100
                        - ( $WorkingTime / ( $Escalation{ $Map{$Key} .
'Time' } * 60 / 100 ) );
                    if ( $Reached >= $Escalation{ $Map{$Key} . 'Notify' } )
{
                        $Data{ $Map{$Key} . 'TimeNotification' } = 1;
                    }

Also note that PostmasterMailbox.pl is now failing

DBD::Pg::st execute failed: ERROR:  syntax error at or near ")"
LINE 1: ... id, name FROM ticket_lock_type WHERE  name IN (  ) AND  val...
                                                             ^ at
/opt/otrs/Kernel/System/DB.pm line 561.
ERROR: OTRS-PMAccount-10 Perl: 5.8.6 OS: darwin Time: Mon Sep  8 13:56:02
2008

 Message: ERROR:  syntax error at or near ")"
LINE 1: ... id, name FROM ticket_lock_type WHERE  name IN (  ) AND  val...
                                                             ^, SQL: 'SELECT
id, name FROM ticket_lock_type WHERE  name IN (  ) AND  valid_id IN ( 1 )'

 Traceback (8629): 
   Module: Kernel::System::Lock::LockViewableLock (v1.23) Line: 122
   Module: Kernel::System::Ticket::new (v1.343) Line: 176
   Module: Kernel::System::PostMaster::new (v1.75) Line: 104
   Module: Kernel::System::MailAccount::POP3::Fetch (v1.4) Line: 141
   Module: Kernel::System::MailAccount::MailAccountFetch (v1.5) Line: 369
   Module: /opt/otrs/bin/PostMasterMailbox.pl (v1.2) Line: 135

Any help would be much appreciated

Thanks

On 08/09/08 1:45 PM, "Mik Rose"  wrote:
...
Everything was working then for no understandable reason
I am again getting an error when trying to view Queues
Software error:
Illegal division by zero at ../..//Kernel/System/Ticket.pm line 1720.
Mikola (Mik) Rose
PowerSoft Development Corp.
CIO, Information Technology / Support Services
Customer Service: 1 (250) 642-0199
Sales Dep.: 1 (888) 833-7697
Support Dep.: 1 (250) 642-0295
www.power-soft.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
Mikola (Mik) Rose
PowerSoft Development Corp.
CIO, Information Technology / Support Services
Customer Service: 1 (250) 642-0199
Sales Dep.: 1 (888) 833-7697
Support Dep.: 1 (250) 642-0295
www.power-soft.com