Hello everybody.
Currently I am using OpenEMM version 5.03 on CentOS 4.5 and MySQL 4.1.20. I intend to update to 5.1 within the next few days.
Anyway, I have experienced a problem while saving mailings or at least parts of it. If text/html modules contain links either in raw format like "http://example.org/index.php?p1=1&p2=2" or in html format like "<a href='http://example.org/index.php?p1=1&p2=2'>link</a>" saving them takes several minutes(!) until OpenEMM responds and the mailing content is stored into the database.
It seems to me that this may be related to link parsing, because if I try saving simple links, like for example "http://example.org", it works fine (and fast!) most of the time.
Has anyone experienced the same problem and is there any fix or workaround for this? Maybe OpenEMM is set up wrong somehow or the system needs to be modified in any way? Any help on this would be very appreciated.
Thanks for your support and time
daniel
saving mailings containing links takes several minutes
Moderator: moderator
Having the same issue
The same thing is happening to me. When I'm creating a new mailing and I submit my HTML content, it takes forever to submit. It's been going for several minutes already.
Do I have to adjust something on the server?
Thanks,
David
Do I have to adjust something on the server?
Thanks,
David
update on above described issue
Hi,
after updating to the latest release (5.1) I still experience the same behaviour as described in the posts above.
As soon as I place a link in content text modules and try to save the mailing it takes minutes to perform this request.
In contrast, if the same link is put in the mailings template there is absolutely no problem. That's a little workaround and sufficient for me right now. But in this way you are unable to take advantage of the template-system, because the dynamic content, in my case a link, has to be 'hard-wired' via the template. In other words I have to change the template every time I want to change content.
Cheers
Daniel
after updating to the latest release (5.1) I still experience the same behaviour as described in the posts above.
As soon as I place a link in content text modules and try to save the mailing it takes minutes to perform this request.
In contrast, if the same link is put in the mailings template there is absolutely no problem. That's a little workaround and sufficient for me right now. But in this way you are unable to take advantage of the template-system, because the dynamic content, in my case a link, has to be 'hard-wired' via the template. In other words I have to change the template every time I want to change content.
Cheers
Daniel
template example
Hi Alex,
thanks for your offer to help. Below you can see two templates. One for a text-version the other one for an html-version of the mailing. No target specific content is provided.
Text-Version:
HTML-Version:
The Highlight block is only displayed if the text-module Highlight is filled with content.
You can now see what this is all about. Because I want to dynamically place hyperlinks in html and text-version of a newsletter, hyperlinks have to be of the form http://www.example.org/index.php?param1 ... 2¶m3=3" (later rewritten by OpenEMM as trackable link) to work in both versions. If I now take the hyperlink example from above, put it in the text module Highlight_Link and try to save this text module the problem occurs. This also happens if I modify the mailing template for example and have to save the changes again.
Maybe the follwing description gives you an additional hint. I found another workaround for the described problem. If I put the hyperlink example from above in quotation marks it works fine without any problems. The only flaw with that solution is that links in the text-version are displayed with quotation marks. To get it working this way I had to remove the quotation marks from the template like shown in this example:
I hope this description helps you to understand and reproduce the strange behaviour.
Many, many thanks for your attention. If you need further information just let me know.
Daniel
thanks for your offer to help. Below you can see two templates. One for a text-version the other one for an html-version of the mailing. No target specific content is provided.
Text-Version:
Code: Select all
========================================================================
Beispiel
[agnDYN name="Ausgabe"/]
========================================================================
[agnTITLE type=2],
[agnDYN name="Anschreiben"/]
Gruß
Bsp.-Team
[agnDYN name="Highlight"]
[agnDVALUE name="Highlight"]
====================
[agnDYN name="Highlight_Text"/]
[agnDYN name="Highlight_Link"/]
------------------------------------------------------------------------
[/agnDYN name="Highlight"]
Code: Select all
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Newsletter</title>
</head>
<body>
<table width="600" cellpadding="10" cellspacing="10" border="0">
<tr>
<td>
<table width="560" cellspacing="0" cellpadding="0">
<tr>
<td class="header" width="558" height="68" valign="top">
<img src="[agnIMAGE name="example"]" width="196" height="58" border="0" alt="example" />
</td>
</tr>
<tr>
<td valign="top" align="right" height="16">
<span style="color: #333;">[agnDYN name="Ausgabe"/]</span>
</td>
</tr>
<tr>
<td class="border" valign="top" height="60" bgcolor="#e6e5e5">
<table class="container" width="524" cellpadding="0" cellspacing="0" border="0">
<tr>
<td>
<p class="text">
[agnTITLE type=2],
<p>
[agnDYN name="Anschreiben"/]
</p>
<p>
Gruß<br />
Bsp.-Team
[agnDYN name="Highlight"]
<p>[agnDVALUE name="Highlight"/]</p>
<p>
<img src="[agnIMAGE name="highlight"]" width="140" height="122" border="0" alt="Highlight Bild" />
<p> [agnDYN name="Highlight_Text"/]
<p>
<a href="[agnDYN name="Highlight_Link"/]" title="">mehr</a>
<p><br /> </p>
[/agnDYN name="Highlight"]
<!-- beliebige weitere Text-Module -->
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
You can now see what this is all about. Because I want to dynamically place hyperlinks in html and text-version of a newsletter, hyperlinks have to be of the form http://www.example.org/index.php?param1 ... 2¶m3=3" (later rewritten by OpenEMM as trackable link) to work in both versions. If I now take the hyperlink example from above, put it in the text module Highlight_Link and try to save this text module the problem occurs. This also happens if I modify the mailing template for example and have to save the changes again.
Maybe the follwing description gives you an additional hint. I found another workaround for the described problem. If I put the hyperlink example from above in quotation marks it works fine without any problems. The only flaw with that solution is that links in the text-version are displayed with quotation marks. To get it working this way I had to remove the quotation marks from the template like shown in this example:
Code: Select all
<a href=[agnDYN name="Highlight_Link"/] title="">mehr</a>Many, many thanks for your attention. If you need further information just let me know.
Daniel
additional example
Hello Alex,
I just reproduced the same behaviour just by creating an empty new mailing, without a special template and simply putting a hyperlink like http://www.example.org/index.php?param1=1¶m2=2 into the default text module named HTML-Version.
Again, saving takes several minutes.
Daniel
I just reproduced the same behaviour just by creating an empty new mailing, without a special template and simply putting a hyperlink like http://www.example.org/index.php?param1=1¶m2=2 into the default text module named HTML-Version.
Again, saving takes several minutes.
Daniel
Hi,
could you look into your logfiles, if any Exceptions are thrown when you save this textblock?
Have a look at console_stdout.log and console_stderr.log.
What happens when you start this link with a space, so that the "h" of http ist not the first character? AFAIK browsers strip of any leading or trailing spaces.
Like (leave out the [ ]):
?
greets
Alex
_________________
The OpenEMM Team
could you look into your logfiles, if any Exceptions are thrown when you save this textblock?
Have a look at console_stdout.log and console_stderr.log.
What happens when you start this link with a space, so that the "h" of http ist not the first character? AFAIK browsers strip of any leading or trailing spaces.
Like (leave out the [ ]):
Code: Select all
[ http://www.example.org/index.php?param1=1¶m2=2¶m3=3]greets
Alex
_________________
The OpenEMM Team
can this be a possible reason?
Hi Alex,
I found nothing unusual in the file console_stderr.log, but I when I looked into console_stdout.log I found these entries:
Especially these lines seem to be interesting:
It seems like OpenEMM tries to load content from an URL if a pure hyperlink is given in a text_module - like inserting content via an external URL. For me this looks like a kind of interface to load external content into my template.
Of course in this example OpenEMM gets a connection time-out because the given URL is non existent. But I also tried this with real world examples and got the same error. What do I have to configure so that OpenEMM is able to connect to external sources?
Anyway, is there a way to prevent OpenEMM to load external content? This feature does not seem to be very useful for our needs.
Greetings
Daniel
I found nothing unusual in the file console_stderr.log, but I when I looked into console_stdout.log I found these entries:
Code: Select all
31.07 (16:28:55) MailingComponentImpl - loadContentFromURL: Connection timed out
2007-07-31 16:28:55,338 - loadContentFromURL: Connection timed out
31.07 (16:28:55) MailingComponentImpl - loadContentFromURL: loaded http://www.example.org/index.php?param1=1¶m2=2¶m3=3
2007-07-31 16:28:55,338 - loadContentFromURL: loaded http://www.example.org/index.php?param1=1¶m2=2¶m3=3
Hibernate: insert into rdir_url_tbl (company_id, action_id, measure_type, relevance, shortname, mailing_id, full_url) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into dyn_content_tbl (company_id, dyn_content, dyn_order, target_id) values (?, ?, ?, ?)
Hibernate: update rdir_url_tbl set mailing_id=?, full_url=? where url_id=?
Hibernate: update dyn_content_tbl set dyn_name_id=?, dyn_order=? where dyn_content_id=?
Hibernate: select mailing0_.mailing_id as mailing1_9_, mailing0_.company_id as company2_9_, mailing0_.campaign_id as campaign3_9_, mailing0_.shortname as shortname9_, mailing0_.description as descript5_9_, mailing0_.mailing_type as mailing6_9_, mailing0_.is_template as is7_9_, mailing0_.needs_target as needs8_9_, mailing0_.mailtemplate_id as mailtemp9_9_, mailing0_.mailinglist_id as mailing10_9_, mailing0_.deleted as deleted9_, mailing0_.archived as archived9_, mailing0_.target_expression as target13_9_, mailing0_.creation_date as creation14_9_ from mailing_tbl mailing0_ where mailing0_.mailing_id=? and mailing0_.company_id=? and mailing0_.deleted<>1
Hibernate: delete from mailing_mt_tbl where mailing_id=?
Hibernate: insert into mailing_mt_tbl (mailing_id, mediatype, param) values (?, ?, ?)
31.07 (16:28:55) MailingContentAction - change content of mailing: 25
2007-07-31 16:28:55,345 - change content of mailing: 25
Hibernate: select mailing0_.mailing_id as mailing1_9_, mailing0_.company_id as company2_9_, mailing0_.campaign_id as campaign3_9_, mailing0_.shortname as shortname9_, mailing0_.description as descript5_9_, mailing0_.mailing_type as mailing6_9_, mailing0_.is_template as is7_9_, mailing0_.needs_target as needs8_9_, mailing0_.mailtemplate_id as mailtemp9_9_, mailing0_.mailinglist_id as mailing10_9_, mailing0_.deleted as deleted9_, mailing0_.archived as archived9_, mailing0_.target_expression as target13_9_, mailing0_.creation_date as creation14_9_ from mailing_tbl mailing0_ where mailing0_.mailing_id=? and mailing0_.company_id=? and mailing0_.deleted<>1
Hibernate: select target0_.target_id as target1_0_, target0_.company_id as company2_0_, target0_.target_description as target3_0_, target0_.target_shortname as target4_0_, target0_.target_representation as target5_0_, target0_.target_sql as target6_0_ from dyn_target_tbl target0_ where target0_.company_id=?
31.07 (16:28:55) OpenSessionInViewFilter - Closing single Hibernate Session in OpenSessionInViewFilter
Code: Select all
31.07 (16:28:55) MailingComponentImpl - loadContentFromURL: Connection timed out
2007-07-31 16:28:55,338 - loadContentFromURL: Connection timed out
31.07 (16:28:55) MailingComponentImpl - loadContentFromURL: loaded http://www.example.org/index.php?param1=1¶m2=2¶m3=3
2007-07-31 16:28:55,338 - loadContentFromURL: loaded http://www.example.org/index.php?param1=1¶m2=2¶m3=3
Of course in this example OpenEMM gets a connection time-out because the given URL is non existent. But I also tried this with real world examples and got the same error. What do I have to configure so that OpenEMM is able to connect to external sources?
Anyway, is there a way to prevent OpenEMM to load external content? This feature does not seem to be very useful for our needs.
Greetings
Daniel
Last edited by daniel on Tue Jul 31, 2007 4:10 pm, edited 1 time in total.
I would like to know if there is a configuration option for this connection time-out. If so a quick solution for us would be to configure a very short connection time-out. Because as kind of fall back in case of a timed out connection OpenEMM uses the URL as text-module content. This is exactly what I expected OpenEMM to do and what we need in our case.
Thanks for your support!
Daniel
Thanks for your support!
Daniel
Hi,
the timeout cannot be configured yet. OpenEMM tries to determine which mimetype this URL has, because there is no additional information about its type in this textmodule. If you write something like <a href="www... OpenEMM would have recognised it as a hyperlink and would therefore not try to connect to this server.
What about your firewall setting? The connection timeout is set to 5 seconds, but getting this timeout would mean the server exists but is not reachable. So I guess you have to adjust your firewall properties to let OpenEMM connect to the outside on port 80.
hth
Alex
_________________
The OpenEMM Team
the timeout cannot be configured yet. OpenEMM tries to determine which mimetype this URL has, because there is no additional information about its type in this textmodule. If you write something like <a href="www... OpenEMM would have recognised it as a hyperlink and would therefore not try to connect to this server.
What about your firewall setting? The connection timeout is set to 5 seconds, but getting this timeout would mean the server exists but is not reachable. So I guess you have to adjust your firewall properties to let OpenEMM connect to the outside on port 80.
hth
Alex
_________________
The OpenEMM Team
seems to be solved
Hi Alex,
thank you very much for your help. We configured our firewall an finally it works
Maybe configuring the firewall (if present) to enable OpenEMM to connect to the internet should be a little side note in the installation instructions. I'm not quite sure, but I think I haven't read about it there.
Again, thanks for your support.
Daniel
thank you very much for your help. We configured our firewall an finally it works
Maybe configuring the firewall (if present) to enable OpenEMM to connect to the internet should be a little side note in the installation instructions. I'm not quite sure, but I think I haven't read about it there.
Again, thanks for your support.
Daniel