No idea what could be wrong, or how to fix it.
FreeBSD 4.6, mysql 3.23.51, rt 2.0.13
RT was humming along just fine, or at least it seemed
to be. Had to reboot the server.
Comes back up, RT displays the transactions fine, but the
ticket bodies are gone. New tickets create, the data
appears in the attachment table, but no display.
mysiamchk doesn’t give me any errors on the tables, and
the data is most definitely in the Attachments table.
I restored a day old database just to make sure that
was created with mysqlhotcopy, and it’s doing the exact
same thing, except that of course, the highest ticket
is less that the current one.
There are no error message in the httpd-error log
file, nor anything in the /var/log/rt directory.
Of course, 10k of tickets are in here, so I"m a bit anxious…