Hi All,
I found this in the documentation:
1. There is also a difference between the Original size and the Size in e-mail. The reason is that the software converts the file attachment into a sendable format (ASCII-Format) which is about 30 to 40 per cent larger than the original format.
2.Please be aware that the maximum file size is 1 MByte (due to the default settings of the MySQL database for BCOB data fields).
But I'm unable to attach a 448Kb PDF file because I receive "The file you want to upload exceeds the maximum file size for attachments." error.
If I put this pdf into zip it accepts the attachment.
Why it accept the compressed file?
How can I increase the attachment's size?
Can I change the data tpye of the field in the opemm's database to Large BLOB?
Thank you in advance
BG
Normal file attachment size
Moderator: moderator
-
maschoff
- Site Admin
- Posts: 2628
- Joined: Thu Aug 03, 2006 10:20 am
- Location: Munich, Germany
- Contact:
We don't know if this is a bug in MySQL, but it behaves differently if you store a PDF file instead of a file with a different format.
You can change the code to set the limit higher but we know from experience that in this case at least some versions of MySQL will cause an exception.
You can change the code to set the limit higher but we know from experience that in this case at least some versions of MySQL will cause an exception.
OpenEMM Maintainer
-
MartinBerlin
- Posts: 4
- Joined: Sat Feb 20, 2010 9:44 am
Dear all
I am very surprised. This thread is now more than two years old and still the constraint about pdf attachment size is in place?
Otherwise, I think, OpenEMM is a very sophisticated application, but a mailing software with attachment constraints like this renders itself useless to a certain degree. Don't you agree?
I am very surprised. This thread is now more than two years old and still the constraint about pdf attachment size is in place?
Otherwise, I think, OpenEMM is a very sophisticated application, but a mailing software with attachment constraints like this renders itself useless to a certain degree. Don't you agree?
Re: Normal file attachment size
Since OpenEMM 6.2 you can change the maximum size for attachments in the emm.properties file.
You find it here: /home/openemm/webapps/core/WEB-INF/classes/emm.properties
Please note, that you should also check your MySQL my.cnf (/etc/my.cnf) for the max_allowed_packet setting.
In my case, OpenEMM / Java threw a nice error: java.lang.IllegalStateException: forward() not allowed after buffer has committed.
Increasing the MySQL setting helped to fix this:
[mysqld]
# for openemm
max_allowed_packet=16M
Then just restart MySQL (/etc/init.d/mysql restart).
Hope this helps. I'm updating this old thread, because the info is missing here and the feature is pretty new.
You find it here: /home/openemm/webapps/core/WEB-INF/classes/emm.properties
Please note, that you should also check your MySQL my.cnf (/etc/my.cnf) for the max_allowed_packet setting.
In my case, OpenEMM / Java threw a nice error: java.lang.IllegalStateException: forward() not allowed after buffer has committed.
Increasing the MySQL setting helped to fix this:
[mysqld]
# for openemm
max_allowed_packet=16M
Then just restart MySQL (/etc/init.d/mysql restart).
Hope this helps. I'm updating this old thread, because the info is missing here and the feature is pretty new.