Location of Email content?

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
12/17/2008 10:44:49 AM
Gravatar
Total Posts 11

Location of Email content?

Which table holds the content of Emails created/sent by the site?

I'm trying to track down the source of an email send by one of the pages on my site (I've inherited this site, so I don't know all the intricacies of all the pages).

Which DB Table holds the body of the emails sent from such a page?

Thanks,
-tomas

12/17/2008 10:50:55 AM
Gravatar
Total Posts 18439

Re: Location of Email content?

There is no such table. Emails are generated using template files from beneath /Data/MessageTemplates, depending on the feature.

If you tell about the contents of the email then I will know which feature is sending it.

Best,

Joe

12/17/2008 11:10:00 AM
Gravatar
Total Posts 11

Re: Location of Email content?

It's a message that is created through a "Edit Email Template" link.

The message was created by my predecessor and has content similar to:

"Thank you for your interest in <My Product Name>. We are interested in making your trial as smooth as possible.
<LINK>Download PRODUCT</link> 30-day trial."

My frist impression was that these messages are stored in the DB. Per your earlier reply, I searched the entire directory tree but can't seem to find this message (the one containing the snippet above, or the actual message I'm trying to locate).

I'm hoping you can shed some more light on this.

Thanks for your help!
-tomas

12/17/2008 11:15:14 AM
Gravatar
Total Posts 18439

Re: Location of Email content?

Ok, you're talking about the newsletter feature, it does store its templates in the db in the mp_LetterHtmlTemplates table, but you can edit the templates right from the web ui, you don't need to go into the db. Click the key icon then click the Newsletter Administration link and have a look around.

Hope it helps,

Joe

12/17/2008 12:03:07 PM
Gravatar
Total Posts 11

Re: Location of Email content?

OK. Found what I needed (I broke down and looked at the code).

The "Edit Email Template" link is part of the ModuleTitle control. It uses the EditHtml.aspx to edit what becomes an outgoing email. The edited content is stored in the mp_HtmlContent table.

So I was able to identify the email in question, and backtrace to the offending custom-coded module. Update some logic, and, Viola! Sales people are happy (they hate it when their leads go to a competing salesperson, for some reason).

Thanks,
-tomas

 

You must sign in to post in the forums. This thread is closed to new posts.