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
From: [EMAIL PROTECTED]
To: [email protected]
Date: Thu, 2 Oct 2008 16:16:31 +0100
Subject: [otrs] Unable to edit Services/SLAs after upgrade OTRS 2.3.1b3 ->
2.3.2 + ITSM 1.2
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
:)
Regards
Craig
Try Facebook in Windows Live Messenger! Try it Now!
_________________________________________________________________
Discover Bird's Eye View now with Multimap from Live Search
http://clk.atdmt.com/UKM/go/111354026/direct/01/
_______________________________________________
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
