First of all hello to everyone here, I hope I can both help and get help with problems related to ITSM :)

I am currently running OTRS 2.2 beta4 and the latest rpm of ITSM for suse 10.0  My base OS is actually 10.2 opensuse.
I just installed the required apps and have been playing around with ITSM to see what it can do, before an official manual comes out.  It appears that when I installed ITSM it didn’t update the database correctly as per the error message below.  Is there anyway to verify that the database contains the proper tables and schema?

Over the weekend I will wipe the machine clean and try again but just as a general FYI… is there a command to verify that the schema and database are updated correctly with the ITSM install?

Thanks for you help and an excellent product.

Eric



Error: Table 'otrs.service' doesn't exist, SQL: 'INSERT INTO service (name, valid_id, c[..]
Comment:
Bug Report:
Traceback:      ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Fri Jun 15 12:53:50 2007

Message: Table 'otrs.service' doesn't exist, SQL: 'INSERT INTO service (name, valid_id, comments, create_time, create_by, change_time, change_by, type_id, criticality_id) VALUES ('test', 2, 'test', current_timestamp, 1, current_timestamp, 1, 13, 1)'

Traceback (3507):
   Module: Kernel::System::Service::ServiceAdd (v1.6) Line: 372
   Module: Kernel::Modules::AdminService::Run (v1.4) Line: 168
   Module: Kernel::System::Web::InterfaceAgent::Run (v1.22) Line: 670
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (v) Line: 47
   Module: (eval) (v1.81) Line: 203
   Module: ModPerl::RegistryCooker::run (v1.81) Line: 203
   Module: ModPerl::RegistryCooker::default_handler (v1.81) Line: 169
   Module: ModPerl::Registry::handler (v1.99) Line: 30l


_______________________________________________________________________

This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations.
Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized.
If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.  

Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent.
Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite.
Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.