[rt-users] upgrade issue from 3.2.2 to 3.8.1

daksh daksh at olemiss.edu
Fri Jan 16 10:23:43 EST 2009


Hi, 
We upgrade RT 3.2.2 to 3.8.1, and have a small issue.
Server info:
openSuSE11
PERL - 5.10.0
mysql - 5.0.51a

When I click on Tickets link to search for tickets, under
"Owner" selection, I get hundreds of users. It seems like I
am getting all users who ever submitted tickets to us. I
have looked at global permissions, and it appears to be
correct. 

I ran "rt-validator --check"  and have noticed following
items: Please note, I am only listing unique entries. I get
thousands of this entries when I run "rt-validator --check".
------------------------------------
Name "RT::DatabaseType" used only once: possible typo at
/rt-validator line 133.

Record #3368 in Principals references not existent record in
Users
        id => '3368' => id

Record #40717 in Principals references not existent record
in Groups
        id => '40717' => id

Record #3369 in Groups references not existent record in
Users
        Instance => '3368' => id

Record #4160 in Groups references not existent record in
Queues
        Instance => '7' => id

Record #24988 in GroupMembers references not existent record
in Groups
        GroupId => '40717' => id

Record #86481 in CachedGroupMembers references not existent
record in Groups
        GroupId => '40717' => id
        MemberId => '40717' => id

Record #16076 in Tickets references not existent record in
Queues
        Queue => '7' => id

Record #20 in Transactions references not existent record in
Users
        OldValue => '5' => id
        Transaction #20 -> object RT::Ticket #4

Record #144 in Transactions references not existent record
in Queues
        NewValue => '' => id
        Transaction #144 -> object RT::Ticket #27

Record #6 in Attachments refers to ACL equivalence group #31
of user #30 when must reference user.

Record #1 in Attachments references not existent record in
Users
        Creator => '5' => id
        Attachment #1 -> Txn #1, Transaction #1 -> object
RT::Ticket #1

Record #682 in Users references not existent record in Users
        LastUpdatedBy => '4' => id
------------------------------------

Here is the upgrade process I followed (this is what I
noticed in RT-users emails just few days ago)
------------------------------------
 2) Follow instructions in the README file to step 7.

-3) Apply changes described in step 7, but only up to
version 3.8.0.
+3) Apply changes described in step 7, but only up to and
not including
version 3.8.0.

 4) Apply the MySQL 4.0->4.1 schema changes. Included in RT
is the script
 etc/upgrade/upgrade-mysql-schema.pl that generates SQL
queries to upgrade
the database's schema. Run it:

-7) Continue from step 7 in the README and apply other
upgrade scripts and
follow
-other steps.
+7) Continue from step 7 in the README and apply other mysql
upgrade
scripts and follow
+remaining steps.

 8) Test everything. The most important parts you have to
test:
 * binary attachments, like docs, PDFs, and images
------------------------------------

Has any one else seen this issue, or have any suggestions to
resolve this problem?

Any advice / help is greatly appreciated.
Thanks for everyone's time and help with RT- Users forum




More information about the rt-users mailing list