Francesco,

Excellent, It must've been something ITSM 1.2 required, which wasn't satisfied in our upgrade.

Many thanks
Craig

---

> From: francesco.simonini@sesaspa.it
> To: itsm@otrs.org
> Date: Fri, 3 Oct 2008 09:04:03 +0100
> Subject: Re: [itsm] Unable to edit Services/SLAs after upgrade OTRS 2.3.1b3 -> 2.3.2 + ITSM 1.2
>
> I had the same problem.
> I solved it uninstalling all the ITSM modules and
> reinstalling them.
> Bye.
> Francesco.
>
> ----- Original Message -----
> Da : Craig Goodyer <craiggoodyer@hotmail.com>
> A : <itsm@otrs.org>
> Oggetto : [itsm] Unable to edit Services/SLAs after upgrade
> OTRS 2.3.1b3 -> 2.3.2 + ITSM 1.2
> Data : Fri, 3 Oct 2008 08:43:41 +0100
>
> > Hi All,
> >
> > I've been playing with setting up various services / sla's
> > and other config bits n bobs for a few days on OTRS
> > 2.3.1b3 + ITSM 1.1.2, then upgraded to OTRS 2.3.2 + ITSM
> > 1.2 On installing the ITSM packages (inc Service
> > Management etc) the Services I have setup are no longer
> > viewable in the web interface (however the services and
> > sla's still exist in the system as they are selectable
> > when 'Customer's create tickets), and I get the following
> > error when trying to view the SLA's configuration page:
> >
> >
> > "Software error:
> >
> > Can't use an undefined value as an ARRAY reference at
> > /opt/otrs//Kernel/Modules/AdminSLA.pm line 305.
> >
> > For help, please send mail to the webmaster ([no address
> > given]), giving this error message and the time and date
> > of the error."
> >
> >
> > Any help on getting back or removing the original
> > Services/SLA's would be great :)
> >
> > Looking further into this I can see the following errors
> > in the System Log:
> >
> > (When checking Service List):
> > Thu Oct 2 17:07:14 2008 error OTRS-CGI-10 No
> > such ServiceID (2)! Thu Oct 2 17:07:14 2008 error
> > OTRS-CGI-10 Unknown column 'type_id' in 'field list',
> > SQL: 'SELECT id, name, valid_id, comments, create_time,
> > create_by, change_time, change_by , type_id,
> > criticality_id FROM service WHERE id = ? LIMIT 1'
> >
> > (When checking SLA List):
> > Thu Oct 2 17:07:14 2008 error OTRS-CGI-10 No
> > such ServiceID (1)! Thu Oct 2 17:07:14 2008 error
> > OTRS-CGI-10 Unknown column 'type_id' in 'field list',
> > SQL: 'SELECT id, name, valid_id, comments, create_time,
> > create_by, change_time, change_by , type_id,
> > criticality_id FROM service WHERE id = ? LIMIT 1'
> >
> > i'm assuming then that the database schema needs modifying
> > to include "type_id" as a field in the service table? Are
> > any other changes likely to be required to the database?
> >
> > Regards
> > Craig
> > __________________________________________________________
> > _______ Make a mini you and download it into Windows Live
> > Messenger http://clk.atdmt.com/UKM/go/111354029/direct/01/
> >
> > _______________________________________________
> > OTRS mailing list: itsm - Webpage: http://otrs.org/
> > Archive: http://lists.otrs.org/pipermail/itsm
> > To unsubscribe:
> > http://lists.otrs.org/mailman/listinfo/itsm Support or
> > consulting for your OTRS::ITSM system? =>
> > http://www.otrs.com/
>
>
>
>
> Francesco Simonini
>
> Consultant
> S.E.S.A. S.p.A.
> Software E Sistemi Avanzati
>
> 20131 Milano Italy
> Via Teodosio, 65
> Tel. +39 02 4547 6444
> Fax. +39 02 4547 6475
> Mobile: +39 348 7411960
>
> E-mail: francesco.simonini@sesaspa.it
> Web: http://www.sesaspa.it
>
> -------------------------------------------------------------------------------
> This message is for the designated recipient only and may
> contain privileged or confidential information.
>
> If you have received it in error, please notify the sender
> immediately and delete the original.
> Any other use of the email is prohibited.
>
> -------------------------------------------------------------------------------
>
>
> _______________________________________________
> OTRS mailing list: itsm - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/itsm
> To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm
> Support or consulting for your OTRS::ITSM system?
> => http://www.otrs.com/

---

Get Hotmail on your mobile from Vodafone Try it Now!