For some reason, tickets with status of dead are no longer showing up
in queries through the web interface nor through the command line,
however, a direct MySQL query works fine.
The only recent change I’ve made to the system was the conversion of
our tables to InnoDB format – but I can not see why that would matter
rt --limit-status=dead --summary
id Stat Queue Subject
Nothing returned, nor in the web interface (and I know this Used To
mysql> select id,Subject from Tickets where Status=“dead”;
| id | Subject
| 20452 | Warning: could not send message for past 1 day
| 20822 | Warning: could not send message for past 1 day
| 29906 | Undelivered Mail Returned to Sender -01_Verwijsfor
| 63232 | Return receipt
| 64515 | Return receipt
| 66564 | Return receipt
And so on and so forth.
So, what’s up? Any ideas?