Moving to a new server and upgrading from 3.0.5 to 3.4.5

hello guys,

I already spent some days already doing this.
My new system is running at Fedora 5 distro. and using the latest
Postgresql and Apache with mod_perl.

My old system is running at Redhat 9, Postgres 7.3.2, Apache 2.0.40 with
fastcgi installed.

What i did first, i successfully installed RT 3.4.5 in new system but I
tried first to connect to old postgres from old system so that I can still
retrieve our existing data. Here are some initial issues I found.

  1. ticket details are displayed except the issue messages itself
  2. internal error when I created a new ticket.
  3. can’t take ownership of one ticket
  4. i can no longer log-in from old RT 3.0.5

I tried to compare the new data structures with old one and changed
accordingly but still not working.

Hopefully, you can give some lights on what should I do.

Can you please post your errors for "2. internal error when I created a
new ticket. "

are they similar to the ones I posted on 4/18/2006 12:18 PM
[rt-users] rt-3.4.5 on Mandriva2006 - perl errors?? (method “new”)

rt3@acerhomes.com wrote:

Here is the error I got from error_log
[Wed Apr 19 06:21:03 2006] [crit]: Couldn’t create a ticket: Internal
Error: Found no sequence for Tickets
(/web/rt3/lib/RT/Ticket_Overlay.pm:590)
[Wed Apr 19 06:21:03 2006] [error]: WebRT: Ticket could not be created due
to an internal error () (/web/rt3/share/html/Elements/Error:78)

  1. ticket details are displayed except the issue messages itself
    This solved already. I restored RT3 database from Postgres 7.3.2 to 8.1.3.
    Then I followed database upgrade running all the etc/upgrade.
  1. internal error when I created a new ticket.
    Same result.
    Log Error
    Couldn’t create a ticket: Internal Error: Found no sequence for Tickets
    (/web/rt3/lib/RT/Ticket_Overlay.pm:590)
  1. can’t take ownership of one ticket
    Same result.
    Error.
    Could not change owner. Couldn’t add member to group
  1. i can no longer log-in from old RT 3.0.5
    But other users can.

Can you try upgrading to the latest DBIx::SearchBuilder from CPAN?
Best,
Jesse
This message was sent from my Treo. Please accept my apologies for its brevity and for any typos.From: rt3@acerhomes.com
Date: Wednesday, Apr 19, 2006 4:09 am
Subject: Re: [rt-users] Moving to a new server and upgrading from 3.0.5 to 3.4.5

  1. ticket details are displayed except the issue messages itself
    This solved already. I restored RT3 database from Postgres 7.3.2 to 8.1.3. Then I followed database upgrade running all the etc/upgrade.
  1. internal error when I created a new ticket.
    Same result.
    Log Error
    Couldn’t create a ticket: Internal Error: Found no sequence for Tickets
    (/web/rt3/lib/RT/Ticket_Overlay.pm:590)
  1. can’t take ownership of one ticket
    Same result.
    Error.
    Could not change owner. Couldn’t add member to group
  1. i can no longer log-in from old RT 3.0.5
    But other users can.

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media. Buy a copy at http://rtbook.bestpractical.com

We’re hiring! Come hack Perl for Best Practical: Careers — Best Practical Solutions

yes. This solve my problem for #2, 3#. Thanks to you and ruslan. Right
now, it seems something changed on Approval. Nothing is listed there. is
there changes from 3.0.5 to 3.4.5 approval system?

I stucked here. I think my only problem here is when I click the My
Approval link, nothing is displayed. But when I worked on individual
ticket such as resolving the ticket approval, the original request ticket
gets approved. I checked already the approval queue rights.

You’re right, Winn. I can’t run simultenously 3.0.5 and 3.4.5 using the
same database. I just reset the root password to go back to 3.0.5. On my
new system, upgrading the database solved #1 and upgrading the
DBIx::Searchbuilder solved my problem #2,3.

Right now, my problem is still on Approval link. Even I select pending,
approved, denied, etc, nothing is displayed. This works on 3.0.5. On
3.4.5, the approval ticket creation is working fine. But I still need the
My approval so that I can approve or denied in multiples instead of going
to individual ticket approving it by resolving the approval ticket.