<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="-1"><font face="Arial">Hello again,<br>
<br>
back to this issue - it happened again.<br>
Please give me directions on how to give you enough information to
analyse the problem...<br>
Cut short: mails do arrive in the tracker, but are not displayed - no
error message (at least not where i could find it), <br>
all I see in the tracker are ID, queue, sender address - other fields
are simply empty or not shown - no content, no header...<br>
<br>
Here's my approach to analyse the problem:<br>
1. Got the ticket number -> look it up in table Tickets, all data is
there<br>
<br>
2. Take Creator ID from Tickets table and look it up in the
Transactions table -> found a couple of RT::Group entries, but look
for RT::Ticket entry with the same date to identify the Attachments
-> found one "Create" record where ObjectId equals the Ticket ID<br>
<br>
3. Take the Transaction ID and look it up in the Attachments table<br>
<br>
4. found 3 entries, <br>
* one with the Ticket Subject and Parent 0 -> ContentType =
multipart/alternative, ContentEncoding NULL, Content NULL, Headers okay<br>
* one with the previous one as ParentID -> "text/plain",
ContentEncoding "none", Content: BLOB -> the body of the message!,
Headers okay<br>
* one another with the first one as Parent ID -> "text/html",
ContentEncoding "none", Content: BLOB -> again, the message, this
time in valid HTML, Headers seem okay as well<br>
<br>
So - it seems the text/plain and text/html part are correctly in the DB.<br>
<br>
I have compared the results with a ticket that is shown without
problem, can't find any difference except that the Headers in the
erroneous mail start with "X-Originalarrivaltime" instead of the
MIME-Version.<br>
<br>
Thank you for taking the time....<br>
<br>
Bernhard<br>
</font></font><br>
Am 07.10.2009 18:26, Jesse Vincent schrieb:
<blockquote cite="mid:20091007162610.GM1635@bestpractical.com"
type="cite">
<pre wrap="">
On Wed, Oct 07, 2009 at 04:12:26PM +0200, Bernhard wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi Jesse,
thank you for responding - after playing around a bit I found the following:
For the one ticket with attachment, I find only the filename and the
file itself in the attachments table, all other information is empty.
For the other ticket I find nothing at all in the attachments table -
but that could also be because I have no idea how to get to the
corresponding Attachments ID from the ticket number...
Unless you can point me somewhere, I will just check if it happens again...
</pre>
</blockquote>
<pre wrap=""><!---->
Absent something showing up in the logs as it happens, I'm at a bit of a
loss.
-jesse
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Bernhard Hansbauer
System Administrator
<a class="moz-txt-link-abbreviated" href="mailto:bernhard.hansbauer@greentube.com">bernhard.hansbauer@greentube.com</a>
-------------------------
Greentube I.E.S. AG
Mariahilfer Straße 47/1/102
A-1060 Wien
FN 197003k, HG Wien
Tel: +43 1 494 50 56 - 30
<a class="moz-txt-link-freetext" href="http://www.greentube.com">http://www.greentube.com</a>
-------------------------
------------------------------------
Internet Email Confidentiality Footer
------------------------------------
Privileged/confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to this person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by replying. Please make it known immediately f you or your employer does not consent to the medium of e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of my firm shall be understood as neither given nor endorsed by it.</pre>
</body>
</html>