Hello everyone! Here's my current setup:
RT 3.6.1 Perl v5.8.8 under linux Apache v1.27; DBIx::SearchBuilder v1.48; HTML::Mason v1.35; mod_perl v1.29; Mysql 5 Approx 20 queues, 50 000 tickets First of all, I've failed to find any solution in the lists, so I post this question. Recently weird things started to happen: random tickets in WebUI were not displayed further than a certain transaction in the middle. This happened both in Display.html and History.html. First thing I did, according to the Lists was reversing the history display order. Guess what? The history kept displaying in that case only till this very transaction! So, for example, if there are transactions 1,2,3,4,5 defined for a ticket, I could see transactions 1 and 2 in direct history order, and transactions 5 and 4 in the reverse one! Given that, I tried simply to remove transaction 3 using the Shredder. In some cases that helped, in others not. No 100% solution here. I looked directly into the mysql database and found out that all the transactions that are not displayed are stored and are stored correctly, as their respective attachments. They just are not displayed. Then, I tried to consecutively remove all the page customizations I store in /opt/rt3/local/html folder to see which one causes trouble. None of them do. Even the neat one from the wiki: http://wiki.bestpractical.com/view/HideTransactions does not seem to cause the issue)) Then, I tried to look into the ShowHistory module from /opt/rt3/share/html/Ticket/ to see how this works. I transferred the following lines that choose the ticket's transactions to a separate script: my $Transactions = new RT::Transactions($session{'CurrentUser'}); if ($Tickets) { while (my $t = $Tickets->Next) { $Transactions->LimitToTicket($t->id); } } else { $Transactions = $Ticket->Transactions; } I had my script return the Count of transactions for the ticket loaded: it is the same as the mysql query result. So, I do not know where to go from here. Would really appreciate any help or directions. Thank you very much! Sincerely, Kostya
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
