View Issue Details

IDProjectCategoryView StatusLast Update
0015420phpList 3 applicationHTML Email Supportpublic20-04-10 15:10
Reporterbeuss Assigned To 
Status resolvedResolutionfixed 
Product Version2.10.10 
Target Version2.10.12Fixed in Version2.10.12 
Summary0015420: phplist_message message field should be (at least) mediumtext
DescriptionWhen sending large HTML messages, they are truncated to 65535 chars. Which can be annoying since this limit is easily reached with inline style generated by some crappy tools.
Additional InformationUntil recently, database creation script was only compatible with MySQL so here is a patch that fixes it.
I saw on SVN that it has been rewritten to be more "standard". If so, mediumtext would break compatibility with other RDBMS... Maybe it is time to have a separate SQL script for different SQL engines...
TagsNo tags attached.


08-03-10 11:02


phplist-medium-text-message.patch (404 bytes)   
--- phplist.sql	2010-03-08 11:52:13.000000000 +0100
+++ phplist.sql.orig	2010-03-08 11:51:24.000000000 +0100
@@ -683,7 +683,7 @@
   `fromfield` varchar(255) NOT NULL default '',
   `tofield` varchar(255) NOT NULL default '',
   `replyto` varchar(255) NOT NULL default '',
-  `message` mediumtext,
+  `message` text,
   `footer` text,
   `entered` datetime default NULL,
   `modified` timestamp NOT NULL,


20-04-10 15:10

administrator   ~0050951

just changing it in the structure is only one thing. It should actually be changed in the upgrade as well.

For now, just changed in structure, so it will only apply to new installations.