Message body

RT Users
1

Hi,

Does anyone know where RT2 stores the message bodies?

I just convert RT1 to RT2 using import script. It’s done without any
errors in the logs or command lines. But all message bodies are blanked.
Could anyone please help? I am using rt-2-0-7. Only the
transactions shows. Thanks much.

Sherrill
Sherrill (Pei-chih) Verbrugge
spv@gospelcom.net
ext. 273

2

RT2 stores its messages in the db I believe. I’m about to run this import myself, so if you work out where they went to I’d be very interested to know (incase it happens to me!).

Regards,
Mat.On Tue, Sep 18, 2001 at 11:56:40AM -0400, Sherrill (Pei-chih) Verbrugge wrote:

Hi,

Does anyone know where RT2 stores the message bodies?

I just convert RT1 to RT2 using import script. It’s done without any
errors in the logs or command lines. But all message bodies are blanked.
Could anyone please help? I am using rt-2-0-7. Only the
transactions shows. Thanks much.

Sherrill

Sherrill (Pei-chih) Verbrugge
spv@gospelcom.net
ext. 273
http://www.gospelcom.net
http://bible.gospelcom.net

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

3

They are in the Attachments table. Msg content is in the ‘content’ field.

Dave

David C. Troy [dave@toad.net] 410-544-6193 Sales
ToadNet - Want to go fast? 410-544-1329 FAX
570 Ritchie Highway, Severna Park, MD 21146-2925 www.toad.netOn Wed, 19 Sep 2001, Matthew Watson wrote:

RT2 stores its messages in the db I believe. I’m about to run this import myself, so if you work out where they went to I’d be very interested to know (incase it happens to me!).

Regards,
Mat.

On Tue, Sep 18, 2001 at 11:56:40AM -0400, Sherrill (Pei-chih) Verbrugge wrote:

Hi,

Does anyone know where RT2 stores the message bodies?

I just convert RT1 to RT2 using import script. It’s done without any
errors in the logs or command lines. But all message bodies are blanked.
Could anyone please help? I am using rt-2-0-7. Only the
transactions shows. Thanks much.

Sherrill

Sherrill (Pei-chih) Verbrugge
spv@gospelcom.net
ext. 273
http://www.gospelcom.net
http://bible.gospelcom.net

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

4

Dave,

Thanks. For some reasons, my Attachments table is empty after import. I
have practiced this many times with smaller set of data. It only fails
when I use my real RT1 data. I am trying to find out what goes wrong now.

SherrillOn Tue, 18 Sep 2001, David C. Troy wrote:

They are in the Attachments table. Msg content is in the ‘content’ field.

Dave

=====================================================================
David C. Troy [dave@toad.net] 410-544-6193 Sales
ToadNet - Want to go fast? 410-544-1329 FAX
570 Ritchie Highway, Severna Park, MD 21146-2925 www.toad.net

On Wed, 19 Sep 2001, Matthew Watson wrote:

RT2 stores its messages in the db I believe. I’m about to run this import myself, so if you work out where they went to I’d be very interested to know (incase it happens to me!).

Regards,
Mat.

On Tue, Sep 18, 2001 at 11:56:40AM -0400, Sherrill (Pei-chih) Verbrugge wrote:

Hi,

Does anyone know where RT2 stores the message bodies?

I just convert RT1 to RT2 using import script. It’s done without any
errors in the logs or command lines. But all message bodies are blanked.
Could anyone please help? I am using rt-2-0-7. Only the
transactions shows. Thanks much.

Sherrill

Sherrill (Pei-chih) Verbrugge
spv@gospelcom.net

http://www.gospelcom.net
http://bible.gospelcom.net

[snip]

Sherrill (Pei-chih) Verbrugge
spv@gospelcom.net

5

I think that happened to me, too… make sure the path to your
‘transactions’ data is correct in the import script. I think that’s your
trouble.

Best of luck,

Dave

David C. Troy [dave@toad.net] 410-544-6193 Sales
ToadNet - Want to go fast? 410-544-1329 FAX
570 Ritchie Highway, Severna Park, MD 21146-2925 www.toad.netOn Wed, 19 Sep 2001, Sherrill (Pei-chih) Verbrugge wrote:

Dave,

Thanks. For some reasons, my Attachments table is empty after import. I
have practiced this many times with smaller set of data. It only fails
when I use my real RT1 data. I am trying to find out what goes wrong now.

Sherrill

On Tue, 18 Sep 2001, David C. Troy wrote:

They are in the Attachments table. Msg content is in the ‘content’ field.

Dave

=====================================================================
David C. Troy [dave@toad.net] 410-544-6193 Sales
ToadNet - Want to go fast? 410-544-1329 FAX
570 Ritchie Highway, Severna Park, MD 21146-2925 www.toad.net

On Wed, 19 Sep 2001, Matthew Watson wrote:

RT2 stores its messages in the db I believe. I’m about to run this import myself, so if you work out where they went to I’d be very interested to know (incase it happens to me!).

Regards,
Mat.

On Tue, Sep 18, 2001 at 11:56:40AM -0400, Sherrill (Pei-chih) Verbrugge wrote:

Hi,

Does anyone know where RT2 stores the message bodies?

I just convert RT1 to RT2 using import script. It’s done without any
errors in the logs or command lines. But all message bodies are blanked.
Could anyone please help? I am using rt-2-0-7. Only the
transactions shows. Thanks much.

Sherrill

