Konstantin, Is anything strange showing up in your apache error log?
On Mon, Nov 19, 2007 at 04:57:15PM +0300, Konstantin Naryzhniy wrote: > 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 -- _______________________________________________ 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