I think I'm all fixed up now. First, you have to take those four settings (ViewableLocks, State, etc) out of Config.pm and reset them in the SysConfig as Martin has mentioned. This solved all my SQL errors, but I was back to getting the "Need Ticket::ViewableStateType in Kernel/Config.pm!" primarily with my scripts running in cron (GenericAgent.pl, PendingJobs.pl, UnlockTickets.pl, etc).
I then ran the script bin/otrs.RebuildConfig.pl and everything worked again. Martin believes the DBUpgrade-2.4.pl script in 2.4.1 wasn't rebuilding some files properly (specifically the Kernel/Config/Files/ZZZAAuto.pm) and the RebuildConfig script resets this. DBUpgrade-2.4.pl appears to be fixed in 2.4.2, which is why a straight upgrade to that version worked properly. Many thanks to everyone! Ryan -----Original Message----- From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Martin Edenhofer Sent: Wednesday, July 29, 2009 7:53 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] upgrade problems with 2.4.1 Hi Andrew, thanks I got it. In your Kernel/Config.pm is the following: [...] $Self->{'Ticket::ViewableLocks'} = ['unlock', 'tmp_lock']; [...] Do you know why you added this? This is the problem. If you would remove it or "reset" it it will work again. Default is: [...] $Self->{'Ticket::ViewableLocks'} = [ "'unlock'", "'tmp_lock'" ]; [...] -Martin On Jul 30, 2009, at 01:32 , Glossop, Andrew wrote: > Done. Package sent to OTRS. > > Thanks for the youtube link. I didn't know there was anything on OTRS > there :) > > -----Original Message----- > From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf > Of > Martin Edenhofer > Sent: 29 July 2009 23:29 > To: User questions and discussions about OTRS. > Subject: Re: [otrs] upgrade problems with 2.4.1 > > http://www.youtube.com/watch?v=IVljPaMqFfY :-D > > Just add it to the bug report or send it to OTRS and give me the info > that you sent it. > > -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/ --------------------------------------------------------------------- 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/