Sherrill (Pei-chih) Verbrugge
spv@gospelcom.net

http://www.gospelcom.net
http://bible.gospelcom.net

[snip]

Sherrill (Pei-chih) Verbrugge
spv@gospelcom.net

http://www.gospelcom.net
http://bible.gospelcom.net

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

6

Dave,

Cool. Thanks for the info. I think my path is too deep. My RT1 path was
11 levels. I move it up to a different location that has only 5 levels
deep. And it works now.

SherrillOn Wed, 19 Sep 2001, David C. Troy wrote:

I think that happened to me, too… make sure the path to your
‘transactions’ data is correct in the import script. I think that’s your
trouble.

Best of luck,

Dave

=====================================================================
David C. Troy [dave@toad.net] 410-544-6193 Sales
ToadNet - Want to go fast? 410-544-1329 FAX
570 Ritchie Highway, Severna Park, MD 21146-2925 www.toad.net

On Wed, 19 Sep 2001, Sherrill (Pei-chih) Verbrugge wrote:

Dave,

Thanks. For some reasons, my Attachments table is empty after import. I
have practiced this many times with smaller set of data. It only fails
when I use my real RT1 data. I am trying to find out what goes wrong now.

Sherrill

On Tue, 18 Sep 2001, David C. Troy wrote:

They are in the Attachments table. Msg content is in the ‘content’ field.

Dave

=====================================================================
David C. Troy [dave@toad.net] 410-544-6193 Sales
ToadNet - Want to go fast? 410-544-1329 FAX
570 Ritchie Highway, Severna Park, MD 21146-2925 www.toad.net

On Wed, 19 Sep 2001, Matthew Watson wrote:

RT2 stores its messages in the db I believe. I’m about to run this import myself, so if you work out where they went to I’d be very interested to know (incase it happens to me!).

Regards,
Mat.

On Tue, Sep 18, 2001 at 11:56:40AM -0400, Sherrill (Pei-chih) Verbrugge wrote:

Hi,

Does anyone know where RT2 stores the message bodies?

I just convert RT1 to RT2 using import script. It’s done without any
errors in the logs or command lines. But all message bodies are blanked.
Could anyone please help? I am using rt-2-0-7. Only the
transactions shows. Thanks much.

Sherrill

Sherrill (Pei-chih) Verbrugge
spv@gospelcom.net

http://www.gospelcom.net
http://bible.gospelcom.net

[snip]

Sherrill (Pei-chih) Verbrugge
spv@gospelcom.net

http://www.gospelcom.net
http://bible.gospelcom.net

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Sherrill (Pei-chih) Verbrugge
spv@gospelcom.net
ext. 273

7

FYI.

I also had this issue, bit it turned out to be because the user I ran the import script as didn’t
have read access to the transactions dir. Interestingly the import script didn’t give any errors.On Wed, Sep 19, 2001 at 09:45:06AM -0400, Sherrill (Pei-chih) Verbrugge wrote:

Dave,

Cool. Thanks for the info. I think my path is too deep. My RT1 path was
11 levels. I move it up to a different location that has only 5 levels
deep. And it works now.

Sherrill

On Wed, 19 Sep 2001, David C. Troy wrote:

I think that happened to me, too… make sure the path to your
‘transactions’ data is correct in the import script. I think that’s your
trouble.

Best of luck,

Dave

=====================================================================
David C. Troy [dave@toad.net] 410-544-6193 Sales
ToadNet - Want to go fast? 410-544-1329 FAX
570 Ritchie Highway, Severna Park, MD 21146-2925 www.toad.net

On Wed, 19 Sep 2001, Sherrill (Pei-chih) Verbrugge wrote:

Dave,

Thanks. For some reasons, my Attachments table is empty after import. I
have practiced this many times with smaller set of data. It only fails
when I use my real RT1 data. I am trying to find out what goes wrong now.

Sherrill

On Tue, 18 Sep 2001, David C. Troy wrote:

They are in the Attachments table. Msg content is in the ‘content’ field.

Dave

=====================================================================
David C. Troy [dave@toad.net] 410-544-6193 Sales
ToadNet - Want to go fast? 410-544-1329 FAX
570 Ritchie Highway, Severna Park, MD 21146-2925 www.toad.net

On Wed, 19 Sep 2001, Matthew Watson wrote:

RT2 stores its messages in the db I believe. I’m about to run this import myself, so if you work out where they went to I’d be very interested to know (incase it happens to me!).

Regards,
Mat.

On Tue, Sep 18, 2001 at 11:56:40AM -0400, Sherrill (Pei-chih) Verbrugge wrote:

Hi,

Does anyone know where RT2 stores the message bodies?

I just convert RT1 to RT2 using import script. It’s done without any
errors in the logs or command lines. But all message bodies are blanked.
Could anyone please help? I am using rt-2-0-7. Only the
transactions shows. Thanks much.

Sherrill

Sherrill (Pei-chih) Verbrugge
spv@gospelcom.net

http://www.gospelcom.net
http://bible.gospelcom.net

[snip]

Sherrill (Pei-chih) Verbrugge
spv@gospelcom.net

http://www.gospelcom.net
http://bible.gospelcom.net

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

–

Sherrill (Pei-chih) Verbrugge
spv@gospelcom.net
ext. 273
http://www.gospelcom.net
http://bible.gospelcom.net

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Matthew Watson
Development, Netspace Online Systems
mwatson@netspace.net.au