If it'll help I can provide you a login, Martin, just need a place to send you the info. I have the support and system packages installed so you can check those out too, up to you, thanks.
My next step was to setup a fresh database from a 2.4.2 install and compare schemas to production because it seems like something is mixed up there. Ryan -----Original Message----- From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Martin Edenhofer Sent: Wednesday, July 29, 2009 6:12 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] upgrade problems with 2.4.1 Ryan, Andrew, there is also a bug report regarding this issue. http://bugs.otrs.org/show_bug.cgi?id=3856 I be not able to reproduce this. Is it possible to get remote login? Or other way, can you provide a Support-Package? -Martin On Jul 29, 2009, at 22:21 , Ryan Rosiek wrote: > 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' > --------------------------------------------------------------------- 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/ --------------------------------------------------------------------- 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/
