Just wanted to let you guys know I'm having the exact same issue,
and I also just updated my 2.4.1 upgrade to 2.4.2 to see if it
resolved anything; still the same problem.
I have a whole slew of database errors in my SystemLog and can post
those if it'll help.
Ryan
-----Original Message-----
From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf
Of Glossop, Andrew
Sent: Wednesday, July 29, 2009 1:54 PM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] upgrade problems with 2.4.1
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'
