View Issue Details

IDProjectCategoryView StatusLast Update
0015420phplist applicationHTML Email Supportpublic20-04-10 14:10
Reporterbeuss 
PrioritynormalSeveritymajorReproducibilityalways
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.

Activities

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,

michiel

20-04-10 14:10

manager   ~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.