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.
- 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.
- 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