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.
ticket details are displayed except the issue messages itself
internal error when I created a new ticket.
can’t take ownership of one ticket
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.
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)
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.
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)
can’t take ownership of one ticket
Same result.
Error.
Could not change owner. Couldn’t add member to group
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
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.
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)
can’t take ownership of one ticket
Same result.
Error.
Could not change owner. Couldn’t add member to group
i can no longer log-in from old RT 3.0.5
But other users can.
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.