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.
-------------------------------------------------------------------------------
participants (6)
-
Anton Gubar'kov
-
Craig Goodyer
-
Davide D'Onofrio
-
Dumont, Alexandre Jean Michel Pierre
-
francesco.simonini@sesaspa.it
-
Joshua McDowell