In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Viewing Issue Simple Details Jump to Notes ] Wiki ] View Advanced ] Issue History ] Print ]
ID Category Type Reproducibility Date Submitted Last Update
0001348 [In-Portal CMS] Email Templates bug report always 2012-07-10 13:42 2012-07-25 05:29
Reporter alex View Status public Project Name In-Portal CMS
Assigned To alex Developer
Priority normal Resolution fixed Fixed in Version 5.2.0
Status closed Product Version 5.2.0-B1 Target Version 5.2.0
Time EstimateNo estimate
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.
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)
Tags No tags attached.
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
Attached Files txt file icon Test-MailingLog.txt [^] (85,680 bytes) 2012-07-10 13:42 [Show Content]
patch file icon long_email_queueing_problem_fix.patch [^] (6,925 bytes) 2012-07-18 09:14 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to 0001425resolved (5.2.1)alex Incorrect queued e-mail count in "Mailing List" section 
child of 0001228closed (5.2.0)alex Email Log Rotation and New Fields 

-  Notes
User avatar (0004800)
alex (manager)
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.

User avatar (0004804)
alex (manager)
2012-07-18 09:16

Will test all together later.
User avatar (0004805)
alex (manager)
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
User avatar (0004827)
alex (manager)
2012-07-25 05:29

Since 5.2.0 version was released.

- Related Changesets
In-Portal CMS: 5.2.x r15461
Timestamp: 2012-07-18 09:18:30
Author: alex
Details ] Diff ]
Fixes 0001348: EmailLog doesn't store Emails with Very Long Body when sent via Mailing List
mod - /in-portal/branches/5.2.x/core/admin_templates/mailing_lists/mailing_list_edit.tpl Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/install_schema.sql Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/upgrades.sql Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/utility/email_send.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/mailing_lists/mailing_list_eh.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/mailing_lists/mailing_lists_config.php Diff ] File ]

- 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 View Revisions
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 View Revisions
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



Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker