In-Portal Issue Tracker - In-Portal CMS
|
Viewing Issue Advanced Details |
|
ID:
|
Category:
|
Type:
|
Reproducibility:
|
Date Submitted:
|
Last Update:
|
1348 |
[In-Portal CMS] Email Templates |
bug report |
always |
2012-07-10 13:42 |
2012-07-25 05:29 |
|
Reporter:
|
alex |
Platform:
|
|
|
Assigned To:
|
alex |
OS:
|
|
|
Priority:
|
normal |
OS Version:
|
|
|
Status:
|
closed |
Product Version:
|
5.2.0-B1 |
|
Product Build:
|
|
Resolution:
|
fixed |
|
|
ETA:
|
none |
Fixed in Version:
|
5.2.0 |
|
Reference:
|
https://groups.google.com/d/topic/in-portal-bugs/hJPShO_2wWw/discussion |
Change Log Message:
|
Fixes e-mail from mailing list not being added to E-mail Log |
Estimate Points:
|
2 |
|
Summary:
|
0001348: EmailLog doesn't store Emails with Very Long Body when sent via Mailing List |
Description:
|
In 5.2.0 we have introduced complete Email Logging which is quite useful.
However, there seems to be a bug in Logging emails with very Long Email Body that are sent via Mailing List functionality. In particular this happens when we send emails with HTML in it (see attached).
Problem lead to the amount of data being stored in LogData column of EmailQueue table. Currently this field is a TEXT which is not enough to store Serialized logging data (html + plain versions) in it. In total ti takes (around 130kb).
Changing column data type from TEXT to LONGTEXT didn't solve it because serialized array, that has new line symbols in it is correctly stored only in LONGBLOB column.
Need to investigate what actually happens. |
Steps To Reproduce:
|
|
Additional Information:
|
Need to:
1. hide columns with mailing list text from list by default
2. show nice mailing list preview on editing (like in e-mail log detail page) |
Relationships | related to | 0001425 | resolved (5.2.1) | alex | Incorrect queued e-mail count in "Mailing List" section | child of | 0001228 | closed (5.2.0) | alex | Email Log Rotation and New Fields |
|
Attached Files:
|
Test-MailingLog.txt (85,680) 2012-07-10 13:42 http://tracker.in-portal.org/file_download.php?file_id=1728&type=bug long_email_queueing_problem_fix.patch (6,925) 2012-07-18 09:14 http://tracker.in-portal.org/file_download.php?file_id=1762&type=bug |
|
Issue History |
Date Modified |
Username |
Field |
Change |
2012-11-05 08:17 |
alex |
Relationship added |
related to 0001425 |
2012-07-25 05:29 |
alex |
Note Added: 0004827 |
|
2012-07-25 05:29 |
alex |
Status |
resolved => closed |
2012-07-18 09:18 |
alex |
Note Added: 0004805 |
|
2012-07-18 09:18 |
alex |
Status |
reviewed and tested => resolved |
2012-07-18 09:18 |
alex |
Fixed in Version |
=> 5.2.0 |
2012-07-18 09:18 |
alex |
Resolution |
open => fixed |
2012-07-18 09:18 |
alex |
Assigned To |
!COMMUNITY => alex |
2012-07-18 09:18 |
alex |
Changeset attached |
5.2.x r15461 |
2012-07-18 09:18 |
alex |
Additional Information Updated |
bug_revision_view_page.php?rev_id=1031#r1031 |
2012-07-18 09:16 |
alex |
Note Added: 0004804 |
|
2012-07-18 09:16 |
alex |
Status |
needs testing => reviewed and tested |
2012-07-18 09:16 |
alex |
Assigned To |
=> !COMMUNITY |
2012-07-18 09:16 |
alex |
Developer |
=> alex |
2012-07-18 09:16 |
alex |
Status |
active => needs testing |
2012-07-18 09:14 |
alex |
File Added: long_email_queueing_problem_fix.patch |
|
2012-07-18 02:20 |
alex |
Note Edited: 0004800 |
bug_revision_view_page.php?bugnote_id=0004800#r1029 |
2012-07-18 02:19 |
alex |
Note Added: 0004800 |
|
2012-07-10 13:43 |
alex |
Relationship added |
child of 0001228 |
2012-07-10 13:42 |
alex |
New Issue |
|
2012-07-10 13:42 |
alex |
File Added: Test-MailingLog.txt |
|
2012-07-10 13:42 |
alex |
Reference |
=> https://groups.google.com/d/topic/in-portal-bugs/hJPShO_2wWw/discussion |
2012-07-10 13:42 |
alex |
Change Log Message |
=> Fixes e-mail from mailing list not being added to E-mail Log |
2012-07-10 13:42 |
alex |
Estimate Points |
=> 2 |
Notes |
|
(0004800)
|
alex
|
2012-07-18 02:19
(edited on: 2012-07-18 02:20) |
|
Problem was because of "& copy ;" (I've added some spaces around to prevent Mantis from encoding it too) symbol in HTML e-mail was converted to symbol with 163 ASCII code for plain text e-mail version but wasn't then UTF-8 encoded. Actual e-mail was sent out in UTF-8 encoding.
In a result we had 2 problems with that symbol in plain text e-mail version:
1. symbol was displayed as "white square" or "black diamond with question mark in the middle"
2. when INSERT statement was made into EmailQueue database table then data after that symbol (in LogData column) wasn't stored to database.
|
|
|
(0004804)
|
alex
|
2012-07-18 09:16
|
|
Will test all together later. |
|
|
(0004805)
|
alex
|
2012-07-18 09:18
|
|
Fix committed to 5.2.x branch. Commit Message:
Fixes 0001348: EmailLog doesn't store Emails with Very Long Body when sent via Mailing List |
|
|
(0004827)
|
alex
|
2012-07-25 05:29
|
|
Since 5.2.0 version was released. |
|