voodoodyne / subetha

SubEtha Mail is a J2EE-based mailing list manager
Other
13 stars 6 forks source link

Data truncation: Data too long for column 'contentType' at row 1 #55

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
when send message with attachement with big name...
in the content type they can add the file name...
so the content-type can be larger than 255...

What is the expected output? What do you see instead?
database insertion of the message...
instead the message is rejected directly without smtp error message (connection 
close).

What version of the product are you using? On what operating system?
last git

Please provide any additional information below.

i've resized the database field to 550... but is not the good solution... i 
think the most elegante solution is to analyse content type and remove extra  
subtype (http://www.w3.org/Protocols/rfc1341/4_Content-Type.html) before insert 
to database...

Original issue reported on code.google.com by mcarbonneaux on 27 Jul 2014 at 4:16

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
Sample of content-type:
application/vnd.openxmlformats-officedocument.wordprocessingml.document;    name=   "
=?iso-8859-1?q?point_1_-_r_6_-xxxxxxxxxxx-xxxxxxxxxxxx_du_xxx_de_i'xxx_su?= 
=?iso-8859-1?q?r_le_xxxxxx_de_xxxxxxx_des_xxxxxx_de_xxx_=e0_xxxxxxxxxxx_g?= 
=?iso-8859-1?q?roup_-_recueil_de_l'avis.docx?="

Original comment by mcarbonneaux on 27 Jul 2014 at 4:29