Bring out your dead (tickets)

Hi,

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

rt --limit-status=dead --summary
id Stat Queue Subject
Requestor

Nothing returned, nor in the web interface (and I know this Used To
Work).

However:

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?

Scott

scott@xs4all.net wrote:

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.

http://fsck.com/rtfm/article.html?id=3#229

�|� http://www.bestpractical.com/rt – Trouble Ticketing. Free.