
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: craiggoodyer@hotmail.com To: otrs@otrs.org 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/