hello all, I've been trying to upgrade to OTRS 2.0.3 from OTRS 1 without any success. Basically I have the following scenario: 1. I have a system running SuSE Linux 9.3. 2. I installed OTRS 2.0.3 3. I tarred and gzip'ed the OTRS 1.0 DB from the OTRS 1.0 machine 4. I copied the tarball to my system and untarred it into /var/lib/mysql/otrs 5. I ran the upgrade instructions from OTRS as specified in: http://cvs.otrs.org/viewcvs.cgi/otrs/UPGRADING?rev=1.16&content-type=text/vn... including running the DBUpdate-to-2.0.mysql.sql script I can start up OTRS, however, when I try to actually query the DB for anything (like tickets) I get the following error in my apache's error_log file... ERROR: OTRS-CGI-10 Perl: 5.8.6 OS: linux Time: Thu Nov 10 16:42:39 2005 Message: Unknown column 'gu.permission_key' in 'field list', SQL: 'SELECT g.id, g.name, gu.permission_key, gu.permission_value, gu.user_id FROM groups g, group_user gu WHERE g.valid_id in ( 1 ) AND g.id = gu.group_id AND gu.permission_value = 1 AND gu.permission_key IN ('ro', 'rw') AND gu.user_id = 1' Traceback (9236): Module: Kernel::System::Group::GroupGroupMemberList (v1.33) Line: 606 Module: Kernel::System::Group::GroupMemberList (v1.33) Line: 446 Module: Kernel::System::Ticket::TicketSearch (v1.187) Line: 2124 Module: Kernel::Modules::AgentTicketMailbox::Run (v1.4) Line: 190 Module: Kernel::System::Web::InterfaceAgent::Run (v1.8) Line: 651 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (v) Line: 48 Module: (eval) (v1.80) Line: 202 Module: ModPerl::RegistryCooker::run (v1.80) Line: 202 Module: ModPerl::RegistryCooker::default_handler (v1.80) Line: 168 Module: ModPerl::Registry::handler (v1.99) Line: 30 [Thu Nov 10 16:42:39 2005] -e: DBD::mysql::st fetchrow_array failed: fetch() without execute() at /opt/otrs//Kernel/System/DB.pm line 431. Can anyone tell me what's going on and how to fix this? Thanks, Braun Brelin