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 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com