
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

On Thu, 2005-11-10 at 16:46 +0000, Braun Brelin wrote:
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
What about the updates from 1.0 -> 1.1, 1.1 -> 1.2 and 1.2 -> 1.3? Did you do those as well? I've recently been through the process of upgrading from 1.1 to 2.0.3, performing all those updates, and have not encountered any problems. Jim

I didn't go through the intermediate steps. The production system was
on 1.0 and
I downloaded 2.0.3 to the test machine.
Apparently, for some reason, the update script doesn't add the fields
permission_key and permission_value to the group_user table.
Braun Brelin
On 11/10/05, Jim Wight
On Thu, 2005-11-10 at 16:46 +0000, Braun Brelin wrote:
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
What about the updates from 1.0 -> 1.1, 1.1 -> 1.2 and 1.2 -> 1.3? Did you do those as well?
I've recently been through the process of upgrading from 1.1 to 2.0.3, performing all those updates, and have not encountered any problems.
Jim
_______________________________________________ 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 Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/

Hmm...
Was I supposed to run all of the db update scripts, i.e.
1.0->1.1->1.2->1.3->2.0?
If so, this should really be noted in the UPGRADING readme.
Braun
On 11/10/05, Braun Brelin
I didn't go through the intermediate steps. The production system was on 1.0 and I downloaded 2.0.3 to the test machine.
Apparently, for some reason, the update script doesn't add the fields permission_key and permission_value to the group_user table.
Braun Brelin
On 11/10/05, Jim Wight
wrote: On Thu, 2005-11-10 at 16:46 +0000, Braun Brelin wrote:
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
What about the updates from 1.0 -> 1.1, 1.1 -> 1.2 and 1.2 -> 1.3? Did you do those as well?
I've recently been through the process of upgrading from 1.1 to 2.0.3, performing all those updates, and have not encountered any problems.
Jim
_______________________________________________ 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 Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/

On Thu, 2005-11-10 at 17:08 +0000, Braun Brelin wrote:
Was I supposed to run all of the db update scripts, i.e. 1.0->1.1->1.2->1.3->2.0?
If so, this should really be noted in the UPGRADING readme.
I thought it was pretty well implied by 1.1's UPGRADING saying: These instructions are for people upgrading OTRS from "1.0" to "1.1". and 1.2's saying: These instructions are for people upgrading OTRS from "1.1" to "1.2". and so on. Jim

What about people who didn't upgrade from 1.0 to 1.[123]? What about
people who went directly from 1.0 to 2.0.3 and bypassed the entire 1.x
tree?
Braun
On 11/11/05, Jim Wight
On Thu, 2005-11-10 at 17:08 +0000, Braun Brelin wrote:
Was I supposed to run all of the db update scripts, i.e. 1.0->1.1->1.2->1.3->2.0?
If so, this should really be noted in the UPGRADING readme.
I thought it was pretty well implied by 1.1's UPGRADING saying:
These instructions are for people upgrading OTRS from "1.0" to "1.1".
and 1.2's saying:
These instructions are for people upgrading OTRS from "1.1" to "1.2".
and so on.
Jim
_______________________________________________ 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 Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/

On Fri, 2005-11-11 at 10:05 +0000, Braun Brelin wrote:
What about people who didn't upgrade from 1.0 to 1.[123]? What about people who went directly from 1.0 to 2.0.3 and bypassed the entire 1.x tree?
That was the position I was in, going from 1.1 to 2.0.3. The fact alone that 2.0.3's UPGRADING said: These instructions are for people upgrading OTRS from "1.3" to "2.0". gave me a big hint that I had better get to 1.3 first, and working backwards it soon became obvious that the others ought to be done too. Jim
participants (2)
-
Braun Brelin
-
Jim Wight