I'm not a perl programmer, so I need some help to debug this please. The error I'm getting is to do with this function in Kernel/Modules/AgentTicketQueue.pm
sub _MaskQueueView { my ( $Self, %Param ) = @_; my $QueueID = $Param{QueueID} || 0; my @QueuesNew = @{ $Param{Queues} }; my $QueueIDOfMaxAge = $Param{QueueIDOfMaxAge} || -1; my %AllQueues = %{ $Param{AllQueues} }; my %Counter = (); my %UsedQueue = (); my @ListedQueues = (); my $Level = 0; my $CustomQueue = $Self->{LayoutObject}->{LanguageObject}->Get( $Self->{CustomQueue} ); $Self->{HighlightAge1} = $Self->{Config}->{HighlightAge1}; $Self->{HighlightAge2} = $Self->{Config}->{HighlightAge2}; $Self->{HighlightColor1} = $Self->{Config}->{HighlightColor1}; $Self->{HighlightColor2} = $Self->{Config}->{HighlightColor2}; $Self->{Blink} = $Self->{Config}->{Blink}; The line that gives an error is: my @QueuesNew = @{ $Param{Queues} }; The error is Can't use an undefined value as an ARRAY reference at D:/OTRS/otrs//Kernel/Modules/AgentTicketQueue.pm line 237. Is this a database problem? Is it a permissions problem? Is it something else? I'm happy to dig about and try to understand what is wrong, but at the moment I don't know what the error is. The log gives these errors, so it look slike a database issue [Wed Jul 29 18:50:01 2009][Error][Kernel::System::Lock::LockViewableLock][135] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unlock, tmp_lock ) AND valid_id IN ( 1 )' at line 1, SQL: 'SELECT id, name FROM ticket_lock_type WHERE name IN ( unlock, tmp_lock ) AND valid_id IN ( 1 )' [Wed Jul 29 18:50:01 2009][Error][Kernel::System::Ticket::IndexAccelerator::RuntimeDB::GetLoc kedCount][208] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ti.user_id = '2' AND ar.ticket_id = ti.id AND ts.id = ti.ticket_state_i' at line 1, SQL: 'SELECT ar.id, ar.article_sender_type_id, ti.id, ar.create_by, ti.create_time_unix, ti.until_time, tst.name, ar.article_type_id FROM ticket ti, article ar, ticket_state ts, ticket_state_type tst WHERE ti.ticket_lock_id NOT IN ( ) AND ti.user_id = ? AND ar.ticket_id = ti.id AND ts.id = ti.ticket_state_id AND ts.type_id = tst.id ORDER BY ar.create_time DESC' [Wed Jul 29 18:50:01 2009][Error][Kernel::System::Lock::LockViewableLock][135] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unlock, tmp_lock ) AND valid_id IN ( 1 )' at line 1, SQL: 'SELECT id, name FROM ticket_lock_type WHERE name IN ( unlock, tmp_lock ) AND valid_id IN ( 1 )' [Wed Jul 29 18:50:01 2009][Error][Kernel::System::Ticket::TicketSearch][3599] The given param 'LockIDs' is invalid or an empty array reference! [Wed Jul 29 18:50:01 2009][Error][Kernel::System::Lock::LockViewableLock][135] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unlock, tmp_lock ) AND valid_id IN ( 1 )' at line 1, SQL: 'SELECT id, name FROM ticket_lock_type WHERE name IN ( unlock, tmp_lock ) AND valid_id IN ( 1 )' [Wed Jul 29 18:50:01 2009][Error][Kernel::System::Ticket::IndexAccelerator::RuntimeDB::Ticket AcceleratorIndex][124] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND st.queue_id = sq.id AND suq.queue_id = st.queue_id AND sq.group_id IN (' at line 1, SQL: 'SELECT count(*) FROM ticket st, queue sq, personal_queues suq WHERE st.ticket_state_id IN ( 1, 4, 6, 7, 8 ) AND st.ticket_lock_id IN ( ) AND st.queue_id = sq.id AND suq.queue_id = st.queue_id AND sq.group_id IN ( 1, 3, 2, 4, 5, 6, 7, 6 ) AND suq.user_id = 2' [Wed Jul 29 18:50:01 2009][Error][Kernel::System::Ticket::IndexAccelerator::RuntimeDB::Ticket AcceleratorIndex][150] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND st.queue_id = sq.id AND sq.group_id IN ( 1, 3, 2, 4, 5, 6, 7, 6 ) GROUP' at line 1, SQL: 'SELECT st.queue_id, sq.name, min(st.create_time_unix), count(*) FROM ticket st, queue sq WHERE st.ticket_state_id IN ( 1, 4, 6, 7, 8 ) AND st.ticket_lock_id IN ( ) AND st.queue_id = sq.id AND sq.group_id IN ( 1, 3, 2, 4, 5, 6, 7, 6 ) GROUP BY st.queue_id,sq.name ORDER BY sq.name' -----Original Message----- From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Martin Edenhofer Sent: 28 July 2009 11:32 To: User questions and discussions about OTRS. Subject: Re: [otrs] upgrade problems with 2.4.1 Hi Andrew, ok, the error regarding column 'state_notify' are normal, because on this system the Upgrade* scripts already used for this database? Can you try the new "scripts/DBUpdate-to-2.4.pl" on a initial upgrade (database where no Upgrade* scripts has been used)? Thx! -Martin --------------------------------------------------------------------- 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/